explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vdL1

Settings
# exclusive inclusive rows x rows loops node
1. 0.009 360.140 ↑ 1.0 1 1

Sort (cost=191,032.08..191,032.08 rows=1 width=32) (actual time=360.139..360.140 rows=1 loops=1)

  • Sort Key: t.created_on DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.000 360.131 ↑ 1.0 1 1

Nested Loop (cost=6,076.16..191,032.07 rows=1 width=32) (actual time=359.621..360.131 rows=1 loops=1)

  • Join Filter: (t.task_status_id = ts.id)
3. 41.162 397.454 ↑ 1.0 1 1

Gather (cost=6,076.16..191,030.24 rows=1 width=24) (actual time=359.609..397.454 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 307.277 356.292 ↓ 0.0 0 3

Parallel Bitmap Heap Scan on tasks t (cost=5,076.16..190,030.14 rows=1 width=24) (actual time=356.292..356.292 rows=0 loops=3)

  • Recheck Cond: (((completed_on >= CURRENT_DATE) AND (completed_on <= (CURRENT_DATE + '1 day'::interval))) OR (completed_on IS NULL))
  • Filter: (((created_on >= CURRENT_DATE) AND (created_on <= (CURRENT_DATE + '1 day'::interval))) OR ((completed_on >= CURRENT_DATE) AND (completed_on <= (CURRENT_DATE + '1 day'::interval))))
  • Rows Removed by Filter: 92167
  • Heap Blocks: exact=52783
5. 0.003 49.015 ↓ 0.0 0 1

BitmapOr (cost=5,076.16..5,076.16 rows=274,572 width=0) (actual time=49.015..49.015 rows=0 loops=1)

6. 0.026 0.026 ↓ 0.0 0 1

Bitmap Index Scan on idx_tasks_completed_on (cost=0.00..4.45 rows=1 width=0) (actual time=0.026..0.026 rows=0 loops=1)

  • Index Cond: ((completed_on >= CURRENT_DATE) AND (completed_on <= (CURRENT_DATE + '1 day'::interval)))
7. 48.986 48.986 ↓ 1.0 276,521 1

Bitmap Index Scan on idx_tasks_completed_on (cost=0.00..5,071.72 rows=274,572 width=0) (actual time=48.986..48.986 rows=276,521 loops=1)

  • Index Cond: (completed_on IS NULL)
8. 0.008 0.008 ↑ 37.0 1 1

Seq Scan on task_statuses ts (cost=0.00..1.37 rows=37 width=16) (actual time=0.007..0.008 rows=1 loops=1)