explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gC1i

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 399.129 ↑ 1.0 1 1

Nested Loop Left Join (cost=1,000.43..186,752.28 rows=1 width=55) (actual time=399.124..399.129 rows=1 loops=1)

  • Join Filter: (synchroniz0_.id = details1_.task_id)
  • Functions: 26
  • Options: Inlining false, Optimization false, Expressions true, Deforming true
  • Timing: Generation 3.098 ms, Inlining 0.000 ms, Optimization 1.259 ms, Emission 17.545 ms, Total 21.903 ms
2. 0.023 0.023 ↑ 1.0 1 1

Index Scan using sync_tasks_pkey on sync_tasks synchroniz0_ (cost=0.43..2.65 rows=1 width=20) (actual time=0.019..0.023 rows=1 loops=1)

  • Index Cond: (id = 1,674,632)
3. 55.127 427.581 ↓ 0.0 0 1

Gather (cost=1,000.00..186,748.75 rows=71 width=27) (actual time=399.080..427.581 rows=0 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
4. 372.454 372.454 ↓ 0.0 0 5 / 5

Parallel Seq Scan on sync_task_details details1_ (cost=0.00..185,741.65 rows=18 width=27) (actual time=372.454..372.454 rows=0 loops=5)

  • Filter: (task_id = 1,674,632)
  • Rows Removed by Filter: 3,645,612
Planning time : 0.073 ms
Execution time : 428.904 ms