explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8SA9 : INNER JOIN

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

Finalize GroupAggregate (cost=92,757.74..92,758.78 rows=8 width=24) (actual time=1,067.105..1,067.111 rows=8 loops=1)

  • Group Key: sjl.status
2. 45.336 1,093.699 ↓ 2.0 16 1

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

  • Workers Planned: 1
  • Workers Launched: 1
3. 0.047 1,048.363 ↑ 1.0 8 2 / 2

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

  • Sort Key: sjl.status
  • Sort Method: quicksort Memory: 25kB
  • Worker 0: Sort Method: quicksort Memory: 25kB
4. 15.653 1,048.316 ↑ 1.0 8 2 / 2

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

  • Group Key: sjl.status
5. 17.970 1,032.663 ↑ 1.3 37,026 2 / 2

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

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

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

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

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

  • Index Cond: (job_id = sj.id)