Select Code to Download

log_min_duration_statement = -1    # -1 is disabled, 0 logs all statem
+ents
                    # and their durations, > 0 logs only
                    # statements running at least this number
                    # of milliseconds

echo "
create table t(n integer primary key);
...

explain (analyze, verbose, format yaml) select count(*) from t where n
+ between 10 and 20;
" | psql -qtAX

- Plan:
...
  Triggers:
  Execution Time: 0.149