Re: Add last_vacuum_index_scans in pg_stat_all_tables

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)

In response to

Responses

Browse pgsql-hackers by date

  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)