ankane / dexter

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

`--pg-stat-statements` fails on PG > 12 #43

Closed olirice closed 1 year ago

olirice commented 1 year ago

Running dexter against a Postgres 13, 14, or 15 using --pg-stat-statements fails with error

dexter/indexer.rb:544:in `exec_params': ERROR:  column "total_time" does not exist (PG::UndefinedColumn)

It looks like that is due to a change in pg_catalog.pg_stat_statements column names that occurred between pg 12 ref and pg 13 ref

ankane commented 1 year ago

Hey @olirice, thanks for reporting! Fixed in the commit above.