explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ue2d

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=10,877.97..10,880.99 rows=2 width=18) (actual rows= loops=)

  • Group Key: t.job_state
2. 0.000 0.000 ↓ 0.0

Sort (cost=10,877.97..10,878.97 rows=401 width=10) (actual rows= loops=)

  • Sort Key: t.job_state
3. 0.000 0.000 ↓ 0.0

Subquery Scan on t (cost=8,255.79..10,860.63 rows=401 width=10) (actual rows= loops=)

  • Filter: (t.r = 1)
4. 0.000 0.000 ↓ 0.0

WindowAgg (cost=8,255.79..9,858.77 rows=80,149 width=34) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Sort (cost=8,255.79..8,456.16 rows=80,149 width=26) (actual rows= loops=)

  • Sort Key: j.job_id, j.exec_time DESC
6. 0.000 0.000 ↓ 0.0

Seq Scan on batch_rt_job_status_1864 j (cost=0.00..1,727.49 rows=80,149 width=26) (actual rows= loops=)