explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4n3k

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

Nested Loop Left Join (cost=1.28..1,378.07 rows=1 width=200) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.00..1,369.76 rows=1 width=196) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.71..1,361.46 rows=1 width=171) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.29..16.33 rows=1 width=122) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Index Scan using "IX_StorageSystems_ExternalId" on "StorageSystems" "cmd.StackerRobot.StorageSystem" (cost=0.14..8.16 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (("ExternalId")::text = 'ATS1'::text)
6. 0.000 0.000 ↓ 0.0

Index Scan using "IX_StackerRobots_StorageSystemId" on "StackerRobots" "cmd.StackerRobot" (cost=0.14..8.16 rows=1 width=126) (actual rows= loops=)

  • Index Cond: ("StorageSystemId" = "cmd.StackerRobot.StorageSystem"."Id")
7. 0.000 0.000 ↓ 0.0

Index Scan using "IX_StackerRobotCommands_StackerRobotId" on "StackerRobotCommands" cmd (cost=0.42..1,345.11 rows=1 width=57) (actual rows= loops=)

  • Index Cond: ("StackerRobotId" = "cmd.StackerRobot"."Id")
  • Filter: ((NOT "Invalid") AND ("FinishedOn" IS NULL) AND ("TransferId" IS NOT NULL))
8. 0.000 0.000 ↓ 0.0

Index Scan using "PK_Transfers" on "Transfers" "cmd.Transfer" (cost=0.29..8.31 rows=1 width=41) (actual rows= loops=)

  • Index Cond: (cmd."TransferId" = "Id")
9. 0.000 0.000 ↓ 0.0

Index Scan using "PK_StorageSystemLocations" on "StorageSystemLocations" "cmd.StorageSystemLocation" (cost=0.28..8.30 rows=1 width=12) (actual rows= loops=)

  • Index Cond: (cmd."StorageSystemLocationId" = "Id")