explain.depesz.com

PostgreSQL's explain analyze made readable

Result: p6gJ : ROL voew

Settings
# exclusive inclusive rows x rows loops node
1. 12.907 2,806.492 ↓ 2.8 29,016 1

Hash Left Join (cost=1,097.250..1,132,017.260 rows=10,288 width=67) (actual time=23.055..2,806.492 rows=29,016 loops=1)

  • Hash Cond: (alpha.november_foxtrot = two.november_foxtrot)
2. 0.000 2,791.598 ↓ 1.2 3,176 1

Gather (cost=1,000.000..1,131,602.450 rows=2,726 width=43) (actual time=21.046..2,791.598 rows=3,176 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 2,800.529 2,800.529 ↑ 1.1 1,059 3 / 3

Parallel Seq Scan on romeo alpha (cost=0.000..1,130,329.850 rows=1,136 width=43) (actual time=12.760..2,800.529 rows=1,059 loops=3)

  • Filter: ((echo_three = ANY ('golf'::numeric[])) AND ((five)::text = 'papa'::text) AND (mike = 'uniform'::bpchar) AND (tango = 'november_golf'::numeric) AND (zulu >= hotel('echo_seven'::text, 'yankee'::text)) AND (zulu <= hotel('sierra'::text, 'yankee'::text)))
  • Rows Removed by Filter: 2442889
4. 1.057 1.987 ↑ 1.0 2,278 1

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

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

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

Planning time : 0.723 ms
Execution time : 2,813.651 ms