From the Learning PostgreSQL
The first view is pg_stat_all_indexes, which gives the statistics about the index usage The function pg_index_size can be used with the pg_size_pretty function to get the index size in a human-readable form, as follows:
Поиск
11 сент. 2024 г.время чтения ~1 мин.
From the Learning PostgreSQL
The first view is pg_stat_all_indexes, which gives the statistics about the index usage The function pg_index_size can be used with the pg_size_pretty function to get the index size in a human-readable form, as follows: