explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Db5x

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 1,754,798.689 ↑ 1.0 1 1

Limit (cost=20.99..21.00 rows=1 width=75) (actual time=1,754,798.686..1,754,798.689 rows=1 loops=1)

2. 34.120 1,754,798.685 ↑ 1.0 1 1

Sort (cost=20.99..21.00 rows=1 width=75) (actual time=1,754,798.685..1,754,798.685 rows=1 loops=1)

  • Sort Key: "scheduledprocessing$processrowsuperclass".rownumber, "scheduledprocessing$processrowsuperclass".id
  • Sort Method: top-N heapsort Memory: 25kB
3. 100.916 1,754,764.565 ↓ 47,169.0 47,169 1

Nested Loop (cost=12.95..20.98 rows=1 width=75) (actual time=1,754,348.658..1,754,764.565 rows=47,169 loops=1)

4. 358.731 1,754,380.635 ↓ 47,169.0 47,169 1

HashAggregate (cost=12.52..12.53 rows=1 width=16) (actual time=1,754,348.628..1,754,380.635 rows=47,169 loops=1)

  • Group Key: "x1ScheduledPro.ProcessRowSuper".id
5. 272,125.272 1,754,021.904 ↓ 47,169.0 47,169 1

Nested Loop (cost=0.86..12.52 rows=1 width=16) (actual time=10,762.140..1,754,021.904 rows=47,169 loops=1)

  • Join Filter: ("x1ScheduledPro.ProcessRowSuper".id = "c1scheduledprocessing$processrow_processload"."scheduledprocessing$processrowsuperclassid")
  • Rows Removed by Join Filter: 1119273345
6. 195.411 195.411 ↓ 47,313.0 47,313 1

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.041..195.411 rows=47,313 loops=1)

  • Index Cond: ("scheduledprocessing$processloadid" = '107523441103471793'::bigint)
  • Heap Fetches: 47313
7. 1,481,701.221 1,481,701.221 ↓ 23,658.0 23,658 47,313

Index Only Scan using "idx_scheduledprocessing$processrowsuperclass" on "scheduledprocessing$processrowsuperclass" "x1ScheduledPro.ProcessRowSuper" (cost=0.43..6.24 rows=1 width=8) (actual time=0.034..31.317 rows=23,658 loops=47,313)

  • Index Cond: (status = 'Ready'::text)
  • Heap Fetches: 1119320514
8. 283.014 283.014 ↑ 1.0 1 47,169

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

  • Index Cond: (id = "c1scheduledprocessing$processrow_processload"."scheduledprocessing$processrowsuperclassid")
Planning time : 1.360 ms
Execution time : 1,754,799.228 ms