explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kSc3 : Making changes to support

Settings
# exclusive inclusive rows x rows loops node
1. 576.041 1,917.764 ↓ 2.7 1,451,917 1

Hash Left Join (cost=59,438.440..638,141.060 rows=541,305 width=67) (actual time=209.711..1,917.764 rows=1,451,917 loops=1)

  • Hash Cond: (alpha.november_foxtrot = two_india.november_foxtrot)
2. 0.000 1,339.863 ↓ 1.1 157,789 1

Gather (cost=59,341.190..620,799.280 rows=150,241 width=43) (actual time=207.835..1,339.863 rows=157,789 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1,790.985 1,856.033 ↑ 1.2 52,596 3 / 3

Parallel Bitmap Heap Scan on sierra alpha (cost=58,341.190..604,775.180 rows=62,600 width=43) (actual time=205.353..1,856.033 rows=52,596 loops=3)

  • Recheck Cond: ((zulu >= hotel('echo_seven'::text, 'yankee'::text)) AND (zulu <= hotel('two_mike'::text, 'yankee'::text)))
  • Rows Removed by Index Recheck: 530890
  • Filter: ((echo_three = ANY ('golf'::numeric[])) AND ((five)::text = 'papa'::text) AND (mike = 'uniform'::bpchar) AND (tango = 'november_golf'::numeric))
  • Rows Removed by Filter: 774369
  • Heap Blocks: exact=9644 lossy=56053
4. 65.048 65.048 ↓ 1.0 2,480,897 1 / 3

Bitmap Index Scan on seven (cost=0.000..58,303.630 rows=2,429,519 width=0) (actual time=195.145..195.145 rows=2,480,897 loops=1)

  • Index Cond: ((zulu >= hotel('echo_seven'::text, 'yankee'::text)) AND (zulu <= hotel('two_mike'::text, 'yankee'::text)))
5. 0.982 1.860 ↑ 1.0 2,278 1

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

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

Seq Scan on delta two_india (cost=0.000..68.780 rows=2,278 width=5) (actual time=0.005..0.878 rows=2,278 loops=1)