pg_stat_statements in TimescaleDB 2.18

This repo contains helps to show a bug in TimescaleDB 2.18.

To reproduce:

• Run docker compose up
• Open a PostgreSQL shell for Timescale 2.17.2 using docker exec -it ts2_17 psql -U app
  • Run a query a few times, like SELECT (1 + 2);
  • Look at query stats with

    SELECT query,
       rolname AS user,
       calls
    FROM pg_stat_statements
    INNER JOIN
    pg_roles ON pg_roles.oid = pg_stat_statements.userid
    WHERE calls > 0
    ORDER BY calls DESC LIMIT 5;

    • Observe your queries appear as SELECT ($1 + $2)
• Open a PostgreSQL shell for Timescale 2.18 using docker exec -it ts2_18 psql -U app
  • Run a query a few times, like SELECT (1 + 2);
  • Look at the query stats using the above query again and observe the test-query doesn't appear.