explain.depesz.com

PostgreSQL's explain analyze made readable

Result: suMhF : ANY

Settings
# exclusive inclusive rows x rows loops node
1. 1,017.042 8,281.234 ↓ 1.0 3,033,438 1

Finalize GroupAggregate (cost=547,163.94..898,856.66 rows=2,989,424 width=16) (actual time=6,079.888..8,281.234 rows=3,033,438 loops=1)

  • Group Key: smartq_jobs_log.id
2. 803.243 7,264.192 ↓ 1.2 3,033,438 1

Gather Merge (cost=547,163.94..856,506.49 rows=2,491,186 width=16) (actual time=6,079.878..7,264.192 rows=3,033,438 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 386.060 6,460.949 ↑ 1.2 1,011,146 3 / 3

Partial GroupAggregate (cost=546,163.91..567,961.79 rows=1,245,593 width=16) (actual time=5,990.964..6,460.949 rows=1,011,146 loops=3)

  • Group Key: smartq_jobs_log.id
4. 509.295 6,074.889 ↑ 1.2 1,011,146 3 / 3

Sort (cost=546,163.91..549,277.89 rows=1,245,593 width=16) (actual time=5,990.935..6,074.889 rows=1,011,146 loops=3)

  • Sort Key: smartq_jobs_log.id
  • Sort Method: quicksort Memory: 70,958kB
  • Worker 0: Sort Method: quicksort Memory: 71,640kB
  • Worker 1: Sort Method: quicksort Memory: 73,324kB
5. 2,446.207 5,565.594 ↑ 1.2 1,011,146 3 / 3

Parallel Hash Join (cost=217,576.74..420,057.58 rows=1,245,593 width=16) (actual time=2,042.788..5,565.594 rows=1,011,146 loops=3)

  • Hash Cond: (smartq_jobs_log.id = smartq_jobs_log_1.id)
6. 1,141.321 1,141.321 ↑ 1.2 3,033,717 3 / 3

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

7. 635.638 1,978.066 ↑ 1.2 1,011,146 3 / 3

Parallel Hash (cost=202,006.82..202,006.82 rows=1,245,593 width=8) (actual time=1,978.065..1,978.066 rows=1,011,146 loops=3)

  • Buckets: 4,194,304 Batches: 1 Memory Usage: 151,488kB
8. 1,342.428 1,342.428 ↑ 1.2 1,011,146 3 / 3

Parallel Seq Scan on smartq_jobs_log smartq_jobs_log_1 (cost=0.00..202,006.82 rows=1,245,593 width=8) (actual time=0.178..1,342.428 rows=1,011,146 loops=3)

  • Filter: (status > 8)
  • Rows Removed by Filter: 2,022,571