explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ryod : IN

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

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

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

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

  • Workers Planned: 2
  • Workers Launched: 2
3. 381.412 6,299.324 ↑ 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,837.648..6,299.324 rows=1,011,146 loops=3)

  • Group Key: smartq_jobs_log.id
4. 494.342 5,917.912 ↑ 1.2 1,011,146 3 / 3

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

  • Sort Key: smartq_jobs_log.id
  • Sort Method: quicksort Memory: 72,696kB
  • Worker 0: Sort Method: quicksort Memory: 71,594kB
  • Worker 1: Sort Method: quicksort Memory: 71,631kB
5. 2,356.848 5,423.570 ↑ 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=1,974.675..5,423.570 rows=1,011,146 loops=3)

  • Hash Cond: (smartq_jobs_log.id = smartq_jobs_log_1.id)
6. 1,127.527 1,127.527 ↑ 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.074..1,127.527 rows=3,033,717 loops=3)

7. 621.912 1,939.195 ↑ 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,939.194..1,939.195 rows=1,011,146 loops=3)

  • Buckets: 4,194,304 Batches: 1 Memory Usage: 151,520kB
8. 1,317.283 1,317.283 ↑ 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.248..1,317.283 rows=1,011,146 loops=3)

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