explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jgii : LEFT JOIN and IS NULL

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

Finalize GroupAggregate (cost=260,755.73..260,757.76 rows=8 width=24) (actual time=2,549.773..2,549.780 rows=8 loops=1)

  • Group Key: sjl.status
2. 43.978 2,567.496 ↓ 1.5 24 1

Gather Merge (cost=260,755.73..260,757.60 rows=16 width=16) (actual time=2,549.765..2,567.496 rows=24 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.048 2,523.518 ↑ 1.0 8 3 / 3

Sort (cost=259,755.71..259,755.73 rows=8 width=16) (actual time=2,523.517..2,523.518 rows=8 loops=3)

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

Partial HashAggregate (cost=259,755.51..259,755.59 rows=8 width=16) (actual time=2,523.467..2,523.470 rows=8 loops=3)

  • Group Key: sjl.status
5. 1,037.616 1,942.301 ↑ 1.2 3,009,033 3 / 3

Parallel Hash Anti Join (cost=908.04..240,980.57 rows=3,754,988 width=16) (actual time=5.071..1,942.301 rows=3,009,033 loops=3)

  • Hash Cond: (sjl.job_id = sj.id)
6. 900.187 900.187 ↑ 1.2 3,033,717 3 / 3

Parallel Seq Scan on smartq_jobs_log sjl (cost=0.00..192,526.46 rows=3,792,146 width=16) (actual time=0.085..900.187 rows=3,033,717 loops=3)

7. 2.412 4.498 ↑ 2.0 6,171 3 / 3

Parallel Hash (cost=753.57..753.57 rows=12,358 width=8) (actual time=4.497..4.498 rows=6,171 loops=3)

  • Buckets: 32,768 Batches: 1 Memory Usage: 992kB
8. 2.086 2.086 ↓ 1.5 18,513 1 / 3

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.131..6.258 rows=18,513 loops=1)

  • Index Cond: (user_id = 108)
  • Heap Fetches: 0