explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dTCx

Settings
# exclusive inclusive rows x rows loops node
1. 439.701 120,074.804 ↓ 1.1 100,000 1

Nested Loop (cost=0.84..18,537,493.32 rows=94,530 width=469) (actual time=266.533..120,074.804 rows=100,000 loops=1)

  • Buffers: shared hit=5774871
2. 0.021 0.021 ↑ 1.0 1 1

Index Scan using pgbench_branches_pkey on pgbench_branches b (cost=0.28..8.29 rows=1 width=364) (actual time=0.019..0.021 rows=1 loops=1)

  • Index Cond: (bid = 100)
  • Buffers: shared hit=3
3. 2,635.082 2,635.082 ↓ 1.1 100,000 1

Index Scan using iii2 on pgbench_accounts a (cost=0.57..2,009,387.18 rows=94,530 width=97) (actual time=265.028..2,635.082 rows=100,000 loops=1)

  • Index Cond: (bid = 100)
  • Buffers: shared hit=274868
4.          

SubPlan (for Nested Loop)

5. 500.000 117,000.000 ↑ 1.0 1 100,000

Aggregate (cost=174.83..174.84 rows=1 width=8) (actual time=1.17..1.17 rows=1 loops=100,000)

  • Buffers: shared hit=5500000
6. 116,500.000 116,500.000 ↑ 1.0 10 100,000

Seq Scan on pgbench_tellers t (cost=0..174.8 rows=10 width=0) (actual time=0.117..1.165 rows=10 loops=100,000)

  • Filter: (bid = a.bid)
  • Buffers: shared hit=5500000
Planning time : 0.978 ms
Execution time : 120,106.832 ms