explain.depesz.com

PostgreSQL's explain analyze made readable

Result: B64O : Making a NOT IN query faster: SQL 1: (SO: http://stackoverflow.com/q/29555116/1082673)2

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

Aggregate (cost=40,409.150..40,409.160 rows=1 width=13) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Anti Join (cost=33,884.470..40,409.150 rows=1 width=13) (actual rows= loops=)

  • Hash Cond: ((alpha1.four)::text = (alpha2.four)::text)
3. 0.000 0.000 ↓ 0.0

Index Scan using bravo on bravo hotel (cost=0.420..1,626.370 rows=31,047 width=13) (actual rows= loops=)

  • Index Cond: ((seven >= 'papa'::timestamp without time zone) AND (seven <= 'tango'::timestamp without time zone))
4. 0.000 0.000 ↓ 0.0

Hash (cost=22,778.290..22,778.290 rows=638,861 width=13) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on bravo sierra (cost=0.000..22,778.290 rows=638,861 width=13) (actual rows= loops=)

  • Filter: (seven < 'papa'::timestamp without time zone)