explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3CUI

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 11,280.296 ↑ 1.0 1 1

Limit (cost=1,001.17..4,305.86 rows=1 width=73) (actual time=11,278.039..11,280.296 rows=1 loops=1)

2. 12.114 11,280.293 ↑ 427.0 1 1

Gather Merge (cost=1,001.17..1,412,102.00 rows=427 width=73) (actual time=11,278.038..11,280.293 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 322.429 11,268.179 ↑ 1.1 155 3 / 3

Nested Loop Semi Join (cost=1.15..1,411,052.69 rows=178 width=73) (actual time=11,266.919..11,268.179 rows=155 loops=3)

4. 1,260.172 1,260.172 ↑ 1.3 1,076,175 3 / 3

Parallel Index Scan using "idx_scheduledprocessing$processrowsuperclass_rownumber_asc" on "scheduledprocessing$processrowsuperclass" (cost=0.43..322,860.72 rows=1,356,043 width=73) (actual time=0.078..1,260.172 rows=1,076,175 loops=3)

5. 1,075.710 9,685.578 ↓ 0.0 0 3,228,526 / 3

Nested Loop (cost=0.72..0.79 rows=1 width=16) (actual time=0.009..0.009 rows=0 loops=3,228,526)

  • Join Filter: ("x1ScheduledPro.ProcessRowSuper".id = "c1scheduledprocessing$processrow_processload"."scheduledprocessing$processrowsuperclassid")
6. 8,609.403 8,609.403 ↓ 0.0 0 3,228,526 / 3

Index Only Scan using hvt1 on "scheduledprocessing$processrowsuperclass" "x1ScheduledPro.ProcessRowSuper" (cost=0.29..0.31 rows=1 width=8) (actual time=0.008..0.008 rows=0 loops=3,228,526)

  • Index Cond: ((status = 'Ready'::text) AND (id = "scheduledprocessing$processrowsuperclass".id))
  • Heap Fetches: 0
7. 0.465 0.465 ↑ 1.0 1 465 / 3

Index Only Scan using "idx_scheduledprocessing$processrow_processload" on "scheduledprocessing$processrow_processload" "c1scheduledprocessing$processrow_processload" (cost=0.43..0.47 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=465)

  • Index Cond: (("scheduledprocessing$processloadid" = '107523441103471793'::bigint) AND ("scheduledprocessing$processrowsuperclassid" = "scheduledprocessing$processrowsuperclass".id))
  • Heap Fetches: 0
Planning time : 0.796 ms
Execution time : 11,280.406 ms