Re: Add last_vacuum_index_scans in pg_stat_all_tables - Mailing list pgsql-hackers

From Kshetrapaldesi Tutika
Subject Re: Add last_vacuum_index_scans in pg_stat_all_tables
Date
Msg-id 166469376436.1133.16003874192870968691.pgcf@coridan.postgresql.org
Whole thread Raw
In response to Re: Add last_vacuum_index_scans in pg_stat_all_tables  (Alvaro Herrera <alvherre@alvh.no-ip.org>)
Responses Re: Add last_vacuum_index_scans in pg_stat_all_tables  (Ken Kato <katouknl@oss.nttdata.com>)
List 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)

pgsql-hackers by date:

Previous
From: Andres Freund
Date:
Subject: Re: Documentation building fails on HTTPS redirect (again)
Next
From: Andres Freund
Date:
Subject: Re: proposal: possibility to read dumped table's name from file