dtseiler / pgstatspack2 Goto Github PK

ERROR: syntax error at or near "."
LINE 90: i.idx_scan AS idx_scan,

ERROR: syntax error at or near "JOIN"
LINE 98: JOIN pg_statio_all_indexes ii ON i.indexrelid = ii.i...

ERROR: syntax error at or near "ERROR"
LINE 1: ERROR: syntax error at or near "JOIN"

ERROR: syntax error at or near "pgstatspack2"
LINE 99: JOIN pgstatspack2.pgstatspack2_names n1 ON i.scheman...

I am getting different different issues while running the pgstatspack2_snap.sql.

Can you please help here..

Remaining all the scripts looks good and working.

Right now the pgstatspack2_delete_snap() function is hard-coded to delete anything older than 30 days.

    SELECT current_timestamp - interval '30 days' INTO old_snap_time;

    SELECT max(snapid) INTO old_snap_id FROM pgstatspack_snap WHERE ts < old_snap_time;

This should be customizable through a retained setting, as well as perhaps a parameter. For example, if the parameter is not supplied, it falls back to the stored setting.

Suggested by Frits Hoogland, have eventual support for grafana visualisation of data.

Make sure all objects go into pgstatspack2 schema. Be explicit with all SQL/DDL/DML to reference objects with the qualified schema.