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.16.0
- Lasso - Version 4.15.0
- Lasso - Version 4.14.0
- 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) - 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_locale) - 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 -device mapper devices (
linux_system_status_dmdevices) - 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) - 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 (
- 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 sc (
- PostgreSQL/BDR3 instance ### effective_logging_dest (
postgresql_actual_logdest)- 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) - 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) - 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) - 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 -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_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) - 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)
- BDR2 replication slots (
- Barman (Backup and Recovery Manager) ### Barman check (
barman_check)
- GNU/Linux operating system
- Servers accepting upload of reports