explain.depesz.com

PostgreSQL's explain analyze made readable

Result: r41B

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 843,946.269 ↑ 1.0 1 1

Limit (cost=20.99..20.99 rows=1 width=75) (actual time=843,946.265..843,946.269 rows=1 loops=1)

2. 13.405 843,946.264 ↑ 1.0 1 1

Sort (cost=20.99..20.99 rows=1 width=75) (actual time=843,946.264..843,946.264 rows=1 loops=1)

  • Sort Key: "scheduledprocessing$processrowsuperclass".rownumber, "scheduledprocessing$processrowsuperclass".id
  • Sort Method: top-N heapsort Memory: 25kB
3. 14.260 843,932.859 ↓ 27,186.0 27,186 1

Nested Loop (cost=12.95..20.98 rows=1 width=75) (actual time=843,798.435..843,932.859 rows=27,186 loops=1)

4. 114.765 843,809.855 ↓ 27,186.0 27,186 1

HashAggregate (cost=12.52..12.53 rows=1 width=16) (actual time=843,798.404..843,809.855 rows=27,186 loops=1)

  • Group Key: "x1ScheduledPro.ProcessRowSuper".id
5. 180,418.536 843,695.090 ↓ 27,186.0 27,186 1

Nested Loop (cost=0.86..12.52 rows=1 width=16) (actual time=38.996..843,695.090 rows=27,186 loops=1)

  • Join Filter: ("x1ScheduledPro.ProcessRowSuper".id = "c1scheduledprocessing$processrow_processload"."scheduledprocessing$processrowsuperclassid")
  • Rows Removed by Join Filter: 916745640
6. 104.063 104.063 ↓ 27,187.0 27,187 1

Index Only Scan using "idx_scheduledprocessing$processrowsuperclass_status_asc" on "scheduledprocessing$processrowsuperclass" "x1ScheduledPro.ProcessRowSuper" (cost=0.43..6.23 rows=1 width=8) (actual time=0.030..104.063 rows=27,187 loops=1)

  • Index Cond: (status = 'Ready'::text)
  • Heap Fetches: 29150
7. 663,172.491 663,172.491 ↓ 33,721.0 33,721 27,187

Index Only Scan using "idx_scheduledprocessing$processrow_processload" on "scheduledprocessing$processrow_processload" "c1scheduledprocessing$processrow_processload" (cost=0.43..6.27 rows=1 width=8) (actual time=0.024..24.393 rows=33,721 loops=27,187)

  • Index Cond: ("scheduledprocessing$processloadid" = '107523441103471793'::bigint)
  • Heap Fetches: 916772826
8. 108.744 108.744 ↑ 1.0 1 27,186

Index Scan using "scheduledprocessing$processrowsuperclass_pkey" on "scheduledprocessing$processrowsuperclass" (cost=0.43..8.45 rows=1 width=75) (actual time=0.004..0.004 rows=1 loops=27,186)

  • Index Cond: (id = "c1scheduledprocessing$processrow_processload"."scheduledprocessing$processrowsuperclassid")
Planning time : 1.295 ms
Execution time : 843,959.764 ms