explain.depesz.com

PostgreSQL's explain analyze made readable

Result: V1Q6

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.30..53.41 rows=4 width=36) (actual rows= loops=)

  • Hash Cond: (t1.id = t2.id)
2. 0.000 0.000 ↓ 0.0

Seq Scan on test t1 (cost=0.00..35.50 rows=2,550 width=4) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Hash (cost=8.29..8.29 rows=1 width=32) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Index Scan using ix_test2 on test2 t2 (cost=0.28..8.29 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ((sometext)::text = 'Matt'::text)