explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CT4D : IN

Settings
# exclusive inclusive rows x rows loops node
1. 1,955.345 12,520.092 ↓ 1.0 6,067,294 1

Finalize GroupAggregate (cost=704,465.56..1,414,953.77 rows=6,039,220 width=16) (actual time=8,079.483..12,520.092 rows=6,067,294 loops=1)

  • Group Key: smartq_jobs_log.id
2. 1,466.669 10,564.747 ↓ 1.2 6,067,294 1

Gather Merge (cost=704,465.56..1,329,398.15 rows=5,032,684 width=16) (actual time=8,079.311..10,564.747 rows=6,067,294 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 759.050 9,098.078 ↑ 1.2 2,022,431 3 / 3

Partial GroupAggregate (cost=703,465.54..747,501.52 rows=2,516,342 width=16) (actual time=8,036.645..9,098.078 rows=2,022,431 loops=3)

  • Group Key: smartq_jobs_log.id
4. 1,427.746 8,339.028 ↑ 1.2 2,022,431 3 / 3

Sort (cost=703,465.54..709,756.39 rows=2,516,342 width=16) (actual time=8,036.619..8,339.028 rows=2,022,431 loops=3)

  • Sort Key: smartq_jobs_log.id
  • Sort Method: external merge Disk: 51,384kB
  • Worker 0: Sort Method: external merge Disk: 51,080kB
  • Worker 1: Sort Method: external merge Disk: 51,776kB
5. 2,772.542 6,911.282 ↑ 1.2 2,022,431 3 / 3

Parallel Hash Join (cost=233,461.10..435,941.94 rows=2,516,342 width=16) (actual time=3,066.833..6,911.282 rows=2,022,431 loops=3)

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

7. 1,445.581 2,995.028 ↑ 1.2 2,022,431 3 / 3

Parallel Hash (cost=202,006.82..202,006.82 rows=2,516,342 width=8) (actual time=2,995.028..2,995.028 rows=2,022,431 loops=3)

  • Buckets: 8,388,608 Batches: 1 Memory Usage: 302,944kB
8. 1,549.447 1,549.447 ↑ 1.2 2,022,431 3 / 3

Parallel Seq Scan on smartq_jobs_log smartq_jobs_log_1 (cost=0.00..202,006.82 rows=2,516,342 width=8) (actual time=0.130..1,549.447 rows=2,022,431 loops=3)

  • Filter: (status > 2)
  • Rows Removed by Filter: 1,011,285