explain.depesz.com

PostgreSQL's explain analyze made readable

Result: jLmT

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.300 ↓ 2.0 2 1

Limit (cost=64.51..64.52 rows=1 width=327) (actual time=0.291..0.300 rows=2 loops=1)

2. 0.025 0.290 ↓ 2.0 2 1

Sort (cost=64.51..64.52 rows=1 width=327) (actual time=0.286..0.290 rows=2 loops=1)

  • Sort Key: c.identifier
  • Sort Method: quicksort Memory: 26kB
3. 0.028 0.265 ↓ 2.0 2 1

Nested Loop (cost=3.80..64.50 rows=1 width=327) (actual time=0.202..0.265 rows=2 loops=1)

4. 0.043 0.043 ↑ 1.0 1 1

Index Scan using "PK_customers" on customers c (cost=0.42..8.44 rows=1 width=191) (actual time=0.040..0.043 rows=1 loops=1)

  • Index Cond: (idguid = 'd0115ff5-0eed-4ca7-9130-a580000980bc'::uuid)
5. 0.010 0.194 ↓ 2.0 2 1

Nested Loop (cost=3.38..56.05 rows=1 width=136) (actual time=0.154..0.194 rows=2 loops=1)

6. 0.005 0.156 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.96..55.13 rows=1 width=68) (actual time=0.133..0.156 rows=1 loops=1)

7. 0.006 0.147 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.53..46.69 rows=1 width=76) (actual time=0.127..0.147 rows=1 loops=1)

  • Join Filter: (cr_1.customerguid = c_3.idguid)
  • Rows Removed by Join Filter: 1
8. 0.004 0.133 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.11..38.24 rows=1 width=74) (actual time=0.116..0.133 rows=1 loops=1)

  • Join Filter: (cr_1.customerguid = c_1.idguid)
9. 0.022 0.120 ↑ 1.0 1 1

Nested Loop (cost=1.69..29.79 rows=1 width=42) (actual time=0.105..0.120 rows=1 loops=1)

10. 0.008 0.078 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.27..21.34 rows=1 width=50) (actual time=0.066..0.078 rows=1 loops=1)

  • Join Filter: (cr.customerguid = c_2.idguid)
11. 0.009 0.057 ↑ 1.0 1 1

Nested Loop (cost=0.84..12.89 rows=1 width=48) (actual time=0.047..0.057 rows=1 loops=1)

12. 0.021 0.021 ↑ 1.0 1 1

Index Only Scan using "PK_customers" on customers c_1 (cost=0.42..4.44 rows=1 width=16) (actual time=0.017..0.021 rows=1 loops=1)

  • Index Cond: (idguid = 'd0115ff5-0eed-4ca7-9130-a580000980bc'::uuid)
  • Heap Fetches: 0
13. 0.027 0.027 ↑ 1.0 1 1

Index Scan using idx_customerrelations_customerguid on customerrelations cr (cost=0.42..8.44 rows=1 width=32) (actual time=0.023..0.027 rows=1 loops=1)

  • Index Cond: (customerguid = 'd0115ff5-0eed-4ca7-9130-a580000980bc'::uuid)
  • Filter: (typecid = 149001)
14. 0.013 0.013 ↑ 1.0 1 1

Index Scan using "PK_customers" on customers c_2 (cost=0.42..8.44 rows=1 width=34) (actual time=0.012..0.013 rows=1 loops=1)

  • Index Cond: (idguid = 'd0115ff5-0eed-4ca7-9130-a580000980bc'::uuid)
15. 0.020 0.020 ↑ 1.0 1 1

Index Scan using "PK_customerships" on customerships cs (cost=0.42..8.44 rows=1 width=24) (actual time=0.019..0.020 rows=1 loops=1)

  • Index Cond: (idguid = cr.customershipguid)
16. 0.009 0.009 ↓ 0.0 0 1

Index Scan using idx_customerrelations_customerguid on customerrelations cr_1 (cost=0.42..8.44 rows=1 width=32) (actual time=0.007..0.009 rows=0 loops=1)

  • Index Cond: (customerguid = 'd0115ff5-0eed-4ca7-9130-a580000980bc'::uuid)
  • Filter: (typecid = 149004)
  • Rows Removed by Filter: 1
17. 0.008 0.008 ↑ 1.0 1 1

Index Scan using "PK_customers" on customers c_3 (cost=0.42..8.44 rows=1 width=34) (actual time=0.006..0.008 rows=1 loops=1)

  • Index Cond: (idguid = 'd0115ff5-0eed-4ca7-9130-a580000980bc'::uuid)
18. 0.004 0.004 ↓ 0.0 0 1

Index Scan using "PK_customerships" on customerships cs_1 (cost=0.42..8.44 rows=1 width=24) (actual time=0.002..0.004 rows=0 loops=1)

  • Index Cond: (idguid = cr_1.customershipguid)
19. 0.028 0.028 ↑ 1.5 2 1

Index Scan using idx_contractcustomers_customerkey on contractcustomers co (cost=0.42..0.89 rows=3 width=76) (actual time=0.017..0.028 rows=2 loops=1)

  • Index Cond: ((customerkey)::text = (cs.customerid)::text)
  • Filter: (customerrolecid = 168001)
Planning time : 5.287 ms
Execution time : 0.615 ms