Lasso#
EDB developed a small multi-platform application called Lasso. Lasso can safely gather relevant diagnostics data on a system where Postgres and other relevant supported software, such as Barman, is running.
You can also run Lasso on systems where Postgres isn’t installed to gather all relevant information about the underlying operating system.
Consult the specific information for your operating system.
Important
Lasso can't affect your data. It gathers statistics and diagnostics information from your Postgres server, with imperceptible effects on the workload. No actual data from the rows of your Postgres user tables is gathered. [^1]
Lasso is crucial for support operations because it allows EDB’s engineers to have a centralized and standardized source of information about your system. This ability greatly improves our resolution times and quality of services.
- Release notes
- Lasso - Version 4.13.0
- Lasso - Version 4.12.0
- Lasso - Version 4.11.0
- Lasso - Version 4.10.0
- Lasso - Version 4.9.0
- Lasso - Version 4.8.0
- Lasso - Version 4.7.0
- Lasso - Version 4.6.0
- Lasso - Version 4.5.0
- Lasso - Version 4.4.0
- Lasso - Version 4.3.0
- Lasso - Version 4.2.0
- Lasso - Version 4.1.1
- Lasso - Version 4.1.0
- Lasso - Version 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) - Hypervisor (
linux_hypervisor_collector) - Kernel (
linux_kernel_info) - Kernel limits (
linux_kernel_limits) - Processor usage statistics (
linux_mpstat) - Network interfaces (
linux_network_interfaces) - Installed packages via rpm or dpkg (
linux_packages_info) - PostgreSQL disk layout (
linux_postgresql_disk_layout) - SELinux (
linux_sestatus) - System identification (
linux_system_identity) - dmesg and /proc information (
linux_system_info) - System status — iostat (
linux_system_status_iostat) - System status — nfsiostat (
linux_system_status_nfsiostat) - System status — ps (
linux_system_status_ps) - System status — sar (
linux_system_status_sar) - System status — top (
linux_system_status_top) - System status — vmstat (
linux_system_status_vmstat) - 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) - 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 (
- Microsoft Windows operating system
- PEM configuration — Windows (
pem_configuration_windows) - PEM sc (
pem_sc) - Disk information (
win_disk_information) - Hosts file (
win_hosts) - MsInfo (
win_msinfo) - ODBC/64 (
win_odbc32_info) - ODBC/32 (
win_odbc64_info) - systeminfo (
win_systeminfo) - Disk volumes (
win_volumes) - xDB CLI — Windows (
xdb_cli_windows) - xDB configuration — Windows (
xdb_configuration_windows) - xDB sc (
xdb_sc)
- PEM configuration — Windows (
- PostgreSQL/BDR3 instance
- 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) - 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) - Server subscription statistics (
postgresql_subscription_statistics) - Server subscriptions (
postgresql_subscriptions) - Tablespaces (
postgresql_tablespaces) - Workload characteristics using waits (
postgresql_waits_stats)
- Current archiver stats (
- 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) - 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 — part 1 (
postgresql_db_edb_wait_states_server_information_1) - edb_wait_states server information — part 2 (
postgresql_db_edb_wait_states_server_information_2) - 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_languages) - 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 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_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) - Database types (
postgresql_db_types) - 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) - EPAS specific queue information (
postgresql_epas_queue) - EPAS specific queue callback information (
postgresql_epas_queue_callback) - EPAS specific queue table information (
postgresql_epas_queue_table)
- BDR1 replication slots (
- Barman (Backup and Recovery Manager)
- GNU/Linux operating system
- Servers accepting upload of reports