explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xFD7

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 7,348.110 ↑ 1.0 100 1
→

Limit (cost=273,701.59..273,713.26 rows=100 width=809) (actual time=7,342.684..7,348.110 rows=100 loops=1)

  • Buffers: shared hit=218 read=19191
2. 0.000 7,348.094 ↑ 91,746.4 100 1
→

Gather Merge (cost=273,701.59..1,344,150.99 rows=9,174,640 width=809) (actual time=7,342.682..7,348.094 rows=100 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Buffers: shared hit=218 read=19191
3. 3,891.714 21,862.332 ↑ 45,873.2 100 3
→

Sort (cost=272,701.57..284,169.87 rows=4,587,320 width=809) (actual time=7,287.438..7,287.444 rows=100 loops=3)

  • Sort Key: pgbench_accounts.abalance
  • Sort Method: top-N heapsort Memory: 51kB
  • Buffers: shared hit=218 read=19191
4. 2,891.211 17,970.618 ↑ 1.4 3,333,330 3
→

Hash Left Join (cost=308.07..97,377.50 rows=4,587,320 width=809) (actual time=267.920..5,990.206 rows=3,333,330 loops=3)

  • Hash Cond: (pgbench_accounts.bid = pgbench_tellers.bid)
  • Buffers: shared hit=204 read=19191
5. 516.591 14,688.456 ↑ 1.4 333,333 3
→

Hash Join (cost=28.07..44,325.43 rows=459,926 width=457) (actual time=137.494..4,896.152 rows=333,333 loops=3)

  • Hash Cond: (pgbench_accounts.bid = pgbench_branches.bid)
  • Buffers: shared hit=94 read=19136
6. 14,111.262 14,111.262 ↑ 1.4 333,333 3
→

Parallel Index Scan using pgbench_accounts_pkey on public.pgbench_accounts (cost=0.57..43,085.50 rows=459,926 width=97) (actual time=117.167..4,703.754 rows=333,333 loops=3)

  • Index Cond: (pgbench_accounts.aid < 1000000)
  • Buffers: shared read=19131
7. 0.618 60.603 ↑ 1.0 1,000 3
→

Hash (cost=15.00..15.00 rows=1,000 width=364) (actual time=20.200..20.201 rows=1,000 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 48kB
  • Buffers: shared hit=10 read=5
8. 59.985 59.985 ↑ 1.0 1,000 3
→

Seq Scan on public.pgbench_branches (cost=0.00..15.00 rows=1,000 width=364) (actual time=13.090..19.995 rows=1,000 loops=3)

  • Buffers: shared hit=10 read=5
9. 5.811 390.951 ↑ 1.0 10,000 3
→

Hash (cost=155.00..155.00 rows=10,000 width=352) (actual time=130.317..130.317 rows=10,000 loops=3)

  • Buckets: 16384 Batches: 1 Memory Usage: 558kB
  • Buffers: shared hit=110 read=55
10. 385.140 385.140 ↑ 1.0 10,000 3
→

Seq Scan on public.pgbench_tellers (cost=0.00..155.00 rows=10,000 width=352) (actual time=16.691..128.380 rows=10,000 loops=3)

  • Buffers: shared hit=110 read=55