explain.depesz.com

PostgreSQL's explain analyze made readable

Result: omMU

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

Aggregate (cost=91.64..91.65 rows=1 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Limit (cost=45.74..91.62 rows=1 width=32) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=45.74..7,766,822.94 rows=169,283 width=32) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=37.28..6,327,071.02 rows=169,283 width=319) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Seq Scan on "case" (cost=0.00..11,317.83 rows=169,283 width=287) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Aggregate (cost=37.28..37.29 rows=1 width=32) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=0.71..37.23 rows=3 width=36) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Only Scan using index_conciliation_users_on_conciliation_id_and_user_id on conciliation_users (cost=0.42..12.30 rows=3 width=4) (actual rows= loops=)

  • Index Cond: ((conciliation_id = "case".id) AND (user_id IS NOT NULL))
9. 0.000 0.000 ↓ 0.0

Index Scan using users_pkey on users (cost=0.28..8.31 rows=1 width=36) (actual rows= loops=)

  • Index Cond: (conciliation_users.user_id = id)
10.          

SubPlan (forIndex Scan)

11. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=32) (actual rows= loops=)

12.          

SubPlan (forAggregate)

13. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=32) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Aggregate (cost=8.46..8.47 rows=1 width=32) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Index Only Scan using index_conciliation_users_on_conciliation_id_and_user_id on conciliation_users conciliation_users_1 (cost=0.42..8.45 rows=1 width=4) (actual rows= loops=)

  • Index Cond: ((conciliation_id = "case".id) AND (user_id IS NULL))
16.          

SubPlan (forAggregate)

17. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=32) (actual rows= loops=)

18.          

SubPlan (forNested Loop Left Join)

19. 0.000 0.000 ↓ 0.0

Result (cost=0.00..0.01 rows=1 width=32) (actual rows= loops=)