ankane/dexter

pg_stat_statements new version support

sokoow opened this issue · 2 comments

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?

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

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

ALTER EXTENSION pg_stat_statements UPDATE;