explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tU2L

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

Nested Loop Left Join (cost=6.00..31.01 rows=1 width=212) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5.71..30.28 rows=1 width=211) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5.42..29.61 rows=1 width=195) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=5.14..21.30 rows=1 width=112) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

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

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=4.72..12.86 rows=1 width=64) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on membership mci (cost=4.43..12.14 rows=2 width=32) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

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

9. 0.000 0.000 ↓ 0.0

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

10. 0.000 0.000 ↓ 0.0

Index Scan using companyinfo_pkey on companyinfo ci (cost=0.29..8.30 rows=1 width=99) (actual rows= loops=)

11. 0.000 0.000 ↓ 0.0

Index Only Scan using principal_pkey on principal sr (cost=0.29..0.66 rows=1 width=16) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

Index Scan using userprincipal_pkey on userprincipal up (cost=0.29..0.72 rows=1 width=33) (actual rows= loops=)