explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 398Z : IN

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 1,635.493 ↑ 1.0 8 1

Finalize GroupAggregate (cost=92,757.74..92,758.78 rows=8 width=16) (actual time=1,635.486..1,635.493 rows=8 loops=1)

  • Group Key: smartq_jobs_log.status
2. 43.551 1,658.943 ↓ 2.0 16 1

Gather Merge (cost=92,757.74..92,758.66 rows=8 width=16) (actual time=1,635.475..1,658.943 rows=16 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 0.050 1,615.392 ↑ 1.0 8 2 / 2

Sort (cost=91,757.73..91,757.75 rows=8 width=16) (actual time=1,615.390..1,615.392 rows=8 loops=2)

  • Sort Key: smartq_jobs_log.status
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
4. 22.451 1,615.342 ↑ 1.0 8 2 / 2

Partial HashAggregate (cost=91,757.53..91,757.61 rows=8 width=16) (actual time=1,615.340..1,615.342 rows=8 loops=2)

  • Group Key: smartq_jobs_log.status
5. 18.350 1,592.891 ↑ 1.3 37,026 2 / 2

Nested Loop (cost=0.86..91,510.36 rows=49,433 width=16) (actual time=2.231..1,592.891 rows=37,026 loops=2)

6. 37.962 37.962 ↑ 1.3 9,257 2 / 2

Parallel Index Only Scan using idx_sj_user_id_cur_status on smartq_jobs (cost=0.43..753.57 rows=12,358 width=8) (actual time=2.018..37.962 rows=9,257 loops=2)

  • Index Cond: (user_id = 108)
  • Heap Fetches: 0
7. 1,536.579 1,536.579 ↑ 1.0 4 18,513 / 2

Index Scan using idx_smartq_jobs_log_job_id on smartq_jobs_log (cost=0.43..7.30 rows=4 width=16) (actual time=0.070..0.166 rows=4 loops=18,513)

  • Index Cond: (job_id = smartq_jobs.id)