explainbench.sql

application/sql

Filename: explainbench.sql

Type: application/sql

Part: 0

Message: Re: Stack-based tracking of per-node WAL/buffer usage

SELECT pg_prewarm('pgbench_accounts');

PREPARE query AS SELECT * FROM pgbench_accounts OFFSET 5000000 LIMIT 1;

EXPLAIN (ANALYZE, BUFFERS OFF, WAL OFF, TIMING OFF)
EXECUTE query;

EXPLAIN (ANALYZE, BUFFERS OFF, WAL OFF, TIMING ON)
EXECUTE query;

EXPLAIN (ANALYZE, BUFFERS ON, WAL ON, TIMING OFF)
EXECUTE query;

EXPLAIN (ANALYZE, BUFFERS ON, WAL ON, TIMING ON)
EXECUTE query;

DEALLOCATE query;