explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UkpQ

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 56,852.230 ↑ 1.0 25 1

Limit (cost=185,241.89..185,241.96 rows=25 width=240) (actual time=56,852.226..56,852.230 rows=25 loops=1)

2. 23.986 56,852.228 ↑ 7,634.2 25 1

Sort (cost=185,241.89..185,719.03 rows=190,856 width=240) (actual time=56,852.226..56,852.228 rows=25 loops=1)

  • Sort Key: qsla.pxsavedatetime DESC
  • Sort Method: top-N heapsort Memory: 28kB
3. 23.476 56,828.242 ↑ 2.1 92,409 1

Unique (cost=177,470.37..179,856.07 rows=190,856 width=240) (actual time=56,798.770..56,828.242 rows=92,409 loops=1)

4. 3,618.008 56,804.766 ↑ 2.1 92,409 1

Sort (cost=177,470.37..177,947.51 rows=190,856 width=240) (actual time=56,798.769..56,804.766 rows=92,409 loops=1)

  • Sort Key: wb.pzinskey, wb.pxrefqueuekey, wb.pxrefobjectkey, qsla.pxsavedatetime
  • Sort Method: quicksort Memory: 15343kB
5. 24.853 53,186.758 ↑ 2.1 92,409 1

Append (cost=281.93..151,196.22 rows=190,856 width=240) (actual time=169.187..53,186.758 rows=92,409 loops=1)

6. 71.058 687.916 ↓ 1.5 74 1

Hash Join (cost=281.93..68,892.24 rows=49 width=165) (actual time=169.187..687.916 rows=74 loops=1)

  • Hash Cond: ((wb.pxrefqueuekey)::text = (qsla.pyitemid)::text)
7. 616.574 616.574 ↓ 1.0 420,305 1

Seq Scan on pc_assign_workbasket wb (cost=0.00..67,058.05 rows=413,805 width=157) (actual time=0.004..616.574 rows=420,305 loops=1)

8. 0.046 0.284 ↑ 9.3 93 1

Hash (cost=271.10..271.10 rows=866 width=83) (actual time=0.284..0.284 rows=93 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
9. 0.238 0.238 ↑ 9.3 93 1

Index Scan using pr_sys_queue_sla_index1 on pr_sys_queue_sla qsla (cost=0.54..271.10 rows=866 width=83) (actual time=0.054..0.238 rows=93 loops=1)

  • Index Cond: ((pyitemstatus)::text = 'Broken-Process'::text)
10. 52,473.989 52,473.989 ↑ 2.1 92,335 1

Index Scan using pr_sys_queues_index2 on pr_sys_queues (cost=0.67..80,395.43 rows=190,807 width=240) (actual time=0.469..52,473.989 rows=92,335 loops=1)

  • Index Cond: ((pyitemstatus)::text = 'Broken-Process'::text)
Planning time : 0.439 ms
Execution time : 56,852.892 ms