explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tPQA : NOT IN

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

Finalize GroupAggregate (cost=213,380.00..213,382.03 rows=8 width=16) (actual time=2,524.991..2,525.000 rows=8 loops=1)

  • Group Key: smartq_jobs_log.status
2. 78.547 2,544.011 ↓ 1.5 24 1

Gather Merge (cost=213,380.00..213,381.87 rows=16 width=16) (actual time=2,524.980..2,544.011 rows=24 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.040 2,465.464 ↑ 1.0 8 3 / 3

Sort (cost=212,379.98..212,380.00 rows=8 width=16) (actual time=2,465.463..2,465.464 rows=8 loops=3)

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

Partial HashAggregate (cost=212,379.78..212,379.86 rows=8 width=16) (actual time=2,465.422..2,465.424 rows=8 loops=3)

  • Group Key: smartq_jobs_log.status
5. 1,726.554 1,731.190 ↓ 1.6 3,009,033 3 / 3

Parallel Seq Scan on smartq_jobs_log (cost=892.59..202,899.41 rows=1,896,073 width=16) (actual time=11.185..1,731.190 rows=3,009,033 loops=3)

  • Filter: (NOT (hashed SubPlan 1))
  • Rows Removed by Filter: 24,684
6.          

SubPlan (for Parallel Seq Scan)

7. 4.636 4.636 ↑ 1.1 18,513 3 / 3

Index Only Scan using idx_sj_user_id_cur_status on smartq_jobs (cost=0.43..840.07 rows=21,008 width=8) (actual time=0.198..4.636 rows=18,513 loops=3)

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