explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FlXt

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

Sort (cost=71.96..71.97 rows=1 width=1,225) (actual rows= loops=)

  • Sort Key: "Account".updatedat DESC
2. 0.000 0.000 ↓ 0.0

Nested Loop Semi Join (cost=1.82..71.95 rows=1 width=1,225) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=1.12..26.24 rows=1 width=1,225) (actual rows= loops=)

  • Join Filter: ("Account__externAccounts".account = "Account".id)
4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.70..17.79 rows=1 width=651) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.42..9.48 rows=1 width=457) (actual rows= loops=)

  • Join Filter: ("Account__rol".id = "Account".rol)
6. 0.000 0.000 ↓ 0.0

Index Scan using "PK_54115ee388cdb6d86bb4bf5b2ea" on account "Account" (cost=0.42..8.44 rows=1 width=282) (actual rows= loops=)

  • Index Cond: (id = 1)
7. 0.000 0.000 ↓ 0.0

Seq Scan on rol "Account__rol" (cost=0.00..1.02 rows=2 width=175) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Scan using "PK_c725ae234ef1b74cce43d2d00c1" on organisation "Account__uitgever" (cost=0.28..8.29 rows=1 width=194) (actual rows= loops=)

  • Index Cond: (id = "Account".uitgever)
9. 0.000 0.000 ↓ 0.0

Index Scan using idx_extaccount_account on externaccount "Account__externAccounts" (cost=0.42..8.44 rows=1 width=574) (actual rows= loops=)

  • Index Cond: (account = 1)
10. 0.000 0.000 ↓ 0.0

Append (cost=0.70..45.70 rows=4 width=8) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.70..37.22 rows=3 width=8) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Index Scan using idx_tlinklicense_account on tlinklicense "TLinkLicense" (cost=0.42..12.28 rows=3 width=16) (actual rows= loops=)

  • Index Cond: (account = 1)
13. 0.000 0.000 ↓ 0.0

Index Scan using "PK_bebc9158e480b949565b4dc7a82" on product "Product" (cost=0.28..8.30 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (id = "TLinkLicense".product)
  • Filter: (organisation = 641)
14. 0.000 0.000 ↓ 0.0

Index Scan using idx_externeidentificatie_account on externeidentificatie (cost=0.42..8.44 rows=1 width=8) (actual rows= loops=)