explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KOKR

Settings
# exclusive inclusive rows x rows loops node
1. 1,838.607 21,365.308 ↑ 9.2 1,341,543 1

Finalize GroupAggregate (cost=2,708,396.56..4,269,845.68 rows=12,353,659 width=44) (actual time=14,863.406..21,365.308 rows=1,341,543 loops=1)

  • Group Key: br.id, rp2.sum
2. 955.846 19,526.701 ↑ 6.5 1,578,418 1

Gather Merge (cost=2,708,396.56..4,012,477.78 rows=10,294,716 width=44) (actual time=14,863.352..19,526.701 rows=1,578,418 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 2,011.436 18,570.855 ↑ 9.8 526,139 3 / 3

Partial GroupAggregate (cost=2,707,396.54..2,823,212.09 rows=5,147,358 width=44) (actual time=14,745.095..18,570.855 rows=526,139 loops=3)

  • Group Key: br.id, rp2.sum
4. 5,505.430 16,559.419 ↑ 1.3 4,061,818 3 / 3

Sort (cost=2,707,396.54..2,720,264.93 rows=5,147,358 width=44) (actual time=14,745.026..16,559.419 rows=4,061,818 loops=3)

  • Sort Key: br.id, rp2.sum
  • Sort Method: external merge Disk: 90,352kB
  • Worker 0: Sort Method: external merge Disk: 93,264kB
  • Worker 1: Sort Method: external merge Disk: 88,624kB
5. 3,697.399 11,053.989 ↑ 1.3 4,061,818 3 / 3

Parallel Hash Join (cost=87,016.79..1,816,897.49 rows=5,147,358 width=44) (actual time=9,160.002..11,053.989 rows=4,061,818 loops=3)

  • Hash Cond: (rp2.booked_room_id = br.id)
6. 6,913.690 6,913.690 ↑ 1.2 6,053,029 3 / 3

Parallel Seq Scan on req_package2 rp2 (cost=0.00..1,634,757.23 rows=7,566,223 width=12) (actual time=0.032..6,913.690 rows=6,053,029 loops=3)

7. 68.450 442.900 ↑ 1.3 139,829 3 / 3

Parallel Hash (cost=83,450.15..83,450.15 rows=175,571 width=40) (actual time=442.899..442.900 rows=139,829 loops=3)

  • Buckets: 131,072 Batches: 8 Memory Usage: 3,104kB
8. 374.450 374.450 ↑ 1.3 139,829 3 / 3

Parallel Seq Scan on booked_room br (cost=0.00..83,450.15 rows=175,571 width=40) (actual time=0.038..374.450 rows=139,829 loops=3)

  • Filter: (actual_arrival_time IS NOT NULL)
  • Rows Removed by Filter: 44,285
Planning time : 1.369 ms
Execution time : 21,765.475 ms