From: | Kshetrapaldesi Tutika <kshetra1(at)gmail(dot)com> |
---|---|
To: | pgsql-hackers(at)lists(dot)postgresql(dot)org |
Cc: | Ken Kato <katouknl(at)oss(dot)nttdata(dot)com> |
Subject: | Re: Add last_vacuum_index_scans in pg_stat_all_tables |
Date: | 2022-10-02 06:56:04 |
Message-ID: | 166469376436.1133.16003874192870968691.pgcf@coridan.postgresql.org |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-hackers |
I applied this patch in my local environment and would like to reviewthe same before 14-October-2022 with some test data
postgres=# \d pg_stat_all_tables
View "pg_catalog.pg_stat_all_tables"
Column | Type | Collation | Nullable | Default
-------------------------+--------------------------+-----------+----------+---------
relid | oid | | |
schemaname | name | | |
relname | name | | |
seq_scan | bigint | | |
seq_tup_read | bigint | | |
idx_scan | bigint | | |
idx_tup_fetch | bigint | | |
n_tup_ins | bigint | | |
n_tup_upd | bigint | | |
n_tup_del | bigint | | |
n_tup_hot_upd | bigint | | |
n_live_tup | bigint | | |
n_dead_tup | bigint | | |
n_mod_since_analyze | bigint | | |
n_ins_since_vacuum | bigint | | |
last_vacuum | timestamp with time zone | | |
last_autovacuum | timestamp with time zone | | |
last_analyze | timestamp with time zone | | |
last_autoanalyze | timestamp with time zone | | |
vacuum_count | bigint | | |
autovacuum_count | bigint | | |
analyze_count | bigint | | |
autoanalyze_count | bigint | | |
last_vacuum_index_scans | bigint | | |
postgres=# select version();
version
----------------------------------------------------------------------------------------------------------
PostgreSQL 15beta4 on x86_64-pc-linux-gnu, compiled by gcc (Ubuntu 9.4.0-1ubuntu1~20.04.1) 9.4.0, 64-bit
(1 row)
From | Date | Subject | |
---|---|---|---|
Next Message | Andres Freund | 2022-10-02 06:56:59 | Re: proposal: possibility to read dumped table's name from file |
Previous Message | Andres Freund | 2022-10-02 01:49:58 | Re: Documentation building fails on HTTPS redirect (again) |