explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4VTd

Settings
# exclusive inclusive rows x rows loops node
1. 468.907 8,770.036 ↑ 1.1 167,041 1

GroupAggregate (cost=759,843.830..766,072.080 rows=177,909 width=108) (actual time=7,816.694..8,770.036 rows=167,041 loops=1)

  • Group Key: (xray(papa_five('kilo'::text, ""india""), 'alpha'::text)), two_juliet, zulu, oscar, papa_tango
2. 2,690.124 8,301.129 ↓ 2.6 464,982 1

Sort (cost=759,843.830..760,288.780 rows=177,981 width=92) (actual time=7,816.664..8,301.129 rows=464,982 loops=1)

  • Sort Key: (xray(papa_five('kilo'::text, ""india""), 'alpha'::text)), two_juliet, zulu, oscar, papa_tango
  • Sort Method: external merge Disk: 38440kB
3. 0.000 5,611.005 ↓ 2.6 464,982 1

Gather (cost=1,000.000..735,194.670 rows=177,981 width=92) (actual time=0.398..5,611.005 rows=464,982 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 5,650.213 5,650.213 ↓ 2.1 154,994 3

Parallel Seq Scan on hotel (cost=0.000..715,877.460 rows=74,159 width=92) (actual time=0.078..5,650.213 rows=154,994 loops=3)

  • Filter: ((two_juliet <> 'charlie'::text) AND (""india"" >= 'two_lima'::timestamp without time zone) AND (""india"" <= 'two_xray'::timestamp without time zone) AND (zulu <> november ('victor'::text[])))
  • Rows Removed by Filter: 655499