I couldn't find a simple way to list the estimated number of rows per partition and subpartition in PostgreSQL so I created a view as suggested by the member MatheusOl:
CREATE OR REPLACE VIEW row_counts AS SELECT relname, reltuples::numeric FROM pg_class pg, information_schema.tables i WHERE pg.relname = i.table_name AND relkind='r' AND table_schema NOT IN ('pg_catalog', 'information_schema');Logon to your database using psql and create the view. Then, query it and the result would be something similar to querying dba_tab_partitions and dba_tab_subpartitions in Oracle:
relname | reltuples ---------------------------------+------------- event_sp_2019_ukf | 20799 event_sp_2019_vasplpr | 0 event_sp_2019_ukp | 120 event_sp_2019_ltp | 0 event_sp_2019_smp | 95
The view will not distinguished between tables, partitiones or subpartitions - they're all tables in terms of object types.
No comments:
Post a Comment