explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Pq2M

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 446.750 ↑ 1.0 1 1

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

2. 5.920 446.746 ↑ 1,128,104.0 1 1

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

  • Workers Planned: 2
  • Workers Launched: 2
3. 190.055 440.826 ↑ 564,052.0 1 3 / 3

Sort (cost=22,607.39..24,017.52 rows=564,052 width=44) (actual time=440.826..440.826 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. 250.771 250.771 ↑ 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.009..250.771 rows=450,937 loops=3)

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