PostgreSQL Index Advisor A PostgreSQL extension for recommending indexes to improve query performance. Features Supports generic parameters e.g. $1, $2 Supports materialized views Identifies tables/columns obfuscaed by views API Description For a given query, searches for a set of SQL DDL create index statements that improve the query's execution time; Signature index_advisor(query text) returns table ( startup_cost_before jsonb, startup_cost_after jsonb, total_cost_before jsonb, total_cost_aft...