create extension pg_prewarm;

select pg_prewarm('pgbench_accounts', 'main', 'read', NULL, NULL);
select pg_prewarm('pgbench_branches', 'main', 'read', NULL, NULL);
select pg_prewarm('pgbench_tellers', 'main', 'read', NULL, NULL);
select pg_prewarm('pgbench_accounts_pkey', 'main', 'read', NULL, NULL);
select pg_prewarm('pgbench_branches_pkey', 'main', 'read', NULL, NULL);
select pg_prewarm('pgbench_tellers_pkey', 'main', 'read', NULL, NULL);

select pg_prewarm('pgbench_accounts', 'main', 'buffer', NULL, NULL);
select pg_prewarm('pgbench_branches', 'main', 'buffer', NULL, NULL);
select pg_prewarm('pgbench_tellers', 'main', 'buffer', NULL, NULL);
select pg_prewarm('pgbench_accounts_pkey', 'main', 'buffer', NULL, NULL);
select pg_prewarm('pgbench_branches_pkey', 'main', 'buffer', NULL, NULL);
select pg_prewarm('pgbench_tellers_pkey', 'main', 'buffer', NULL, NULL);



