大一网站开发项目答辩,wordpress out of memory,购物网站建设个人总结,网站开发实现本地注册登录pgmetrics是用go语言写的一款PostgreSQL的健康监控指标采集软件。可以连接到数据库#xff0c;获取当前数据库的相关信息#xff0c;如果连接的是本地数据库#xff0c;则同时会采集服务器的状态信息。可以把采集的结果以json或者text或者csv的形式存储。
1.下载pgmetrics的…pgmetrics是用go语言写的一款PostgreSQL的健康监控指标采集软件。可以连接到数据库获取当前数据库的相关信息如果连接的是本地数据库则同时会采集服务器的状态信息。可以把采集的结果以json或者text或者csv的形式存储。
1.下载pgmetrics的软件
https://github.com/rapidloop/pgmetrics/releases
postgresubuntu-linux-22-04-desktop:~$ ll pgmetrics_1.16.0_linux_arm64.tar.gz
-rw-r--r-- 1 postgres postgres 4361437 Mar 19 15:37 pgmetrics_1.16.0_linux_arm64.tar.gz
postgresubuntu-linux-22-04-desktop:~$ tar -xf pgmetrics_1.16.0_linux_arm64.tar.gz
postgresubuntu-linux-22-04-desktop:~$ cd pgmetrics_1.16.0_linux_arm64/
postgresubuntu-linux-22-04-desktop:~/pgmetrics_1.16.0_linux_arm64$ ll
total 14872
drwxrwxr-x 2 postgres postgres 4096 Mar 19 15:37 ./
drwxr-x--- 21 postgres postgres 4096 Mar 19 15:37 ../
-rw-r--r-- 1 postgres postgres 11357 Feb 3 2023 LICENSE
-rw-r--r-- 1 postgres postgres 377 Feb 3 2023 README.md
-rwxr-xr-x 1 postgres postgres 15204352 Oct 4 12:13 pgmetrics*2.pgmetrics的选项
postgresubuntu-linux-22-04-desktop:~/pgmetrics_1.16.0_linux_arm64$ ./pgmetrics --help
pgmetrics collects PostgreSQL information and metrics.Usage:pgmetrics [OPTION]... [DBNAME]General options:-t, --timeoutSECS individual query timeout in seconds (default: 5)--lock-timeoutMILLIS lock timeout in milliseconds (default: 50)-i, --inputFILE dont connect to db, instead read and displaythis previously saved JSON file-V, --version output version information, then exit-?, --help[options] show this help, then exit--helpvariables list environment variables, then exitCollection options:-S, --no-sizes dont collect tablespace and relation sizes-c, --schemaREGEXP collect only from schema(s) matching POSIX regexp-C, --exclude-schemaREGEXP do NOT collect from schema(s) matching POSIX regexp-a, --tableREGEXP collect only from table(s) matching POSIX regexp-A, --exclude-tableREGEXP do NOT collect from table(s) matching POSIX regexp--omitWHAT do NOT collect the items specified as a comma-separatedlist of: tables, indexes, sequences,functions, extensions, triggers,statements, log, citus, indexdefs,bloat--sql-lengthLIMIT collect only first LIMIT characters of all SQLqueries (default: 500)--statements-limitLIMIT collect only utmost LIMIT number of row frompg_stat_statements (default: 100)--only-listed collect info only from the databases listed ascommand-line args (use with Heroku)--all-dbs collect info from all user databases--log-file location of PostgreSQL log file--log-dir read all the PostgreSQL log files in this directory--log-spanMINS examine the last MINS minutes of logs (default: 5)--aws-rds-dbid AWS RDS/Aurora database instance identifier--az-resource Azure resource ID--pgpool collect only Pgpool metricsOutput options:-f, --formatFORMAT output format; human, json or csv (default: human)-l, --toolongSECS for human output, transactions running longer thanthis are considered too long (default: 60)-o, --outputFILE write output to the specified file--no-pager do not invoke the pager for tty outputConnection options:-h, --hostHOSTNAME database server host or socket directory(default: /var/run/postgresql)-p, --portPORT database server port (default: 5432)-U, --usernameUSERNAME database user name (default: postgres)-w, --no-password never prompt for password--roleROLE do SET ROLE before collectionFor more information, visit https://pgmetrics.io.3.使用案例
设置超时时间为3s避免阻塞业务。
postgresubuntu-linux-22-04-desktop:~/pgmetrics_1.16.0_linux_arm64$ ./pgmetrics -t 3 --no-password --no-pager -h /tmp -o ./PostgreSQL_Checklog_date %Y-
%m-%d-%H%M%S.log postgres test_upgrade
pgmetrics: warning: failed to guess log file location/access denied, specify explicitly with --log-file or --log-dirpostgresubuntu-linux-22-04-desktop:~/pgmetrics_1.16.0_linux_arm64$ ll
total 14912
drwxrwxr-x 2 postgres postgres 4096 Mar 19 15:46 ./
drwxr-x--- 21 postgres postgres 4096 Mar 19 15:42 ../
-rw-r--r-- 1 postgres postgres 11357 Feb 3 2023 LICENSE
-rw-rw-r-- 1 postgres postgres 37143 Mar 19 15:46 PostgreSQL_Checklog_2024-03-19-154620.log
-rw-r--r-- 1 postgres postgres 377 Feb 3 2023 README.md
-rwxr-xr-x 1 postgres postgres 15204352 Oct 4 12:13 pgmetrics*报告的内容如下 pgmetrics run at: 19 Mar 2024 3:46:20 PM (now)PostgreSQL Cluster:Name:Server Version: 16.1Server Started: 19 Mar 2024 3:22:34 PM (23 minutes ago)System Identifier: 7316572678719819371Timeline: 1Last Checkpoint: 19 Mar 2024 3:22:34 PM (23 minutes ago)REDO LSN: 0/3D1DA560Checkpoint LSN: 0/3D1DA560 (0 B since REDO)Transaction IDs: oldest 726, next 2189, range 1463Notification Queue: 0.0% usedActive Backends: 1 (max 100)Recovery Mode? noSystem Information:Hostname: ubuntu-linux-22-04-desktopCPU Cores: 0 xLoad Average: 0.28Memory: used707 MiB, free218 MiB, buff251 MiB, cache564 MiBSwap: used167 MiB, free1.8 GiB--------------------------------------------------| Setting | Value |--------------------------------------------------| shared_buffers | 16384 (128 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 |--------------------------------------------------WAL Files:WAL Archiving? noWAL Files: 3------------------------------------| Setting | Value |------------------------------------| wal_level | replica || archive_timeout | 0 || wal_compression | off || max_wal_size | 1024 (1.0 GiB) || min_wal_size | 80 (80 MiB) || checkpoint_timeout | 300 || full_page_writes | on || wal_keep_size | 0 |------------------------------------BG Writer:Checkpoint Rate: 0.21 per minAverage Write: 0 B per checkpointTotal Checkpoints: 4 sched (80.0%) 1 req (20.0%) 5Total Write: 0 B, 0 B per secBuffers Allocated: 842 (6.6 MiB)Buffers Written: 0 chkpt (0.0%) 0 bgw (0.0%) 0 be (0.0%)Clean Scan Stops: 0BE fsyncs: 0Counts Since: 19 Mar 2024 3:22:34 PM (23 minutes 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.9 |--------------------------------------------Backends:Total Backends: 1 (1.0% of max 100)Problematic: 0 waiting on locks, 0 waiting on other, 0 xact too long, 0 idle in xactLocks:--------------------------------| 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_checkpoint | | | | | | | yes | ||| pg_use_reserved_connections | | | | | | | yes | ||| pg_read_server_files | | | | | | | yes | ||| pg_write_server_files | | | | | | | yes | ||| pg_execute_server_program | | | | | | | yes | ||| pg_database_owner | | | | | | | yes | ||| pg_read_all_data | | | | | | | yes | ||| pg_write_all_data | | | | | | | yes | ||| pg_create_subscription | | | | | | | yes | ||| repl | yes | yes | | | | | yes | ||| ysla | yes | | | | | | yes | ||| test10 | yes | | | | | | yes | 17 Aug 2024 12:40:09 PM ||| test11 | yes | | | | | | yes | 23 Feb 2024 1:57:19 PM ||---------------------------------------------------------------------------------------------------------------------------------------------
-------------------------------------Tablespaces:----------------------------------------------------------------------------------------------------------------------| Name | Owner | Location | Size | Disk Used | Inode Used |----------------------------------------------------------------------------------------------------------------------| pg_default | postgres | $PGDATA /home/postgres/data-16 | 33 MiB | 27 GiB (43.7%) of 62 GiB | 419716 (10.2%) of 4128768 || pg_global | postgres | $PGDATA /home/postgres/data-16 | 588 KiB | 27 GiB (43.7%) of 62 GiB | 419716 (10.2%) of 4128768 |----------------------------------------------------------------------------------------------------------------------Database #1:Name: postgresOwner: postgresTablespace: pg_defaultConnections: 1 (no max limit)Frozen Xid Age: 1463Transactions: 71 (100.0%) commits, 0 (0.0%) rollbacksCache Hits: 96.0%Rows Changed: ins 0.0%, upd 0.0%, del 0.0%Total Temp: 0 B in 0 filesProblems: 0 deadlocks, 0 conflictsTotals Since:Size: 12 MiBSequences:------------------------------------------| Sequence | Cache Hits |------------------------------------------| hints_id_seq | || student_student_id_seq | || test_vaccum_index_on_id_seq | || test_vaccum_index_off_id_seq | |------------------------------------------Installed Extensions:-----------------------------------------------------------------------------------------------------| Name | Version | Comment |-----------------------------------------------------------------------------------------------------| pg_bigm | 1.2 | text similarity measurement and index searching based on bigrams || pg_hint_plan | 1.4.2 | || pg_stat_statements | 1.9 | track planning and execution statistics of all SQL statements executed || pg_trgm | 1.6 | text similarity measurement and index searching based on trigrams || pgcrypto | 1.3 | cryptographic functions || plpgsql | 1.0 | PL/pgSQL procedural language |-----------------------------------------------------------------------------------------------------Slow Queries:--------------------------------------------------------------------------------------------| Calls | Avg Time | Total Time | Rows/Call | Query |--------------------------------------------------------------------------------------------| 4 | 4ms | 17ms | 1 | SELECT pg_database_size($1) || 4 | 3ms | 13ms | 1 | SELECT pg_tablespace_size($1) || 1 | 9ms | 9ms | 9 | SELECT current_database() AS db, schemaname, tab || 2 | 2ms | 5ms | 378 | SELECT name, setting, COALESCE(boot_val,$1), sourc || 2 | 2ms | 4ms | 19 | SELECT S.relid, S.schemaname, S.relname, current_d || 2 | 1ms | 3ms | 0 | SELECT funcid, schemaname, funcname, current_datab || 2 | 1ms | 2ms | 6 | SELECT name, current_database(), COALESCE(default_ || 2 | 0s | 1ms | 1 | SELECT EXTRACT($1 FROM pg_postmaster_start_time()) || 2 | 0s | 0s | 1 | SELECT COALESCE(datname, $2), COALESCE(usename, $3 || 1 | 0s | 0s | 4 | SELECT d.datname as Name, pg_catalog.pg_get_ || 2 | 0s | 0s | 5 | SELECT COALESCE(D.datname, $1), L.locktype, L.mode || 2 | 0s | 0s | 12 | SELECT S.relid, S.indexrelid, S.schemaname, S.reln || 2 | 0s | 0s | 12 | SELECT indexrelid, pg_get_indexdef(indexrelid) FRO || 1 | 0s | 0s | 44 | SELECT userid, dbid, queryid, LEFT(COALESCE(query, || 2 | 0s | 0s | 3 | SELECT name FROM pg_ls_waldir() WHERE name ~ $1 || 2 | 0s | 0s | 1 | SELECT checkpoints_timed, checkpoints_req, checkpo || 2 | 0s | 0s | 19 | SELECT R.oid, R.rolname, R.rolsuper, R.rolinherit, || 2 | 0s | 0s | 2 | SELECT c.oid, i.inhparent::regclass FROM pg_cla || 2 | 0s | 0s | 0 | SELECT c.oid, inhparent::regclass, COALESCE(pg_get || 2 | 0s | 0s | 0 | SELECT COALESCE(usename, $1), application_name, || 2 | 0s | 0s | 1 | SELECT checkpoint_lsn, redo_lsn, timeline_id, n || 2 | 0s | 0s | 2 | SELECT oid, spcname, pg_get_userbyid(spcowner), || 2 | 0s | 0s | 2 | SELECT D.oid, D.datname, D.datdba, D.dattablespace || 2 | 0s | 0s | 1 | SELECT system_identifier FROM pg_control_system() || 2 | 0s | 0s | 1 | SELECT pg_is_in_recovery(), COALESCE(pg_last_wa || 2 | 0s | 0s | 1 | SELECT archived_count, COALESCE(last_archived_ || 2 | 0s | 0s | 4 | SELECT relid, schemaname, relname, current_databas || 2 | 0s | 0s | 1 | SELECT current_user || 2 | 0s | 0s | 6 | SELECT backend_type, count(*) FROM pg_stat_activit || 2 | 0s | 0s | 1 | SELECT COUNT(*) FROM pg_ls_archive_statusdir() WHE || 2 | 0s | 0s | 0 | SELECT pid, datname, relid::int, COALESCE(command, || 2 | 0s | 0s | 0 | WITH P AS (SELECT DISTINCT pid FROM pg_locks WHERE || 2 | 0s | 0s | 0 | SELECT status, receive_start_lsn, receive_start_tl || 2 | 0s | 0s | 1 | SELECT wal_records, wal_fpi, wal_bytes, wal_buffer || 2 | 0s | 0s | 0 | SELECT slot_name, COALESCE(plugin, $1), slot_type, || 2 | 0s | 0s | 1 | SELECT COALESCE(pg_current_logfile($1),$2) || 2 | 0s | 0s | 1 | SELECT pg_notification_queue_usage() || 2 | 0s | 0s | 0 | SELECT pid, datname, COALESCE(relid, $1), COALESCE || 2 | 0s | 0s | 1 | SELECT COALESCE(inet_client_addr() inet_server_a || 2 | 0s | 0s | 0 | SELECT pid, datname, relid::int, COALESCE(command, || 2 | 0s | 0s | 0 | SELECT pid, datname, COALESCE(relid::int, $1::int) || 2 | 0s | 0s | 0 | SELECT pid, datname, relid::int, index_relid::int, || 2 | 0s | 0s | 0 | SELECT pid, COALESCE(phase, $1), COALESCE(bac || 2 | 0s | 0s | 1 | SELECT pg_current_wal_flush_lsn(), pg_current_ || 2 | 0s | 0s | 1 | SELECT current_database() || 2 | 0s | 0s | 0 | SELECT T.oid, T.tgrelid, T.tgname, P.proname F || 1 | 0s | 0s | 0 | WITH pc AS (SELECT pubname, COUNT(*) AS c FROM pg_ || 1 | 0s | 0s | 0 | WITH sc AS (SELECT srsubid, COUNT(*) AS c FROM |--------------------------------------------------------------------------------------------Database #2:Name: test_upgradeOwner: postgresTablespace: pg_defaultConnections: 0 (no max limit)Frozen Xid Age: 1463Transactions: 18 (100.0%) commits, 0 (0.0%) rollbacksCache Hits: 95.6%Rows Changed: ins 0.0%, upd 0.0%, del 0.0%Total Temp: 0 B in 0 filesProblems: 0 deadlocks, 0 conflictsTotals Since:Size: 7.3 MiBInstalled Extensions:-------------------------------------------------------------------------------------| Name | Version | Comment |-------------------------------------------------------------------------------------| pg_bigm | 1.2 | text similarity measurement and index searching based on bigrams || pg_trgm | 1.6 | text similarity measurement and index searching based on trigrams || plpgsql | 1.0 | PL/pgSQL procedural language |-------------------------------------------------------------------------------------Slow Queries:--------------------------------------------------------------------------------------------| Calls | Avg Time | Total Time | Rows/Call | Query |--------------------------------------------------------------------------------------------| 1 | 7ms | 7ms | 7 | SELECT current_database() AS db, schemaname, tab || 1 | 3ms | 3ms | 0 | SELECT funcid, schemaname, funcname, current_datab || 1 | 0s | 0s | 2 | SELECT S.relid, S.schemaname, S.relname, current_d || 1 | 0s | 0s | 3 | SELECT name, current_database(), COALESCE(default_ || 1 | 0s | 0s | 0 | SELECT S.relid, S.indexrelid, S.schemaname, S.reln || 1 | 0s | 0s | 0 | SELECT indexrelid, pg_get_indexdef(indexrelid) FRO || 1 | 0s | 0s | 0 | SELECT relid, schemaname, relname, current_databas || 1 | 0s | 0s | 1 | SELECT current_database() || 1 | 0s | 0s | 0 | WITH pc AS (SELECT pubname, COUNT(*) AS c FROM pg_ || 1 | 0s | 0s | 0 | WITH sc AS (SELECT srsubid, COUNT(*) AS c FROM || 1 | 0s | 0s | 0 | SELECT T.oid, T.tgrelid, T.tgname, P.proname F || 1 | 0s | 0s | 0 | SELECT c.oid, inhparent::regclass, COALESCE(pg_get || 1 | 0s | 0s | 0 | SELECT c.oid, i.inhparent::regclass FROM pg_cla |--------------------------------------------------------------------------------------------Table #1 in postgres:Name: postgres.hint_plan.hintsColumns: 4Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 8.0 KiBACL:-------------------------------------------------------------------------------------| Role | Privileges | Granted By |-------------------------------------------------------------------------------------| postgres | INSERT, SELECT, UPDATE, DELETE, TRUNCATE, REFERENCES, TRIGGER | postgres || PUBLIC | SELECT | postgres |--------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |-------------------------------------------------------------------------------------------------| hints_pkey | btree | 8.0 KiB | | | 0 | 0.0 | 0.0 || hints_norm_and_app | btree | 8.0 KiB | | | 0 | 0.0 | 0.0 |-------------------------------------------------------------------------------------------------Table #2 in postgres:Name: postgres.public.tab_test_1Columns: 1Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 8.0 KiB-----------------------------------------------------------------------------------| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |-----------------------------------------------------------------------------------| idx_1 | btree | 16 KiB | | | 0 | 0.0 | 0.0 |-----------------------------------------------------------------------------------Table #3 in postgres:Name: postgres.public.tab_test_2Columns: 1Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 8.0 KiBTable #4 in postgres:Name: postgres.public.tab_testdumpColumns: 3Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 16 KiBTable #5 in postgres:Name: postgres.public.tab_1Columns: 3Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 16 KiB-----------------------------------------------------------------------------------| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |-----------------------------------------------------------------------------------| idx1 | btree | 16 KiB | | | 0 | 0.0 | 0.0 || idx2 | btree | 16 KiB | | | 0 | 0.0 | 0.0 |-----------------------------------------------------------------------------------Table #6 in postgres:Name: postgres.public.test_default_1Columns: 2Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 8.0 KiBTable #7 in postgres:Name: postgres.public.test_default_2Columns: 2Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 8.0 KiBTable #8 in postgres:Name: postgres.public.test_default_3Columns: 2Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 16 KiBTable #9 in postgres:Name: postgres.public.tab_xmaster_yslColumns: 2Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 8.0 KiBTable #10 in postgres:Name: postgres.public.studentColumns: 3Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 0 BTable #11 in postgres:Name: postgres.public.student_qualifiedInherits from: studentColumns: 3Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 0 BTable #12 in postgres:Name: postgres.public.student_nqualifiedInherits from: studentColumns: 3Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 0 BTable #13 in postgres:Name: postgres.public.test_vaccum_index_onColumns: 3Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 48 KiB--------------------------------------------------------------------------------------------------------| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |--------------------------------------------------------------------------------------------------------| test_vaccum_index_on_pkey | btree | 16 KiB | | | 0 | 0.0 | 0.0 || test_vaccum_index_on_x_key | btree | 16 KiB | | | 0 | 0.0 | 0.0 || z | btree | 16 KiB | | | 0 | 0.0 | 0.0 |--------------------------------------------------------------------------------------------------------Table #14 in postgres:Name: postgres.public.test_vaccum_index_offColumns: 3Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 48 KiB---------------------------------------------------------------------------------------------------------| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |---------------------------------------------------------------------------------------------------------| test_vaccum_index_off_pkey | btree | 16 KiB | | | 0 | 0.0 | 0.0 || test_vaccum_index_off_x_key | btree | 16 KiB | | | 0 | 0.0 | 0.0 || z2 | btree | 16 KiB | | | 0 | 0.0 | 0.0 |---------------------------------------------------------------------------------------------------------Table #15 in postgres:Name: postgres.public.testColumns: 1Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 1.8 MiBBloat: 888 KiB (49.1%)--------------------------------------------------------------------------------------------------| Index | Type | Size | Bloat | Cache Hits | Scans | Rows Read/Scan | Rows Fetched/Scan |--------------------------------------------------------------------------------------------------| test_pkey | btree | 2.2 MiB | 1.4 MiB (64.5%) | | 0 | 0.0 | 0.0 |--------------------------------------------------------------------------------------------------Table #16 in postgres:Name: postgres.public.tColumns: 1Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 8.0 KiBTable #17 in postgres:Name: postgres.public.test_dataColumns: 1Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 8.0 KiBTable #18 in postgres:Name: postgres.public.t2Columns: 1Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 16 KiBTable #19 in postgres:Name: postgres.public.t3Columns: 1Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 16 KiBTable #1 in test_upgrade:Name: test_upgrade.public.test01Columns: 2Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 8.0 KiBTable #2 in test_upgrade:Name: test_upgrade.public.txaColumns: 1Manual Vacuums: neverManual Analyze: neverAuto Vacuums: neverAuto Analyze: neverPost-Analyze: 0.0% est. rows modifiedRow Estimate: 0.0% live of total 0Rows Changed: ins 0.0%, upd 0.0%, del 0.0%HOT Updates: 0.0% of all updatesSeq Scans: 0, 0.0 rows/scanIdx Scans: 0, 0.0 rows/scanCache Hits: 0.0% (idx0.0%)Size: 0 B
