explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w872

Settings
# exclusive inclusive rows x rows loops node
1. 145.834 7,326,476.065 ↑ 3.6 279,599 1

Limit (cost=217,221,502.440..217,244,002.420 rows=999,999 width=65) (actual time=5,976,886.940..7,326,476.065 rows=279,599 loops=1)

2. 356,587.462 7,326,330.231 ↑ 2,199.4 279,599 1

GroupAggregate (cost=217,221,502.440..231,057,822.580 rows=614,947,562 width=65) (actual time=5,976,886.938..7,326,330.231 rows=279,599 loops=1)

  • Group Key: hotel_quebec.november_lima, romeo_three.hotel_romeo, yankee.hotel_romeo
3. 6,687,169.660 6,969,742.769 ↓ 1.0 644,543,253 1

Sort (cost=217,221,502.440..218,758,871.340 rows=614,947,562 width=82) (actual time=5,975,873.341..6,969,742.769 rows=644,543,253 loops=1)

  • Sort Key: hotel_quebec.november_lima, romeo_three.hotel_romeo, yankee.hotel_romeo
  • Sort Method: external merge Disk: 58093112kB
4. 234,496.540 282,573.109 ↓ 1.0 644,543,253 1

Hash Join (cost=630,447.560..9,746,983.240 rows=614,947,562 width=82) (actual time=31,549.829..282,573.109 rows=644,543,253 loops=1)

  • Hash Cond: ((yankee."romeo_romeo")::text = (romeo_three.uniform)::text)
5. 11,206.363 16,703.400 ↑ 1.0 3,572,223 1

Hash Join (cost=8,583.030..329,360.340 rows=3,587,011 width=91) (actual time=175.232..16,703.400 rows=3,572,223 loops=1)

  • Hash Cond: ((yankee."charlie")::text = (kilo_foxtrot.uniform)::text)
6. 5,322.158 5,322.158 ↑ 1.0 3,849,687 1

Seq Scan on hotel_oscar yankee (cost=0.000..156,642.870 rows=3,849,687 width=95) (actual time=0.005..5,322.158 rows=3,849,687 loops=1)

7. 55.228 174.879 ↓ 1.0 120,391 1

Hash (cost=6,055.340..6,055.340 rows=118,695 width=46) (actual time=174.879..174.879 rows=120,391 loops=1)

  • Buckets: 65536 Batches: 4 Memory Usage: 2833kB
8. 82.811 119.651 ↓ 1.0 120,391 1

Hash Join (cost=59.820..6,055.340 rows=118,695 width=46) (actual time=0.889..119.651 rows=120,391 loops=1)

  • Hash Cond: ((kilo_foxtrot."kilo_charlie")::text = (hotel_quebec.uniform)::text)
9. 35.968 35.968 ↑ 1.0 127,387 1

Seq Scan on five kilo_foxtrot (cost=0.000..4,330.870 rows=127,387 width=50) (actual time=0.004..35.968 rows=127,387 loops=1)

10. 0.335 0.872 ↑ 1.0 832 1

Hash (cost=49.410..49.410 rows=833 width=46) (actual time=0.872..0.872 rows=832 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 72kB
11. 0.537 0.537 ↑ 1.0 832 1

Seq Scan on golf hotel_quebec (cost=0.000..49.410 rows=833 width=46) (actual time=0.003..0.537 rows=832 loops=1)

  • Filter: (("papa")::text <> november_november ('romeo_lima'::text[]))
  • Rows Removed by Filter: 62
12. 820.098 31,373.169 ↑ 1.0 1,405,090 1

Hash (cost=591,950.900..591,950.900 rows=1,405,090 width=41) (actual time=31,373.169..31,373.169 rows=1,405,090 loops=1)

  • Buckets: 65536 Batches: 32 Memory Usage: 3622kB
13. 30,553.071 30,553.071 ↑ 1.0 1,405,090 1

Seq Scan on romeo_two romeo_three (cost=0.000..591,950.900 rows=1,405,090 width=41) (actual time=0.547..30,553.071 rows=1,405,090 loops=1)