Useful PostgreSQL utilities
You can not select more than 25 topics Topics must start with a letter or number, can include dashes ('-') and can be up to 35 characters long.
 
 
 

7 lines
298 B

create extension IF NOT EXISTS pg_stat_statements;
create sequence query_stat_seq;
create table query_stat_log as select 1 as seq_num,now() as ts,* from query_stat_time;
create index query_stat_log_seq_num_key on query_stat_log(seq_num);
create index query_stat_log_ts_key on query_stat_log(ts);