4.8. Index Usage Metrics #

Metrics based on the pg_stat_all_indexes and pg_statio_all_indexes views, collected by the indexes plugin:

  • postgresql.indexes.invalid{database, schema, table, index}

  • postgresql.indexes.blocks_hit{database, schema, table, index}

  • postgresql.indexes.blocks_read{database, schema, table, index}

  • postgresql.indexes.scan{database, schema, table, index}

  • postgresql.indexes.size_bytes{database, schema, table, index}

  • postgresql.indexes.tuples_fetch{database, schema, table, index}

  • postgresql.indexes.tuples_read{database, schema, table, index}