How to see the current status and maintenance rules of statistics in PostgreSQL, by analogy with the DBCC SHOW_STATISTICS

Viewed 13

How to see the current status and maintenance rules of statistics in PostgreSQL, by analogy with the DBCC SHOW_STATISTICS command from MSSQL? And also interested in how best to measure index fragmentation and page density in PostgreSQL? Those, in summary, I need to understand how often and correctly the database is maintained in terms of statistics and indexes.

0 Answers
Related