Created
February 14, 2020 22:01
-
-
Save snehesht/752909c1b1cca73b338c9affc0d6b180 to your computer and use it in GitHub Desktop.
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
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