explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SHbs

Settings
# exclusive inclusive rows x rows loops node
1. 1.119 2.115 ↑ 1.0 1 1

Nested Loop Left Join (cost=11.39..593.87 rows=1 width=259) (actual time=2.098..2.115 rows=1 loops=1)

2. 0.591 0.591 ↑ 1.0 1 1

Nested Loop Left Join (cost=11.39..150.16 rows=1 width=248) (actual time=0.574..0.591 rows=1 loops=1)

3. 0.099 0.099 ↑ 1.0 1 1

Nested Loop Left Join (cost=11.14..134.90 rows=1 width=232) (actual time=0.082..0.099 rows=1 loops=1)

4. 0.065 0.065 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.43..29.62 rows=1 width=166) (actual time=0.061..0.065 rows=1 loops=1)

5. 0.059 0.059 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.14..21.30 rows=1 width=64) (actual time=0.056..0.059 rows=1 loops=1)

6. 0.032 0.032 ↑ 1.0 1 1

Index Scan using principal_key_type_key on principal u (cost=0.41..8.43 rows=1 width=64) (actual time=0.032..0.032 rows=1 loops=1)

7. 0.024 0.024 ↑ 1.0 1 1

Nested Loop (cost=4.72..12.86 rows=1 width=16) (actual time=0.022..0.024 rows=1 loops=1)

8. 0.008 0.008 ↑ 1.0 2 1

Bitmap Heap Scan on membership m (cost=4.43..12.14 rows=2 width=32) (actual time=0.008..0.008 rows=2 loops=1)

9. 0.005 0.005 ↑ 1.0 2 1

Bitmap Index Scan on membership_memberid_idx (cost=0.00..4.43 rows=2 width=0) (actual time=0.005..0.005 rows=2 loops=1)

10. 0.010 0.010 ↓ 0.0 0 2

Index Scan using principal_pkey on principal g (cost=0.29..0.35 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=2)

11. 0.004 0.004 ↑ 1.0 1 1

Index Scan using userprincipal_pkey on userprincipal up (cost=0.29..8.31 rows=1 width=118) (actual time=0.003..0.004 rows=1 loops=1)

12. 0.033 0.033 ↑ 9,028.0 1 1

Nested Loop Left Join (cost=5.72..15.00 rows=9,028 width=82) (actual time=0.021..0.033 rows=1 loops=1)

13. 0.017 0.017 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.01..13.26 rows=1 width=50) (actual time=0.011..0.017 rows=1 loops=1)

14. 0.010 0.010 ↑ 1.0 1 1

Nested Loop (cost=4.72..12.86 rows=1 width=48) (actual time=0.006..0.010 rows=1 loops=1)

15. 0.002 0.002 ↑ 1.0 2 1

Bitmap Heap Scan on membership m_1 (cost=4.43..12.14 rows=2 width=32) (actual time=0.002..0.002 rows=2 loops=1)

16. 0.002 0.002 ↑ 1.0 2 1

Bitmap Index Scan on membership_memberid_idx (cost=0.00..4.43 rows=2 width=0) (actual time=0.002..0.002 rows=2 loops=1)

17. 0.004 0.004 ↓ 0.0 0 2

Index Scan using principal_pkey on principal c (cost=0.29..0.35 rows=1 width=32) (actual time=0.002..0.002 rows=0 loops=2)

18. 0.004 0.004 ↑ 1.0 1 1

Index Scan using companyinfo_pkey on companyinfo ci (cost=0.29..0.39 rows=1 width=34) (actual time=0.003..0.004 rows=1 loops=1)

19. 0.015 0.015 ↑ 1.0 1 1

Nested Loop (cost=0.71..1.73 rows=1 width=48) (actual time=0.009..0.015 rows=1 loops=1)

20. 0.006 0.006 ↑ 1.0 2 1

Index Scan using membership_memberid_idx on membership mci (cost=0.42..1.01 rows=2 width=32) (actual time=0.004..0.006 rows=2 loops=1)

21. 0.006 0.006 ↓ 0.0 0 2

Index Scan using principal_pkey on principal i (cost=0.29..0.35 rows=1 width=48) (actual time=0.002..0.003 rows=0 loops=2)