explain.depesz.com

PostgreSQL's explain analyze made readable

Result: oq4T

Settings
# exclusive inclusive rows x rows loops node
1. 0.122 56.945 ↑ 166.7 3 1

Finalize GroupAggregate (cost=22,225.60..22,249.35 rows=500 width=28) (actual time=56.943..56.945 rows=3 loops=1)

  • Group Key: job_id
2. 0.000 56.823 ↑ 125.0 12 1

Sort (cost=22,225.60..22,229.35 rows=1,500 width=28) (actual time=56.822..56.823 rows=12 loops=1)

  • Sort Key: job_id
  • Sort Method: quicksort Memory: 25kB
3. 6.511 58.890 ↑ 125.0 12 1

Gather (cost=21,991.47..22,146.47 rows=1,500 width=28) (actual time=56.747..58.890 rows=12 loops=1)

  • Workers Planned: 3
  • Workers Launched: 3
4. 21.251 52.379 ↑ 166.7 3 4

Partial HashAggregate (cost=20,991.47..20,996.47 rows=500 width=28) (actual time=52.378..52.379 rows=3 loops=4)

  • Group Key: job_id
5. 31.128 31.128 ↑ 1.3 52,875 4

Parallel Seq Scan on waterfall_task (cost=0.00..19,968.16 rows=68,221 width=16) (actual time=0.029..31.128 rows=52,875 loops=4)

  • Filter: (job_id = ANY ('{108243,108244,108245}'::integer[]))
  • Rows Removed by Filter: 96160
Planning time : 0.193 ms
Execution time : 59.072 ms