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;
