search

ankane / dexter

The automatic indexer for Postgres
MIT License
1.9k stars 47 forks source link

pg_stat_statements new version support #55

Closed sokoow closed 5 months ago

sokoow commented 5 months ago

Hi All,

I'm getting this when using it with pg_stat_statements:

/var/lib/gems/3.0.0/gems/pgdexter-0.5.5/lib/dexter/indexer.rb:548:in `exec_params': ERROR:  column "total_plan_time" does not exist (PG::UndefinedColumn)
LINE 1: ...ents.dbid WHERE datname = current_database() AND (total_plan...

Any chance to resolve it?

sokoow commented 5 months ago

forgot to menion, I'm on postgres 14 on RDS

ankane commented 5 months ago

Hi @sokoow, it looks like pg_stat_statements is out-of-date. You can update it with:

ALTER EXTENSION pg_stat_statements UPDATE;