Skip to content

Instantly share code, notes, and snippets.

@snehesht

snehesht/PG Metrics

Created February 14, 2020 22:01
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save snehesht/752909c1b1cca73b338c9affc0d6b180 to your computer and use it in GitHub Desktop.
Save snehesht/752909c1b1cca73b338c9affc0d6b180 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
PG Metrics
pgmetrics run at: 14 Feb 2020 4:58:16 PM (now)
PostgreSQL Cluster:
Name: PostgreSQL
Server Version: 11.0 (Ubuntu 11.0-1.pgdg16.04+2)
Server Started: 14 Feb 2020 4:41:59 PM (16 minutes ago)
System Identifier: 6615636975566673716
Timeline: 2
Last Checkpoint: 14 Feb 2020 4:55:12 PM (3 minutes ago)
REDO LSN: 17/F931B7E0
Checkpoint LSN: 17/F937E350 (395 KiB since REDO)
Transaction IDs: 561 to 47957702 (diff = 47957141)
Notification Queue: 0.0% used
Active Backends: 2 (max 100)
Recovery Mode? no
System Information:
Hostname: ubuntu
CPU Cores: 2 x AMD Ryzen Threadripper 2950X 16-Core Processor
Load Average: 0.00
Memory: used=202 MiB, free=6.0 GiB, buff=182 MiB, cache=1.4 GiB
Swap: used=0 B, free=976 MiB
+---------------------------------+-----------------+
| Setting | Value |
+---------------------------------+-----------------+
| shared_buffers | 65536 (512 MiB) |
| work_mem | 4096 (4.0 MiB) |
| maintenance_work_mem | 65536 (64 MiB) |
| temp_buffers | 1024 (8.0 MiB) |
| autovacuum_work_mem | -1 |
| temp_file_limit | -1 |
| max_worker_processes | 8 |
| autovacuum_max_workers | 3 |
| max_parallel_workers_per_gather | 2 |
| effective_io_concurrency | 1 |
+---------------------------------+-----------------+
Outgoing Replication Stats:
Destination #1:
User: replicator
Application: walreceiver
Client Address:
State:
Started At:
Sent LSN:
Written Until:
Flushed Until:
Replayed Until:
Sync Priority:
Sync State:
WAL Files:
WAL Archiving? yes
Ready Files:
Archive Rate: 0.02 per min
Last Archived: 14 Feb 2020 4:45:39 PM (12 minutes ago)
Last Failure:
Totals: 420 succeeded, 0 failed
Totals Since: 29 Jan 2020 10:45:58 AM (2 weeks ago)
+--------------------+---------------+
| Setting | Value |
+--------------------+---------------+
| wal_level | replica |
| archive_timeout | 0 |
| wal_compression | off |
| max_wal_size | 1024 (16 GiB) |
| min_wal_size | 80 (1.3 GiB) |
| checkpoint_timeout | 300 |
| full_page_writes | on |
| wal_keep_segments | 0 |
+--------------------+---------------+
BG Writer:
Checkpoint Rate: 0.20 per min
Average Write: 2.3 MiB per checkpoint
Total Checkpoints: 4679 sched (100.0%) + 1 req (0.0%) = 4680
Total Write: 11 GiB, @ 8.0 KiB per sec
Buffers Allocated: 22759 (178 MiB)
Buffers Written: 1401921 chkpt (99.8%) + 0 bgw (0.0%) + 2747 be (0.2%)
Clean Scan Stops: 0
BE fsyncs: 0
Counts Since: 29 Jan 2020 10:45:57 AM (2 weeks ago)
+------------------------------+--------------+
| Setting | Value |
+------------------------------+--------------+
| bgwriter_delay | 200 msec |
| bgwriter_flush_after | 64 (512 KiB) |
| bgwriter_lru_maxpages | 100 |
| bgwriter_lru_multiplier | 2 |
| block_size | 8192 |
| checkpoint_timeout | 300 sec |
| checkpoint_completion_target | 0.5 |
+------------------------------+--------------+
Backends:
Total Backends: 2 (2.0% of max 100)
Problematic: 0 waiting on locks, 1 waiting on other, 0 xact too long, 0 idle in xact
Other Waiting Backends:
+------+------+-----+---------------+----------+---------------------+------------------------+
| PID | User | App | Client Addr | Database | Wait | Query Start |
+------+------+-----+---------------+----------+---------------------+------------------------+
| 5685 | band | | 10.0.0.138/32 | band | Client / ClientRead | 14 Feb 2020 4:58:12 PM |
+------+------+-----+---------------+----------+---------------------+------------------------+
Locks:
+------------+-------------+-------+
| Lock Type | Not Granted | Total |
+------------+-------------+-------+
| relation | 0 | 4 |
| virtualxid | 0 | 1 |
+------------+-------------+-------+
| | 0 | 5 |
+------------+-------------+-------+
Vacuum Progress:
No manual or auto vacuum jobs in progress.
+------------------------------+----------------+
| Setting | Value |
+------------------------------+----------------+
| maintenance_work_mem | 65536 (64 MiB) |
| autovacuum | on |
| autovacuum_analyze_threshold | 50 |
| autovacuum_vacuum_threshold | 50 |
| autovacuum_freeze_max_age | 200000000 |
| autovacuum_max_workers | 3 |
| autovacuum_naptime | 60 sec |
| vacuum_freeze_min_age | 50000000 |
| vacuum_freeze_table_age | 150000000 |
+------------------------------+----------------+
Roles:
+---------------------------+-------+------+-------+-----------+----------+------------+---------+---------+--------------------------------------------------------------+
| Name | Login | Repl | Super | Creat Rol | Creat DB | Bypass RLS | Inherit | Expires | Member Of |
+---------------------------+-------+------+-------+-----------+----------+------------+---------+---------+--------------------------------------------------------------+
| postgres | yes | yes | yes | yes | yes | yes | yes | | |
| pg_monitor | | | | | | | yes | | pg_read_all_settings, pg_read_all_stats, pg_stat_scan_tables |
| pg_read_all_settings | | | | | | | yes | | |
| pg_read_all_stats | | | | | | | yes | | |
| pg_stat_scan_tables | | | | | | | yes | | |
| pg_signal_backend | | | | | | | yes | | |
| pg_read_server_files | | | | | | | yes | | |
| pg_write_server_files | | | | | | | yes | | |
| pg_execute_server_program | | | | | | | yes | | |
| replicator | yes | yes | | | | | yes | | |
| exampleuser | yes | | | | | | yes | | |
| band | yes | | | | | | yes | | |
| bandjpmc | yes | | | | | | yes | | |
| begin | yes | | | | | | yes | | |
| band2 | yes | | | | | | yes | | |
| braid | yes | | | | | | yes | | |
| bunch | yes | | | | | | yes | | |
+---------------------------+-------+------+-------+-----------+----------+------------+---------+---------+--------------------------------------------------------------+
Tablespaces:
+------------+----------+----------+---------+-----------+------------+
| Name | Owner | Location | Size | Disk Used | Inode Used |
+------------+----------+----------+---------+-----------+------------+
| pg_default | postgres | | 964 MiB | | |
| pg_global | postgres | | | | |
+------------+----------+----------+---------+-----------+------------+
Database #1:
Name: postgres
Owner: postgres
Tablespace: pg_default
Connections: 0 (no max limit)
Frozen Xid Age: 47957516
Transactions: 215 (98.2%) commits, 4 (1.8%) rollbacks
Cache Hits: 96.8%
Rows Changed: ins 0.0%, upd 100.0%, del 0.0%
Total Temp: 0 B in 0 files
Problems: 0 deadlocks, 0 conflicts
Totals Since: 14 Feb 2020 4:17:16 PM (41 minutes ago)
Size: 7.6 MiB
Database #2:
Name: example
Owner: postgres
Tablespace: pg_default
Connections: 0 (no max limit)
Frozen Xid Age: 47957516
Transactions: 0 (0.0%) commits, 0 (0.0%) rollbacks
Cache Hits: 0.0%
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
Total Temp: 0 B in 0 files
Problems: 0 deadlocks, 0 conflicts
Totals Since:
Size: 10 MiB
Database #3:
Name: band
Owner: postgres
Tablespace: pg_default
Connections: 2 (no max limit)
Frozen Xid Age: 47957516
Transactions: 4033388 (100.0%) commits, 54 (0.0%) rollbacks
Cache Hits: 99.9%
Rows Changed: ins 44.8%, upd 23.2%, del 32.0%
Total Temp: 144 MiB in 49 files
Problems: 0 deadlocks, 0 conflicts
Totals Since: 29 Jan 2020 10:46:13 AM (2 weeks ago)
Size: 330 MiB
Sequences:
+--------------------+------------+
| Sequence | Cache Hits |
+--------------------+------------+
| bridge_jwks_id_seq | 0.0% |
+--------------------+------------+
Installed Extensions:
+---------+---------+-------------------------------------------------------------------+
| Name | Version | Comment |
+---------+---------+-------------------------------------------------------------------+
| pg_trgm | 1.4 | text similarity measurement and index searching based on trigrams |
| plpgsql | 1.0 | PL/pgSQL procedural language |
+---------+---------+-------------------------------------------------------------------+
Database #4:
Name: bandjpmc
Owner: postgres
Tablespace: pg_default
Connections: 0 (no max limit)
Frozen Xid Age: 47957516
Transactions: 0 (0.0%) commits, 0 (0.0%) rollbacks
Cache Hits: 0.0%
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
Total Temp: 0 B in 0 files
Problems: 0 deadlocks, 0 conflicts
Totals Since:
Size: 10 MiB
Database #5:
Name: begin
Owner: postgres
Tablespace: pg_default
Connections: 0 (no max limit)
Frozen Xid Age: 47957516
Transactions: 26366 (100.0%) commits, 1 (0.0%) rollbacks
Cache Hits: 100.0%
Rows Changed: ins 0.0%, upd 100.0%, del 0.0%
Total Temp: 0 B in 0 files
Problems: 0 deadlocks, 0 conflicts
Totals Since: 6 Feb 2020 2:26:57 PM (1 week ago)
Size: 543 MiB
Database #6:
Name: band2
Owner: postgres
Tablespace: pg_default
Connections: 0 (no max limit)
Frozen Xid Age: 47957516
Transactions: 0 (0.0%) commits, 0 (0.0%) rollbacks
Cache Hits: 0.0%
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
Total Temp: 0 B in 0 files
Problems: 0 deadlocks, 0 conflicts
Totals Since:
Size: 12 MiB
Database #7:
Name: band3
Owner: postgres
Tablespace: pg_default
Connections: 0 (no max limit)
Frozen Xid Age: 47957516
Transactions: 0 (0.0%) commits, 0 (0.0%) rollbacks
Cache Hits: 0.0%
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
Total Temp: 0 B in 0 files
Problems: 0 deadlocks, 0 conflicts
Totals Since:
Size: 12 MiB
Database #8:
Name: braid
Owner: postgres
Tablespace: pg_default
Connections: 0 (no max limit)
Frozen Xid Age: 47957516
Transactions: 0 (0.0%) commits, 0 (0.0%) rollbacks
Cache Hits: 0.0%
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
Total Temp: 0 B in 0 files
Problems: 0 deadlocks, 0 conflicts
Totals Since:
Size: 11 MiB
Database #9:
Name: bunch
Owner: postgres
Tablespace: pg_default
Connections: 0 (no max limit)
Frozen Xid Age: 47957516
Transactions: 1327483 (100.0%) commits, 182 (0.0%) rollbacks
Cache Hits: 100.0%
Rows Changed: ins 44.3%, upd 24.4%, del 31.3%
Total Temp: 33 MiB in 12 files
Problems: 0 deadlocks, 0 conflicts
Totals Since: 29 Jan 2020 10:47:28 AM (2 weeks ago)
Size: 14 MiB
Table #1 in "band":
Name: band.public.deepstreams
Columns: 4
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 0, 0.0 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 0.0% (idx=0.0%)
Size: 432 KiB
+------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| deepstreams_pkey | btree | 232 KiB | | | 0 | 0.0 | 0.0 |
+------------------+-------+---------+-------+------------+-------+----------------+-------------------+
Table #2 in "band":
Name: band.public.admin_users
Columns: 5
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 3, 1.0 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 66.7% (idx=0.0%)
Size: 16 KiB
+------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| admin_users_pkey | btree | 16 KiB | | 0.0% | 0 | 0.0 | 0.0 |
+------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #3 in "band":
Name: band.public.nodes
Columns: 4
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: 2, last 9 hours ago
Auto Analyze: 3, last 1 day ago
Post-Analyze: 6.0% est. rows modified
Row Estimate: 98.6% live of total 15814
Rows Changed: ins 39.3%, upd 43.2%, del 7.8%
HOT Updates: 81.7% of all updates
Seq Scans: 37, 10564.8 rows/scan
Idx Scans: 7551863, 2.4 rows/scan
Cache Hits: 95.6% (idx=100.0%)
Size: 187 MiB
Bloat: 182 MiB (97.7%)
+------------------------+-------+---------+-----------------+------------+---------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+------------------------+-------+---------+-----------------+------------+---------+----------------+-------------------+
| node_name_trgm_gin | gin | 1.8 MiB | 0 B (0.0%) | 94.6% | 0 | 0.0 | 0.0 |
| ftsvector_idx | gin | 5.8 MiB | 3.2 MiB (55.5%) | 72.9% | 0 | 0.0 | 0.0 |
| nodes_type | btree | 16 MiB | 14 MiB (84.1%) | 99.6% | 83091 | 138.6 | 37.4 |
| nodes_pkey | btree | 1.0 MiB | 0 B (0.0%) | 100.0% | 7468772 | 1.0 | 1.0 |
| node_nickname_trgm_gin | gin | 184 KiB | 0 B (0.0%) | 99.2% | 0 | 0.0 | 0.0 |
+------------------------+-------+---------+-----------------+------------+---------+----------------+-------------------+
Table #4 in "band":
Name: band.public.edges
Columns: 6
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: 5, last 1 day ago
Auto Analyze: 16, last 15 hours ago
Post-Analyze: 5.3% est. rows modified
Row Estimate: 86.4% live of total 11012
Rows Changed: ins 10.9%, upd 33.7%, del 7.0%
HOT Updates: 41.1% of all updates
Seq Scans: 5448, 7124.5 rows/scan
Idx Scans: 16998260, 9.1 rows/scan
Cache Hits: 100.0% (idx=100.0%)
Size: 1.3 MiB
Bloat: 384 KiB (28.2%)
+-------------------+-------+---------+-----------------+------------+----------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+-------------------+-------+---------+-----------------+------------+----------+----------------+-------------------+
| edges_parent | btree | 2.0 MiB | 1.3 MiB (65.1%) | 100.0% | 1091926 | 115.5 | 0.3 |
| edge_metadata_idx | gin | 3.8 MiB | 3.1 MiB (81.3%) | 98.4% | 366 | 667.2 | 0.0 |
| edges_child_type | btree | 2.2 MiB | 1.5 MiB (68.1%) | 98.9% | 18825 | 3.9 | 0.5 |
| edges_parent_type | btree | 1.8 MiB | 1.1 MiB (61.9%) | 98.8% | 1937 | 2.0 | 0.1 |
| edges_pkey | btree | 984 KiB | 264 KiB (26.8%) | 100.0% | 751781 | 95.4 | 9.3 |
| edges_child | btree | 1.2 MiB | 472 KiB (39.6%) | 100.0% | 15133425 | 1.2 | 0.0 |
+-------------------+-------+---------+-----------------+------------+----------+----------------+-------------------+
Table #5 in "band":
Name: band.public.permissions
Columns: 3
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: 1, last 3 days ago
Auto Analyze: 3, last 1 day ago
Post-Analyze: 2.0% est. rows modified
Row Estimate: 89.1% live of total 125566
Rows Changed: ins 52.6%, upd 39.7%, del 7.5%
HOT Updates: 99.7% of all updates
Seq Scans: 0, 0.0 rows/scan
Idx Scans: 7135617, 23.2 rows/scan
Cache Hits: 100.0% (idx=100.0%)
Size: 11 MiB
Bloat: 2.6 MiB (24.0%)
+--------------------+-------+---------+-----------------+------------+---------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+--------------------+-------+---------+-----------------+------------+---------+----------------+-------------------+
| permissions_type | btree | 9.8 MiB | 3.6 MiB (36.3%) | 99.4% | 35269 | 71.5 | 0.0 |
| permissions_pkey | btree | 12 MiB | 5.3 MiB (45.9%) | 100.0% | 1334274 | 41.6 | 23.3 |
| permissions_source | btree | 7.5 MiB | 1.2 MiB (16.4%) | 99.4% | 2160 | 4625.8 | 0.2 |
| permissions_target | btree | 5.5 MiB | 0 B (0.0%) | 100.0% | 5763914 | 17.8 | 16.4 |
+--------------------+-------+---------+-----------------+------------+---------+----------------+-------------------+
Table #6 in "band":
Name: band.public.access_tokens
Columns: 6
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: 1, last 1 day ago
Auto Analyze: 2, last 12 hours ago
Post-Analyze: 1.6% est. rows modified
Row Estimate: 93.5% live of total 10458
Rows Changed: ins 56.2%, upd 28.9%, del 14.6%
HOT Updates: 99.0% of all updates
Seq Scans: 1531, 9659.0 rows/scan
Idx Scans: 9672, 1.4 rows/scan
Cache Hits: 99.9% (idx=99.6%)
Size: 8.7 MiB
Bloat: 3.1 MiB (35.2%)
+--------------------+-------+---------+------------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+--------------------+-------+---------+------------+------------+-------+----------------+-------------------+
| access_tokens_pkey | btree | 1.2 MiB | 0 B (0.0%) | 99.6% | 9672 | 2.1 | 1.4 |
+--------------------+-------+---------+------------+------------+-------+----------------+-------------------+
Table #7 in "band":
Name: band.public.notifications
Columns: 7
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 0, 0.0 rows/scan
Idx Scans: 1018, 0.0 rows/scan
Cache Hits: 0.0% (idx=100.0%)
Size: 8.0 KiB
+---------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+---------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| notifications_user_team | btree | 8.0 KiB | | 100.0% | 1018 | 0.0 | 0.0 |
| notification_metadata_idx | gin | 16 KiB | | | 0 | 0.0 | 0.0 |
| notifications_pkey | btree | 8.0 KiB | | 99.9% | 0 | 0.0 | 0.0 |
+---------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
Table #8 in "band":
Name: band.public.devices
Columns: 5
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 509, 0.0 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 0.0% (idx=99.8%)
Size: 8.0 KiB
+--------------+-------+---------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+--------------+-------+---------+-------+------------+-------+----------------+-------------------+
| devices_pkey | btree | 8.0 KiB | | 99.8% | 0 | 0.0 | 0.0 |
+--------------+-------+---------+-------+------------+-------+----------------+-------------------+
Table #9 in "band":
Name: band.public.links
Columns: 4
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 118.2% est. rows modified
Row Estimate: 36.4% live of total 11
Rows Changed: ins 60.0%, upd 13.3%, del 26.7%
HOT Updates: 100.0% of all updates
Seq Scans: 1443, 2886.6 rows/scan
Idx Scans: 4791, 1.0 rows/scan
Cache Hits: 99.9% (idx=99.9%)
Size: 728 KiB
Bloat: 304 KiB (41.8%)
+------------+-------+---------+----------------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+------------+-------+---------+----------------+------------+-------+----------------+-------------------+
| links_pkey | btree | 344 KiB | 40 KiB (11.6%) | 99.9% | 4791 | 1.0 | 1.0 |
+------------+-------+---------+----------------+------------+-------+----------------+-------------------+
Table #10 in "band":
Name: band.public.schedules
Columns: 16
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: 3, last 2 weeks ago
Post-Analyze: 2.0% est. rows modified
Row Estimate: 80.9% live of total 1024
Rows Changed: ins 42.3%, upd 35.0%, del 22.5%
HOT Updates: 99.3% of all updates
Seq Scans: 100659, 823.1 rows/scan
Idx Scans: 502, 1.0 rows/scan
Cache Hits: 100.0% (idx=100.0%)
Size: 120 KiB
+----------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+----------------+-------+--------+-------+------------+-------+----------------+-------------------+
| schedules_pkey | btree | 56 KiB | | 100.0% | 502 | 1.0 | 1.0 |
+----------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #11 in "band":
Name: band.public.auth_clients
Columns: 23
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 2445, 1.2 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 99.7% (idx=100.0%)
Size: 112 KiB
+-------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+-------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| auth_clients_pkey | btree | 16 KiB | | 100.0% | 0 | 0.0 | 0.0 |
+-------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #12 in "band":
Name: band.public.ipfs_files
Columns: 5
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 0, 0.0 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 0.0% (idx=0.0%)
Size: 8.0 KiB
+-----------------+-------+---------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+-----------------+-------+---------+-------+------------+-------+----------------+-------------------+
| ipfs_files_pkey | btree | 8.0 KiB | | | 0 | 0.0 | 0.0 |
+-----------------+-------+---------+-------+------------+-------+----------------+-------------------+
Table #13 in "band":
Name: band.public.service_accounts
Columns: 5
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 2, 0.0 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 0.0% (idx=50.0%)
Size: 8.0 KiB
+-----------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+-----------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| service_accounts_pkey | btree | 8.0 KiB | | 50.0% | 0 | 0.0 | 0.0 |
+-----------------------+-------+---------+-------+------------+-------+----------------+-------------------+
Table #14 in "band":
Name: band.public.stripe_customers
Columns: 4
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 0, 0.0 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 0.0% (idx=0.0%)
Size: 0 B
+-----------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+-----------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| stripe_customers_pkey | btree | 8.0 KiB | | | 0 | 0.0 | 0.0 |
+-----------------------+-------+---------+-------+------------+-------+----------------+-------------------+
Table #15 in "band":
Name: band.public.settings
Columns: 39
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 50.0% est. rows modified
Row Estimate: 0.0% live of total 48
Rows Changed: ins 50.0%, upd 50.0%, del 0.0%
HOT Updates: 100.0% of all updates
Seq Scans: 93975, 1.0 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 100.0% (idx=100.0%)
Size: 48 KiB
+---------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+---------------+-------+--------+-------+------------+-------+----------------+-------------------+
| settings_pkey | btree | 16 KiB | | 100.0% | 0 | 0.0 | 0.0 |
+---------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #16 in "band":
Name: band.public.bridge_access_tokens
Columns: 7
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 107.5% est. rows modified
Row Estimate: 92.5% live of total 863
Rows Changed: ins 93.0%, upd 0.0%, del 7.0%
HOT Updates: 0.0% of all updates
Seq Scans: 13, 19881.4 rows/scan
Idx Scans: 3568, 1.0 rows/scan
Cache Hits: 94.2% (idx=98.4%)
Size: 9.8 MiB
Bloat: 304 KiB (3.0%)
+---------------------------+-------+---------+------------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+---------------------------+-------+---------+------------+------------+-------+----------------+-------------------+
| bridge_access_tokens_pkey | btree | 1.9 MiB | 0 B (0.0%) | 98.4% | 3568 | 1.0 | 1.0 |
+---------------------------+-------+---------+------------+------------+-------+----------------+-------------------+
Table #17 in "band":
Name: band.public.bridge_authorization_codes
Columns: 7
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 155.0% est. rows modified
Row Estimate: 46.7% live of total 60
Rows Changed: ins 43.0%, upd 40.9%, del 14.0%
HOT Updates: 95.0% of all updates
Seq Scans: 13, 1274.8 rows/scan
Idx Scans: 80, 1.0 rows/scan
Cache Hits: 93.2% (idx=96.5%)
Size: 1.2 MiB
Bloat: 416 KiB (33.5%)
+---------------------------------+-------+--------+------------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+---------------------------------+-------+--------+------------+------------+-------+----------------+-------------------+
| bridge_authorization_codes_pkey | btree | 88 KiB | 0 B (0.0%) | 96.5% | 80 | 1.0 | 1.0 |
+---------------------------------+-------+--------+------------+------------+-------+----------------+-------------------+
Table #18 in "band":
Name: band.public.bridge_client_credentials
Columns: 7
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 0, 0.0 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 0.0% (idx=0.0%)
Size: 8.0 KiB
+--------------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+--------------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| bridge_client_credentials_pkey | btree | 8.0 KiB | | | 0 | 0.0 | 0.0 |
+--------------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
Table #19 in "band":
Name: band.public.bridge_clients
Columns: 9
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 142, 210.0 rows/scan
Idx Scans: 74590, 1.0 rows/scan
Cache Hits: 100.0% (idx=100.0%)
Size: 320 KiB
Bloat: 96 KiB (30.0%)
+---------------------+-------+--------+------------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+---------------------+-------+--------+------------+------------+-------+----------------+-------------------+
| bridge_clients_pkey | btree | 40 KiB | 0 B (0.0%) | 100.0% | 74590 | 1.0 | 1.0 |
+---------------------+-------+--------+------------+------------+-------+----------------+-------------------+
Table #20 in "band":
Name: band.public.bridge_initial_access_tokens
Columns: 7
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 0, 0.0 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 0.0% (idx=0.0%)
Size: 8.0 KiB
+-----------------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+-----------------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| bridge_initial_access_tokens_pkey | btree | 8.0 KiB | | | 0 | 0.0 | 0.0 |
+-----------------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
Table #21 in "band":
Name: band.public.bridge_refresh_tokens
Columns: 7
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 200.0% est. rows modified
Row Estimate: 54.0% live of total 126
Rows Changed: ins 47.6%, upd 31.3%, del 20.6%
HOT Updates: 98.8% of all updates
Seq Scans: 13, 3041.1 rows/scan
Idx Scans: 203, 0.9 rows/scan
Cache Hits: 93.3% (idx=96.8%)
Size: 2.2 MiB
Bloat: 264 KiB (11.7%)
+----------------------------+-------+---------+------------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+----------------------------+-------+---------+------------+------------+-------+----------------+-------------------+
| bridge_refresh_tokens_pkey | btree | 216 KiB | 0 B (0.0%) | 96.8% | 203 | 1.0 | 0.9 |
+----------------------------+-------+---------+------------+------------+-------+----------------+-------------------+
Table #22 in "band":
Name: band.public.bridge_registration_access_tokens
Columns: 7
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 0, 0.0 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 0.0% (idx=0.0%)
Size: 96 KiB
+----------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+----------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| bridge_registration_access_tokens_pkey | btree | 40 KiB | | | 0 | 0.0 | 0.0 |
+----------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #23 in "band":
Name: band.public.bridge_sessions
Columns: 7
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: 1, last 2 days ago
Auto Analyze: 1, last 2 days ago
Post-Analyze: 13.4% est. rows modified
Row Estimate: 88.2% live of total 702
Rows Changed: ins 54.5%, upd 17.0%, del 22.7%
HOT Updates: 75.0% of all updates
Seq Scans: 0, 0.0 rows/scan
Idx Scans: 289, 1.0 rows/scan
Cache Hits: 91.4% (idx=99.1%)
Size: 648 KiB
Bloat: 144 KiB (22.2%)
+----------------------+-------+--------+------------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+----------------------+-------+--------+------------+------------+-------+----------------+-------------------+
| bridge_sessions_pkey | btree | 72 KiB | 0 B (0.0%) | 99.1% | 289 | 1.1 | 1.0 |
+----------------------+-------+--------+------------+------------+-------+----------------+-------------------+
Table #24 in "band":
Name: band.public.bridge_account_stores
Columns: 4
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: 3, last 3 hours ago
Auto Analyze: 4, last 1 day ago
Post-Analyze: 9.2% est. rows modified
Row Estimate: 98.4% live of total 1125
Rows Changed: ins 50.9%, upd 48.4%, del 0.0%
HOT Updates: 98.6% of all updates
Seq Scans: 0, 0.0 rows/scan
Idx Scans: 1606, 1.0 rows/scan
Cache Hits: 98.8% (idx=99.7%)
Size: 808 KiB
Bloat: 152 KiB (18.8%)
+----------------------------+-------+---------+------------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+----------------------------+-------+---------+------------+------------+-------+----------------+-------------------+
| bridge_account_stores_pkey | btree | 112 KiB | 0 B (0.0%) | 99.7% | 1606 | 1.0 | 1.0 |
+----------------------------+-------+---------+------------+------------+-------+----------------+-------------------+
Table #25 in "band":
Name: band.public.bridge_jwks
Columns: 15
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 100.0% est. rows modified
Row Estimate: 100.0% live of total 1
Rows Changed: ins 100.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 48, 15.5 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 97.4% (idx=92.0%)
Size: 64 KiB
+------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| bridge_jwks_pkey | btree | 16 KiB | | 92.0% | 0 | 0.0 | 0.0 |
+------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #26 in "band":
Name: band.public.bridge_admin_users
Columns: 6
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 24116, 54.0 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 100.0% (idx=99.9%)
Size: 40 KiB
+-------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+-------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| bridge_admin_users_pkey | btree | 16 KiB | | 99.9% | 0 | 0.0 | 0.0 |
+-------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #27 in "band":
Name: band.public.bridge_admin_groups
Columns: 4
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 23139, 2.7 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 100.0% (idx=99.9%)
Size: 8.0 KiB
+--------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+--------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| bridge_admin_groups_pkey | btree | 16 KiB | | 99.9% | 0 | 0.0 | 0.0 |
+--------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #28 in "band":
Name: band.public.bridge_providers
Columns: 7
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 5537, 76.6 rows/scan
Idx Scans: 26328, 1.0 rows/scan
Cache Hits: 100.0% (idx=100.0%)
Size: 16 KiB
+-----------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+-----------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| bridge_providers_pkey | btree | 16 KiB | | 100.0% | 26328 | 1.0 | 1.0 |
+-----------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #29 in "band":
Name: band.public.bridge_adapters
Columns: 8
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 1628, 64.0 rows/scan
Idx Scans: 29425, 1.0 rows/scan
Cache Hits: 100.0% (idx=100.0%)
Size: 48 KiB
+----------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+----------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| bridge_adapters_pkey | btree | 16 KiB | | 100.0% | 29425 | 1.0 | 1.0 |
+----------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #30 in "band":
Name: band.public.bridge_service_accounts
Columns: 7
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 24, 0.0 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 0.0% (idx=100.0%)
Size: 8.0 KiB
+------------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+------------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| bridge_service_accounts_pkey | btree | 8.0 KiB | | 100.0% | 0 | 0.0 | 0.0 |
+------------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
Table #31 in "band":
Name: band.public.bridge_applications
Columns: 6
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 7105, 143.9 rows/scan
Idx Scans: 9600, 1.0 rows/scan
Cache Hits: 100.0% (idx=100.0%)
Size: 56 KiB
+--------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+--------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| bridge_applications_pkey | btree | 16 KiB | | 100.0% | 9600 | 1.0 | 1.0 |
+--------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #32 in "band":
Name: band.public.bridge_normalized_data_maps
Columns: 6
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: 3172, last 4 minutes ago
Auto Analyze: 3034, last 4 minutes ago
Post-Analyze: 20.1% est. rows modified
Row Estimate: 70.5% live of total 359
Rows Changed: ins 50.0%, upd 50.0%, del 0.0%
HOT Updates: 100.0% of all updates
Seq Scans: 0, 0.0 rows/scan
Idx Scans: 257585, 1.0 rows/scan
Cache Hits: 100.0% (idx=100.0%)
Size: 448 KiB
Bloat: 368 KiB (82.1%)
+----------------------------------+-------+--------+------------+------------+--------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+----------------------------------+-------+--------+------------+------------+--------+----------------+-------------------+
| bridge_normalized_data_maps_pkey | btree | 16 KiB | 0 B (0.0%) | 100.0% | 257585 | 1.0 | 1.0 |
+----------------------------------+-------+--------+------------+------------+--------+----------------+-------------------+
Table #33 in "band":
Name: band.public.bridge_kvstores
Columns: 5
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: 1931, last 4 minutes ago
Auto Analyze: 2422, last 4 minutes ago
Post-Analyze: 13.0% est. rows modified
Row Estimate: 82.7% live of total 554
Rows Changed: ins 50.0%, upd 50.0%, del 0.0%
HOT Updates: 100.0% of all updates
Seq Scans: 0, 0.0 rows/scan
Idx Scans: 247571, 1.0 rows/scan
Cache Hits: 100.0% (idx=100.0%)
Size: 552 KiB
Bloat: 448 KiB (81.2%)
+----------------------+-------+--------+----------------+------------+--------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+----------------------+-------+--------+----------------+------------+--------+----------------+-------------------+
| bridge_kvstores_pkey | btree | 72 KiB | 16 KiB (22.2%) | 100.0% | 247571 | 1.0 | 1.0 |
+----------------------+-------+--------+----------------+------------+--------+----------------+-------------------+
Table #34 in "band":
Name: band.public.bridge_public_key_device_stores
Columns: 8
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 96.3% est. rows modified
Row Estimate: 24.8% live of total 109
Rows Changed: ins 57.4%, upd 41.5%, del 0.0%
HOT Updates: 97.4% of all updates
Seq Scans: 0, 0.0 rows/scan
Idx Scans: 1486, 1.0 rows/scan
Cache Hits: 99.3% (idx=99.8%)
Size: 464 KiB
+--------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+--------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| bridge_public_key_device_stores_pkey | btree | 56 KiB | | 99.8% | 1486 | 1.0 | 1.0 |
+--------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #35 in "band":
Name: band.public.bridge_sms_user_stores
Columns: 13
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 190, 8.0 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 99.5% (idx=98.4%)
Size: 16 KiB
+-------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+-------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| sms_user_store_last_name | btree | 16 KiB | | 98.4% | 0 | 0.0 | 0.0 |
| sms_user_store_first_name | btree | 16 KiB | | 98.4% | 0 | 0.0 | 0.0 |
| bridge_sms_user_stores_pkey | btree | 16 KiB | | 98.4% | 0 | 0.0 | 0.0 |
| bridge_sms_user_stores_phone_number | btree | 16 KiB | | 98.4% | 0 | 0.0 | 0.0 |
| sms_user_store_index | gin | 24 KiB | | 98.5% | 0 | 0.0 | 0.0 |
+-------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #36 in "band":
Name: band.public.bridge_adapter_client_link
Columns: 4
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 1621, 64.0 rows/scan
Idx Scans: 11719, 2.3 rows/scan
Cache Hits: 100.0% (idx=100.0%)
Size: 32 KiB
+---------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+---------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| bridge_adapter_client_link_pkey | btree | 16 KiB | | 100.0% | 11719 | 2.3 | 2.3 |
+---------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #37 in "band":
Name: band.public.bridge_client_application_link
Columns: 4
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 444, 191.9 rows/scan
Idx Scans: 39791, 1.9 rows/scan
Cache Hits: 100.0% (idx=100.0%)
Size: 48 KiB
+-------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+-------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| bridge_client_application_link_pkey | btree | 40 KiB | | 100.0% | 39791 | 1.9 | 1.9 |
+-------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #38 in "band":
Name: band.public.bridge_admin_groups_application_link
Columns: 4
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 0, 0.0 rows/scan
Idx Scans: 21667, 1.0 rows/scan
Cache Hits: 100.0% (idx=100.0%)
Size: 8.0 KiB
+-------------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+-------------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| bridge_admin_groups_application_link_pkey | btree | 16 KiB | | 100.0% | 21667 | 1.0 | 1.0 |
+-------------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #39 in "band":
Name: band.public.bridge_admin_users_application_link
Columns: 4
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 2258, 61.0 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 100.0% (idx=99.9%)
Size: 8.0 KiB
+------------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+------------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| bridge_admin_users_application_link_pkey | btree | 16 KiB | | 99.9% | 0 | 0.0 | 0.0 |
+------------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #40 in "band":
Name: band.public.bridge_service_accounts_application_link
Columns: 4
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 0, 0.0 rows/scan
Idx Scans: 70120, 0.0 rows/scan
Cache Hits: 0.0% (idx=100.0%)
Size: 0 B
+-----------------------------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+-----------------------------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| bridge_service_accounts_application_link_pkey | btree | 8.0 KiB | | 100.0% | 70120 | 0.0 | 0.0 |
+-----------------------------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
Table #41 in "band":
Name: band.public.bridge_provider_application_link
Columns: 4
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 2442, 77.0 rows/scan
Idx Scans: 21667, 1.2 rows/scan
Cache Hits: 100.0% (idx=100.0%)
Size: 8.0 KiB
+---------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+---------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| bridge_provider_application_link_pkey | btree | 16 KiB | | 100.0% | 21667 | 1.2 | 1.2 |
+---------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #42 in "band":
Name: band.public.timeseries
Columns: 4
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 0, 0.0 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 0.0% (idx=0.0%)
Size: 8.0 KiB
+--------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+--------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| timeseries_pkey | btree | 8.0 KiB | | | 0 | 0.0 | 0.0 |
| timeseries_name | btree | 8.0 KiB | | | 0 | 0.0 | 0.0 |
| timeseries_machine | btree | 8.0 KiB | | | 0 | 0.0 | 0.0 |
+--------------------+-------+---------+-------+------------+-------+----------------+-------------------+
Table #43 in "band":
Name: band.public.bridge_ad_member_caches
Columns: 8
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: 6, last 22 hours ago
Auto Analyze: 10, last 22 hours ago
Post-Analyze: 57.7% est. rows modified
Row Estimate: 43.7% live of total 71
Rows Changed: ins 44.2%, upd 26.9%, del 28.6%
HOT Updates: 99.0% of all updates
Seq Scans: 286094, 11.3 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 100.0% (idx=100.0%)
Size: 56 KiB
+------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| bridge_ad_member_caches_pkey | btree | 88 KiB | | 100.0% | 0 | 0.0 | 0.0 |
+------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #44 in "band":
Name: band.public.bridge_ad_group_caches
Columns: 6
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: 2, last 22 hours ago
Auto Analyze: 3, last 22 hours ago
Post-Analyze: 0.0% est. rows modified
Row Estimate: 100.0% live of total 8
Rows Changed: ins 51.9%, upd 0.0%, del 48.1%
HOT Updates: 0.0% of all updates
Seq Scans: 7725, 4.6 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 99.9% (idx=99.9%)
Size: 48 KiB
+-----------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+-----------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| bridge_ad_group_caches_pkey | btree | 16 KiB | | 99.9% | 0 | 0.0 | 0.0 |
+-----------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #45 in "band":
Name: band.public.bridge_ad_group_members_cache_link
Columns: 4
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: 2, last 1 day ago
Auto Analyze: 4, last 22 hours ago
Post-Analyze: 54.2% est. rows modified
Row Estimate: 20.8% live of total 48
Rows Changed: ins 51.0%, upd 0.0%, del 49.0%
HOT Updates: 0.0% of all updates
Seq Scans: 38966, 7.9 rows/scan
Idx Scans: 30112, 1.0 rows/scan
Cache Hits: 100.0% (idx=100.0%)
Size: 48 KiB
+-----------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+-----------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| bridge_ad_group_members_cache_link_pkey | btree | 16 KiB | | 100.0% | 30112 | 1.0 | 1.0 |
+-----------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #46 in "band":
Name: band.public.bridge_local_user_stores
Columns: 12
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 227, 21.9 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 99.6% (idx=98.7%)
Size: 40 KiB
+---------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+---------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| bridge_local_user_stores_username_key | btree | 16 KiB | | 98.7% | 0 | 0.0 | 0.0 |
| bridge_local_user_stores_last_name | btree | 16 KiB | | 98.7% | 0 | 0.0 | 0.0 |
| bridge_local_user_stores_username | btree | 16 KiB | | 98.7% | 0 | 0.0 | 0.0 |
| bridge_local_user_stores_pkey | btree | 16 KiB | | 98.7% | 0 | 0.0 | 0.0 |
| bridge_local_user_stores_first_name | btree | 16 KiB | | 98.7% | 0 | 0.0 | 0.0 |
| local_user_store_last_name | btree | 16 KiB | | 98.7% | 0 | 0.0 | 0.0 |
| local_user_store_first_name | btree | 16 KiB | | 98.7% | 0 | 0.0 | 0.0 |
| local_user_store_index | gin | 24 KiB | | | 0 | 0.0 | 0.0 |
+---------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #47 in "band":
Name: band.public.bridge_password_user_stores
Columns: 8
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 194, 68.0 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 99.5% (idx=98.7%)
Size: 48 KiB
+--------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+--------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| bridge_password_user_stores_username | btree | 16 KiB | | 98.7% | 0 | 0.0 | 0.0 |
| bridge_password_user_stores_pkey | btree | 16 KiB | | 98.7% | 0 | 0.0 | 0.0 |
+--------------------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #48 in "band":
Name: band.public.cluster_peers
Columns: 2
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: 3345, last 6 minutes ago
Auto Analyze: 1798, last 11 minutes ago
Post-Analyze: 85.2% est. rows modified
Row Estimate: 3.7% live of total 54
Rows Changed: ins 50.0%, upd 50.0%, del 0.0%
HOT Updates: 100.0% of all updates
Seq Scans: 280975, 2.0 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 100.0% (idx=100.0%)
Size: 40 KiB
+--------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+--------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| cluster_peers_pkey | btree | 16 KiB | | 100.0% | 0 | 0.0 | 0.0 |
+--------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #49 in "band":
Name: band.public.sessions
Columns: 6
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 196.0% est. rows modified
Row Estimate: 97.9% live of total 3924
Rows Changed: ins 49.9%, upd 49.4%, del 0.0%
HOT Updates: 98.7% of all updates
Seq Scans: 8000, 97380.9 rows/scan
Idx Scans: 3850, 1.0 rows/scan
Cache Hits: 100.0% (idx=99.9%)
Size: 11 MiB
Bloat: 2.2 MiB (19.9%)
+---------------+-------+---------+------------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+---------------+-------+---------+------------+------------+-------+----------------+-------------------+
| sessions_pkey | btree | 5.8 MiB | 0 B (0.0%) | 99.9% | 3850 | 1.0 | 1.0 |
+---------------+-------+---------+------------+------------+-------+----------------+-------------------+
Table #50 in "band":
Name: band.public.video_elephant_views
Columns: 6
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 0, 0.0 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 0.0% (idx=0.0%)
Size: 56 KiB
+---------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+---------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
| video_elephant_views_pkey | btree | 16 KiB | | | 0 | 0.0 | 0.0 |
+---------------------------+-------+--------+-------+------------+-------+----------------+-------------------+
Table #51 in "band":
Name: band.public.bridge_kerberos_tokens
Columns: 7
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 0, 0.0 rows/scan
Idx Scans: 0, 0.0 rows/scan
Cache Hits: 0.0% (idx=0.0%)
Size: 8.0 KiB
+-----------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+-----------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| bridge_kerberos_tokens_pkey | btree | 8.0 KiB | | | 0 | 0.0 | 0.0 |
+-----------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
Table #52 in "band":
Name: band.public.notification_nodes
Columns: 3
Manual Vacuums: never
Manual Analyze: never
Auto Vacuums: never
Auto Analyze: never
Post-Analyze: 0.0% est. rows modified
Row Estimate: 0.0% live of total 0
Rows Changed: ins 0.0%, upd 0.0%, del 0.0%
HOT Updates: 0.0% of all updates
Seq Scans: 0, 0.0 rows/scan
Idx Scans: 1022, 0.0 rows/scan
Cache Hits: 0.0% (idx=99.9%)
Size: 0 B
+------------------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |
+------------------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
| notification_nodes_pkey | btree | 8.0 KiB | | 99.9% | 513 | 0.0 | 0.0 |
| notification_nodes_name_not_null | btree | 8.0 KiB | | 99.9% | 0 | 0.0 | 0.0 |
| notification_nodes_notification_id | btree | 8.0 KiB | | 99.9% | 0 | 0.0 | 0.0 |
| notification_nodes_node_id | btree | 8.0 KiB | | 99.9% | 509 | 0.0 | 0.0 |
+------------------------------------+-------+---------+-------+------------+-------+----------------+-------------------+
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment