Skip to content

Collect index statistics in a system table #308

Open
@Ngalstyan4

Description

It would be good to have a GUC-gated flag that enables statistics collection on index usage patterns in a systems table (e.g. table with schema lantern.index_usage_statistics(indexoid OID, tableoid OID, indexdef TEXT, ...metrics);
In particular, it would be good to collect the following for each index:

  • Average number of graph nodes traversed per search
  • Average memory usage per search
  • Read amplification (number of bytes read from DB index pages over number of bytes necessary for hnsw graph traversal)

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions