explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EHTb : Making changes to support

Settings
# exclusive inclusive rows x rows loops node
1. 11.885 89.364 ↓ 2.8 29,016 1

Hash Left Join (cost=1,215.550..141,763.110 rows=10,362 width=67) (actual time=8.979..89.364 rows=29,016 loops=1)

  • Hash Cond: (alpha.november_foxtrot = two.november_foxtrot)
2. 71.061 75.964 ↓ 1.1 3,176 1

Bitmap Heap Scan on sierra_oscar alpha (cost=1,118.300..141,335.750 rows=2,876 width=43) (actual time=7.440..75.964 rows=3,176 loops=1)

  • Recheck Cond: ((zulu >= hotel('echo_seven'::text, 'yankee'::text)) AND (zulu <= hotel('sierra_four'::text, 'yankee'::text)))
  • Filter: ((echo_three = ANY ('golf'::numeric[])) AND ((five)::text = 'papa'::text) AND (mike = 'uniform'::bpchar) AND (tango = 'november_golf'::numeric))
  • Rows Removed by Filter: 47836
  • Heap Blocks: exact=16515
3. 4.903 4.903 ↓ 1.1 51,012 1

Bitmap Index Scan on seven (cost=0.000..1,117.580 rows=46,514 width=0) (actual time=4.903..4.903 rows=51,012 loops=1)

  • Index Cond: ((zulu >= hotel('echo_seven'::text, 'yankee'::text)) AND (zulu <= hotel('sierra_four'::text, 'yankee'::text)))
4. 0.788 1.515 ↑ 1.0 2,278 1

Hash (cost=68.780..68.780 rows=2,278 width=5) (actual time=1.515..1.515 rows=2,278 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 117kB
5. 0.727 0.727 ↑ 1.0 2,278 1

Seq Scan on delta two (cost=0.000..68.780 rows=2,278 width=5) (actual time=0.004..0.727 rows=2,278 loops=1)