explain.depesz.com

PostgreSQL's explain analyze made readable

Result: U4T5

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 529.186 ↑ 1.0 1 1

Limit (cost=23,607.42..23,607.53 rows=1 width=44) (actual time=527.718..529.186 rows=1 loops=1)

2. 6.517 529.184 ↑ 1,128,104.0 1 1

Gather Merge (cost=23,607.42..155,228.74 rows=1,128,104 width=44) (actual time=527.717..529.184 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 204.292 522.667 ↑ 564,052.0 1 3 / 3

Sort (cost=22,607.39..24,017.52 rows=564,052 width=44) (actual time=522.667..522.667 rows=1 loops=3)

  • Sort Key: last_update DESC
  • Sort Method: top-N heapsort Memory: 25kB
  • Worker 0: Sort Method: top-N heapsort Memory: 25kB
  • Worker 1: Sort Method: top-N heapsort Memory: 25kB
4. 318.375 318.375 ↑ 1.3 450,937 3 / 3

Parallel Seq Scan on bnbcalendar bc (cost=0.00..19,787.13 rows=564,052 width=44) (actual time=0.010..318.375 rows=450,937 loops=3)

  • Filter: (cdate >= CURRENT_DATE)" Rows Removed by Filter: 1,337