explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RGAU : Optimization for: plan #jG7T

Settings

Optimization path:

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.092 1,297.772 ↓ 0.0 0 1

Sort (cost=520,127.93..520,413.28 rows=114,140 width=56) (actual time=1,297.698..1,297.772 rows=0 loops=1)

  • Sort Key: hotel.foxtrot, hotel.mike DESC, hotel.lima DESC
  • Sort Method: quicksort Memory: 25kB
2.          

CTE hotel

3. 0.002 1,297.752 ↓ 0.0 0 1

Recursive Union (cost=113,115.89..508,257.11 rows=114,140 width=56) (actual time=1,297.679..1,297.752 rows=0 loops=1)

4. 0.003 1,297.746 ↓ 0.0 0 1

Sort (cost=113,115.89..113,398.44 rows=113,020 width=56) (actual time=1,297.674..1,297.746 rows=0 loops=1)

  • Sort Key: (five(echo.sierra)) DESC
  • Sort Method: quicksort Memory: 25kB
5. 350.810 1,297.743 ↓ 0.0 0 1

Finalize HashAggregate (cost=102,499.80..103,630.00 rows=113,020 width=56) (actual time=1,297.671..1,297.743 rows=0 loops=1)

  • Group Key: echo.sierra
  • Filter: (five(echo.sierra) > 1)
  • Rows Removed by Filter: 121,395
6. 189.894 946.933 ↓ 1.3 121,395 1

Gather (cost=91,904.10..101,793.42 rows=94,184 width=16) (actual time=741.372..946.933 rows=121,395 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
7. 96.805 757.039 ↑ 1.2 40,465 3 / 3

Partial HashAggregate (cost=90,904.10..91,375.02 rows=47,092 width=16) (actual time=740.323..757.039 rows=40,465 loops=3)

  • Group Key: echo.sierra
8. 660.234 660.234 ↑ 1.2 40,465 3 / 3

Parallel Seq Scan on echo (cost=0.00..90,668.64 rows=47,092 width=8) (actual time=457.899..660.234 rows=40,465 loops=3)

  • Filter: (victor_five >= 'golf'::timestamp without time zone)
  • Rows Removed by Filter: 1,879,372
9. 0.001 0.004 ↓ 0.0 0 1

Nested Loop (cost=0.43..39,257.59 rows=112 width=56) (actual time=0.003..0.004 rows=0 loops=1)

10. 0.003 0.003 ↓ 0.0 0 1

WorkTable Scan on (cost=0.00..25,429.50 rows=5,651 width=8) (actual time=0.003..0.003 rows=0 loops=1)

  • Filter: (mike = 'delta'::text)
11. 0.000 0.000 ↓ 0.0 0

Index Scan using papa on echo victor_romeo (cost=0.43..2.44 rows=1 width=16) (never executed)

  • Index Cond: (sierra = juliet1.foxtrot)
  • Filter: (victor_five >= 'golf'::timestamp without time zone)
12. 1,297.680 1,297.680 ↓ 0.0 0 1

CTE Scan on hotel (cost=0.00..2,282.80 rows=114,140 width=56) (actual time=1,297.680..1,297.680 rows=0 loops=1)

Planning time : 0.169 ms
Execution time : 1,299.996 ms