explain.depesz.com

PostgreSQL's explain analyze made readable

Result: doxFa

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

Limit (cost=28,243.36..28,243.37 rows=1 width=24) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Sort (cost=28,243.36..28,243.37 rows=1 width=24) (actual rows= loops=)

  • Sort Key: kilo_hotel1.zulu
3. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.47..28,243.35 rows=1 width=24) (actual rows= loops=)

  • Hash Cond: (juliet('echo', kilo_hotel1.quebec) = (kilo_foxtrot0.charlie)::text)
4. 0.000 0.000 ↓ 0.0

Seq Scan on lima_november yankee (cost=0.00..26,484.58 rows=350,058 width=24) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Hash (cost=8.46..8.46 rows=1 width=42) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Index Scan using lima_kilo on papa six (cost=0.42..8.46 rows=1 width=42) (actual rows= loops=)

  • Index Cond: ((four)::text = 'seven_alpha'::text)
  • Filter: (((uniform)::text = 'lima_foxtrot'::text) AND ('seven_two'::text = ANY ((five)::text[])))