explain.depesz.com

PostgreSQL's explain analyze made readable

Result: d9gf

Settings
# exclusive inclusive rows x rows loops node
1. 18.308 582.551 ↓ 0.0 0 1

Gather (cost=6,579.95..196,098.80 rows=50,751 width=1,027) (actual time=582.469..582.551 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.001 564.243 ↓ 0.0 0 3

Hash Left Join (cost=5,579.95..190,023.70 rows=21,146 width=1,027) (actual time=564.243..564.243 rows=0 loops=3)

  • Hash Cond: (n1.dososchedulebase = n2.id)
3. 0.001 564.242 ↓ 0.0 0 3

Hash Left Join (cost=647.16..185,035.41 rows=21,146 width=1,023) (actual time=564.242..564.242 rows=0 loops=3)

  • Hash Cond: (n0.dososmsschedule = n3.id)
4. 0.002 564.241 ↓ 0.0 0 3

Nested Loop (cost=0.43..184,138.29 rows=21,146 width=1,019) (actual time=564.240..564.241 rows=0 loops=3)

5. 564.239 564.239 ↓ 0.0 0 3

Parallel Seq Scan on dosomessagebase n1 (cost=0.00..81,895.33 rows=29,452 width=812) (actual time=564.239..564.239 rows=0 loops=3)

  • Filter: ((NOT issent) AND (NOT iscanceled) AND (expiredon IS NULL) AND COALESCE(force, false))
  • Rows Removed by Filter: 824805
6. 0.000 0.000 ↓ 0.0 0

Index Scan using "PK_DoSoSms" on dososms n0 (cost=0.43..3.47 rows=1 width=211) (never executed)

  • Index Cond: (id = n1.id)
7. 0.000 0.000 ↓ 0.0 0

Hash (cost=645.71..645.71 rows=82 width=8) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=3.79..645.71 rows=82 width=8) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Index Only Scan using "PK_DoSoSmsSchedule" on dososmsschedule n3 (cost=0.14..17.28 rows=82 width=4) (never executed)

  • Heap Fetches: 0
10. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on dososchedulebase n4 (cost=3.65..7.66 rows=1 width=8) (never executed)

  • Recheck Cond: (n3.id = id)
11. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on dososchedulebase_pkey (cost=0.00..3.65 rows=1 width=0) (never executed)

  • Index Cond: (n3.id = id)
12. 0.000 0.000 ↓ 0.0 0

Hash (cost=4,918.93..4,918.93 rows=1,109 width=8) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Index Scan using dososchedulebase_pkey on dososchedulebase n2 (cost=0.28..4,918.93 rows=1,109 width=8) (never executed)

Planning time : 1.286 ms
Execution time : 582.695 ms