explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8PnU : TEST1

Settings
# exclusive inclusive rows x rows loops node
1. 76.088 149.258 ↑ 1.0 2 1

Gather (cost=1,008.45..12,639.08 rows=2 width=13) (actual time=1.333..149.258 rows=2 loops=1)

  • Buffers: shared hit=6468
2. 44.404 73.170 ↑ 1.0 1 3

Hash Join (cost=8.45..11,638.88 rows=1 width=13) (actual time=31.439..73.17 rows=1 loops=3)

  • Buffers: shared hit=6468
3. 28.675 28.675 ↑ 1.3 333,333 3

Seq Scan on source source (cost=0..10,536.67 rows=416,667 width=17) (actual time=0.019..28.675 rows=333,333 loops=3)

  • Buffers: shared hit=6370
4. 0.013 0.091 ↑ 1.0 1 3

Hash (cost=8.44..8.44 rows=1 width=4) (actual time=0.091..0.091 rows=1 loops=3)

  • Buffers: shared hit=14
5. 0.078 0.078 ↑ 1.0 1 3

Index Scan using target_t_name_idx on target target (cost=0.42..8.44 rows=1 width=4) (actual time=0.077..0.078 rows=1 loops=3)

  • Index Cond: (target.t_name = 'target 42'::text)
  • Buffers: shared hit=14