Lasso#
EDB has developed a small multi-platform application called Lasso that 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 regarding 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]
inspection.
- Release notes
- Lasso - Version 4.11.0 (2023-12-14)
- New features
- Bug fix
- Lasso - Version 4.10.0 (2023-11-07)
- Lasso - Version 4.9.0 (2023-10-17)
- Lasso - Version 4.8.0 (2023-07-06)
- Lasso - Version 4.7.0 (2023-06-01)
- Lasso - Version 4.6.0 (2022-12-06)
- Lasso - Version 4.5.0 (2022-11-15)
- Lasso - Version 4.4.0 (2022-09-22)
- Lasso - Version 4.3.0 (2022-08-25)
- Lasso - Version 4.2.0 (2022-05-18)
- Lasso - Version 4.1.1 (2022-05-10)
- Lasso - Version 4.1.0 (2022-05-03)
- Lasso - Version 4.0.0 (2022-03-30)
- 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) - 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) - 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) - 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) - EPAS specific dblink information (
postgresql_epas_dblink)
- BDR1 replication slots (
- Barman (Backup and Recovery Manager)
- GNU/Linux Operating System
- Servers accepting upload of reports