postgres pghero - ghdrako/doc_snipets GitHub Wiki

PgHero is an open source PostgreSQL performance dashboard. PgHero ships as an open source Rails Engine and has been added to Rideshare as a Ruby gem. It’s also available as a Docker container.[167] When PGSS is enabled, PgHero captures and stores results in its own tables from the system view. PgHero presents the following data on the Queries screen:

• Total number of calls
• Average duration
• The percentage the query represents among the total number of query executions

Use PgHero which detects and displays overlapping indexes. PgHero has a method, .duplicate_indexes(), that’s used to compare covered columns and checks for overlaps. PgHero also displays duplicate indexes with a message like “These indexes exist but aren’t needed.”