explain.depesz.com

PostgreSQL's explain analyze made readable

Result: uLdK

Settings
# exclusive inclusive rows x rows loops node
1. 2.185 549.674 ↓ 173.0 173 1

Nested Loop (cost=42,158.48..42,162.33 rows=1 width=241) (actual time=153.222..549.674 rows=173 loops=1)

  • Join Filter: (u.member_of && p.readers)
  • Rows Removed by Join Filter: 2
2.          

CTE curr_usr

3. 0.004 1.967 ↑ 1.0 1 1

Limit (cost=0.25..0.26 rows=1 width=96) (actual time=1.964..1.967 rows=1 loops=1)

4. 1.963 1.963 ↑ 1,000.0 1 1

Function Scan on bim_get_current_user_table (cost=0.25..10.25 rows=1,000 width=96) (actual time=1.962..1.963 rows=1 loops=1)

5.          

CTE curr_perm

6. 545.285 545.285 ↓ 1.5 175 1

Index Scan using perm_idx_owner_system_is_deleted on perm (cost=0.42..42,158.22 rows=118 width=489) (actual time=56.414..545.285 rows=175 loops=1)

  • Index Cond: ((owner_system IS NOT NULL) AND (is_deleted = false))
  • Filter: (NOT is_deleted)
7. 1.974 1.974 ↑ 1.0 1 1

CTE Scan on curr_usr u (cost=0.00..0.02 rows=1 width=32) (actual time=1.969..1.974 rows=1 loops=1)

8. 545.515 545.515 ↓ 1.5 175 1

CTE Scan on curr_perm p (cost=0.00..2.36 rows=118 width=241) (actual time=56.422..545.515 rows=175 loops=1)

Planning time : 0.216 ms