Lasso#
EDBは、 Lassoと呼ばれる小型のマルチプラットフォームアプリケーションを開発しました。 Lassoは、 PostgresおよびBarmanなどのその他の関連サポートされているソフトウェアが実行されているシステムで関連する診断データを安全に収集できます。
PostgresがインストールされていないシステムでLassoを実行して、基になるオペレーティングシステムに関するすべての関連情報を収集することもできます。
ご使用のオペレーティングシステムの特定の情報を参照してください。
重要
Lassoはデータに影響を与えることはできません。 Postgresサーバーから統計と診断情報を収集しますが、ワークロードに微妙な影響を与えます。 Postgresユーザーテーブルの行から*実際のデータは収集されません。 [^1]
[^1] 収集された診断データファイルは、検査に使用できます。
Lassoは、EDBのエンジニアがシステムに関する一元化および標準化された情報ソースを持つことができるため、サポート業務にとって重要です。この機能により、解決時間とサービスの品質が大幅に向上します。
- Release notes
- Lassoバージョン4.19.0
- Lassoバージョン4.18.0
- Lassoバージョン4.17.0
- Lassoバージョン4.16.0
- Lassoバージョン4.15.0
- Lassoバージョン4.14.0
- Lassoバージョン4.13.0
- Lassoバージョン4.12.0
- Lassoバージョン4.10.0
- Lassoバージョン4.9.0
- Lassoバージョン4.8.0
- Lassoバージョン4.7.0
- Lassoバージョン4.6.0
- Lassoバージョン4.5.0
- Lassoバージョン4.4.0
- Lassoバージョン4.3.0
- Lassoバージョン4.2.0
- Lassoバージョン4.1.1
- Lassoバージョン4.1.0
- Lassoバージョン4.0.0
- Installing Lasso
- Usage
- Configuration
- Security considerations
- Report types
- Returning the Lasso report
- What do we gather in our Lasso report?
- Detailed breakdown of gathered data
- GNU/Linux operating system
- barman crontab/cron ( barman_crontab_cron
) - debug_sources ( debug_sources
) - EFM CLI ( efm_cli
) - EFM configuration ( efm_configuration
) - EFM systemctl ( efm_systemctl
) - etcd CLI ( etcd_cli
) - etcd configuration ( etcd_configuration
) - etcd systemctl ( etcd_systemctl
) - HARP CLI ( harp_cli
) - HARP configuration ( harp_configuration
) - HARP systemctl ( harp_systemctl
) - Block devices layout ( linux_block_devices_layout
) - Processor governor ( linux_cpu_governor
) - Mounted file systems and available space ( linux_devices_info
) - File systems configuration ( linux_disk_configuration
) - OS distribution, kernel, and device data ( linux_distro_collector
) - Hardware ( linux_hardware_info
) - /etc/hosts configuration ( linux_hosts_configuration
) - HTTP(s) proxies in use for package downloads ( linux_http_proxy_configuration
) - Hypervisor ( linux_hypervisor_collector
) - Kernel ( linux_kernel_info
) - Kernel limits ( linux_kernel_limits
) - ld.so configuration ( linux_ldso
) - Configured locale ( linux_local
) - Processor usage statistics ( linux_mpstat
) - Network interfaces ( linux_network_interfaces
) - Installed packages via rpm or dpkg ( linux_packages_info
) - Installed packages origins ( linux_packages_origin_info
) - PostgreSQL disk layout ( linux_postgresql_disk_layout
) - SELinux ( linux_sestatus
) - OpenSSL version and configuration ( linux_ssl
) - System identification ( linux_system_identity
) - dmesg and /proc information ( linux_system_info
) - System status
- System status
- System status
- System status
- System status
- System status
- System status
- systemctl units ( linux_systemctl_units
) - tuned ( linux_tuned
) - PEM configuration ( pem_configuration
) - PEM systemctl ( pem_systemctl
) - PgBouncer configuration ( pgbouncer_configuration
) - PgBouncer systemctl ( pgbouncer_systemctl
) - PGD Proxy configuration ( pgd_proxy_configuration
) - PGD Proxy systemctl ( pgd_proxy_systemctl
) - postgres/enterprisedb crontab ( postgres_enterprisedb_crontab
) - PostgreSQL systemctl ( postgresql_systemctl
) - repmgr CLI ( repmgr_cli
) - repmgr configuration ( repmgr_configuration
) - repmgr systemctl ( repmgr_systemctl
) - xDB CLI ( xdb_cli
) - xDB configuration ( xdb_configuration
) - xDB systemctl ( xdb_systemctl
)
- barman crontab/cron ( barman_crontab_cron
- Microsoft Windows operating system
- PostgreSQL/BDR3 instance
- effective_logging_dest ( postgresql_actual_logdes
) - Current archiver stats ( postgresql_archiver
) - Available extensions ( postgresql_available_extensions
) - Current bg_writer stats ( postgresql_bgwriter
) - Directory with binaries ( postgresql_bin_dir
) - Current configuration ( postgresql_configuration
) - Configuration files ( postgresql_configuration_files
) - Current rate of new connections established to the DB ( postgresql_conns_per_second
) - Databases ( postgresql_databases
) - postgresql_db_bdr_tables_and_views ( postgresql_db_bdr_tables_and_views
) - postgresql_db_pglogical_tables_and_views ( postgresql_db_pglogical_tables_and_views
) - Database/role setting ( postgresql_db_role_setting
) - EDB Postgres Advanced Server resource group active use information ( postgresql_epas_edb_all_resource_groups
) - EDB Postgres Advanced Server user profile policies ( postgresql_epas_edb_profile
) - EDB Postgres Advanced Server resource group information ( postgresql_epas_edb_resource_group
) - Current pg_hba_file_rules contents ( postgresql_hba_file_rules
) - postgresql_logdirfiles ( postgresql_logdirfiles
) - Node and snapshot data ( postgresql_node
) - pg_config ( postgresql_pg_config
) - pg_controldata ( postgresql_pg_controldata
) - Version ( postgresql_pg_version
) - Current pg_prepared_xacts contents ( postgresql_prepared_xacts
) - Current pg_replication_origin_status contents ( postgresql_replication_origin
) - Current pg_replication_slots contents ( postgresql_replication_slots
) - Roles ( postgresql_roles
) - Current activity stats ( postgresql_running_activity
) - Age of current oldest running backend/transaction/query in the cluster ( postgresql_running_activity_oldestage
) - Active locks ( postgresql_running_locks
) - pg_server_limits ( postgresql_server_limits
) - Current pg_shmem_allocations contents ( postgresql_shmem_allocations
) - Current pg_stat_progress_analyze contents ( postgresql_stat_progress_analyze
) - Current pg_stat_progress_basebackup contents ( postgresql_stat_progress_basebackup
) - Current pg_stat_progress_copy contents ( postgresql_stat_progress_copy
) - Current pg_stat_progress_vacuum contents ( postgresql_stat_progress_vacuum
) - Current pg_stat_replication contents ( postgresql_stat_replication
) - Simple LRU (least recently used) cache statistics ( postgresql_stat_slru
) - Server subscription statistics ( postgresql_subscription_statistics
) - Server subscriptions ( postgresql_subscriptions
) - Tablespaces ( postgresql_tablespaces
) - Workload characteristics using waits ( postgresql_waits_stats
)
- effective_logging_dest ( postgresql_actual_logdes
- Details for every PostgreSQL/BDR3 database
- BDR1 replication slots ( postgresql_db_bdr1_replication_slots
) - BDR2 replication slots ( postgresql_db_bdr2_replication_slots
) - BDR conflict_history_summary aggregation ( postgresql_db_bdr3_conflict_history_summary_agg
) - BDR current activity stats ( postgresql_db_bdr3_stat_activity
) - BDR sequences ( postgresql_db_bdr_sequences
) - BDR version ( postgresql_db_bdr_version
) - BDR get_decoding_worker_stat ( postgresql_db_decoding_worker_stats
) - edb_wait_states database settings ( postgresql_db_edb_wait_states_database_settings
) - edb_wait_states load profile ( postgresql_db_edb_wait_states_load_profile
) - edb_wait_states operating system information ( postgresql_db_edb_wait_states_operating_system_information
) - edb_wait_states server information
- edb_wait_states server information
- edb_wait_states shared buffers statistics ( postgresql_db_edb_wait_states_shared_buffers_stats
) - edb_wait_states temp file statistics ( postgresql_db_edb_wait_states_temp_file_stats
) - edb_wait_states top 10 SQL statements by cputime ( postgresql_db_edb_wait_states_top_sql_statements_cputime
) - edb_wait_states top 10 SQL statements by dbtime ( postgresql_db_edb_wait_states_top_sql_statements_dbtime
) - edb_wait_states top 10 SQL statements by waittime ( postgresql_db_edb_wait_states_top_sql_statements_waittime
) - edb_wait_states top 10 wait events ( postgresql_db_edb_wait_states_top_wait_events
) - edb_wait_states transactions statistics ( postgresql_db_edb_wait_states_transaction_stats
) - edb_wait_states tuple statistics ( postgresql_db_edb_wait_states_tuple_stats
) - edb_wait_states user sessions ( postgresql_db_edb_wait_states_user_sessions
) - edb_wait_states WAL statistics ( postgresql_db_edb_wait_states_wal_stats
) - Database extensions ( postgresql_db_extensions
) - Database indexes ( postgresql_db_indexes
) - Database procedural languages ( postgresql_db_langages
) - BDR monitor_group_raft ( postgresql_db_monitor_group_raft
) - BDR monitor_group_versions ( postgresql_db_monitor_group_versions
) - BDR monitor_local_replslots ( postgresql_db_monitor_local_replslots
) - Database operators ( postgresql_db_operators
) - Database partitioned tables ( postgresql_db_partitioned_tables
) - Database child partition tables ( postgresql_db_partitions
) - Database PEM pem.agent table tuples ( postgresql_db_pem_agent
) - Database PEM pem.agent_config table tuples ( postgresql_db_pem_agent_config
) - Database PEM pem.agent_heartbeat table tuples ( postgresql_db_pem_agent_heartbeat
) - Database PEM pem.agent_server_binding table tuples ( postgresql_db_pem_agent_server_binding
) - Database PEM pem.config table tuples ( postgresql_db_pem_config
) - Database PEM pem.email_group table tuples ( postgresql_db_pem_email_group
) - Database PEM pem.email_group_option table tuples ( postgresql_db_pem_email_group_option
) - Database PEM pem.probe table tuples ( postgresql_db_pem_probe
) - Database PEM pem.probe_schedule table tuples ( postgresql_db_pem_probe_schedule
) - Database PEM pem.schema_version() output ( postgresql_db_pem_schema_version
) - Database PEM pem.server table tuples ( postgresql_db_pem_server
) - Database PEM pem.server_heartbeat table tuples ( postgresql_db_pem_server_heartbeat
) - Database PEM pem.smtp_spool table tuples ( postgresql_db_pem_smtp_spool
) - Database PEM pem.snmp_spool table tuples ( postgresql_db_pem_snmp_spool
) - Pglogical subscription status ( postgresql_db_pglogical_subscription_status
) - Database functions ( postgresql_db_pkgs
) - Database functions ( postgresql_db_procs
) - Database publication tables ( postgresql_db_publication_tables
) - Database publications ( postgresql_db_publications
) - Database repmgr repmgr.events table tuples ( postgresql_db_repmgr_events
) - Database repmgr repmgr.monitoring_history table tuples ( postgresql_db_repmgr_monitoring_history
) - Database repmgr repmgr.nodes table tuples ( postgresql_db_repmgr_nodes
) - Database repmgr repmgr.replication_status table tuples ( postgresql_db_repmgr_replication_status
) - Database repmgr repmgr.show_nodes table tuples ( postgresql_db_repmgr_show_nodes
) - Database schema ( postgresql_db_schemas
) - Database statistics ( postgresql_db_statistics
) - Database subscription tables ( postgresql_db_subscription_tables
) - Database tables ( postgresql_db_tables
) - Tables close to wraparound ( postgresql_db_tables_wraparound
) - Database triggers ( postgresql_db_triggers
) - Database types ( postgresql_db_types
) - BDR wal_sender_stats ( postgresql_db_wal_sender_stats
) - Database xDB _edb_replicator_pub.xdb_mmr_pub_group table tuples ( postgresql_db_xdb_mmr_pub_group
) - Database xDB _edb_replicator_pub.xdb_pub_database table tuples ( postgresql_db_xdb_pub_database
) - Database xDB _edb_replicator_pub.xdb_pub_replog table tuples ( postgresql_db_xdb_pub_replog
) - Database xDB _edb_replicator_pub.xdb_publication_subscriptionstable tuples ( postgresql_db_xdb_publication_subscriptions
) - Database xDB _edb_replicator_pub.xdb_publications table tuples ( postgresql_db_xdb_publications
) - Database xDB _edb_replicator_pub.rrep_mmr_pub_group table tuples ( postgresql_db_xdb_rrep_mmr_pub_group
) - Database xDB _edb_replicator_pub.rrep_mmr_txset table tuples ( postgresql_db_xdb_rrep_mmr_txset
) - Database xDB _edb_replicator_pub.rrep_properties table tuples ( postgresql_db_xdb_rrep_properties
) - Database xDB _edb_replicator_pub.rrep_publication_tablestable tuples ( postgresql_db_xdb_rrep_publication_tables
) - Database xDB _edb_replicator_pub.rrep_txset table tuples ( postgresql_db_xdb_rrep_txset
) - Oracle-compatibile partitioning key view ( postgresql_epas_all_part_key_columns
) - Oracle-compatibile all partitioned table view ( postgresql_epas_all_part_tables
) - Oracle-compatibile subpartitioning key view ( postgresql_epas_all_subpart_key_columns
) - Oracle-compatibile all table partitions view ( postgresql_epas_all_tab_partitions
) - Oracle-compatibile all table subpartitioning view ( postgresql_epas_all_tab_subpartitions
) - EDB Postgres Advanced Server-specific dblink information ( postgresql_epas_dblink
) - EDB Postgres Advanced Server directories ( postgresql_epas_edb_dir
) - EDB Postgres Advanced Server security policies ( postgresql_epas_edb_policy
) - EDB Postgres Advanced Server redaction policies per column ( postgresql_epas_edb_redaction_column
) - EDB Postgres Advanced Server redaction policies ( postgresql_epas_edb_redaction_policy
) - EDB Postgres Advanced Server extended pg_namespace view ( postgresql_epas_pg_namespace
) - EDB Postgres Advanced Server-specific queue information ( postgresql_epas_queue
) - EDB Postgres Advanced Server-specific queue callback information ( postgresql_epas_queue_callback
) - EDB Postgres Advanced Server-specific queue table information ( postgresql_epas_queue_table
)
- BDR1 replication slots ( postgresql_db_bdr1_replication_slots
- Barman (Backup and Recovery Manager)
- Barman check ( barman_check
) - Barman diagnose ( barman_diagnose
) - Barman executable location ( barman_executable
) - Barman module location ( barman_modules_path
) - Databases checksums ( postgresql_databases_checksums
) - Blocking locks ( postgresql_blocking_locks
) - Current checkpointer stats ( postgresql_checkpointer
) - BDR worker_errors ( postgresql_db_bdr_worker_errors
)
- Barman check ( barman_check
- GNU/Linux operating system
- Servers accepting upload of reports