=# select * from pgstatindex('media.idx_block_unused'); version | tree_level | index_size | root_block_no | internal_pages | leaf_pages | empty_pages | deleted_pages | avg_leaf_density | leaf_fragmentation ---------+------------+------------+---------------+----------------+------------+-------------+---------------+------------------+-------------------- 4 | 2 | 389677056 | 546 | 114 | 23069 | 0 | 24384 | 90.03 | 0(1 row)
pgsql-performance by date:
Соглашаюсь с условиями обработки персональных данных