explain.depesz.com

PostgreSQL's explain analyze made readable

Result: C238

Settings
# exclusive inclusive rows x rows loops node
1. 73.186 16,579.784 ↓ 68.3 403,193 1

Nested Loop (cost=3,354.44..21,734.51 rows=5,906 width=490) (actual time=2,311.081..16,579.784 rows=403,193 loops=1)

2.          

CTE curr_usr

3. 0.004 2.114 ↑ 1.0 1 1

Limit (cost=0.25..0.26 rows=1 width=96) (actual time=2.112..2.114 rows=1 loops=1)

4. 2.110 2.110 ↑ 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=2.110..2.110 rows=1 loops=1)

5. 2.119 2.119 ↑ 1.0 1 1

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

6. 14,234.068 16,504.479 ↓ 68.3 403,193 1

Bitmap Heap Scan on perm p (cost=3,354.18..21,675.17 rows=5,906 width=490) (actual time=2,308.955..16,504.479 rows=403,193 loops=1)

  • Recheck Cond: (u.member_of && readers)
  • Rows Removed by Index Recheck: 182949
  • Heap Blocks: exact=80607
7. 2,270.411 2,270.411 ↓ 208.7 1,232,848 1

Bitmap Index Scan on perm_idx_readers (cost=0.00..3,352.70 rows=5,906 width=0) (actual time=2,270.411..2,270.411 rows=1,232,848 loops=1)

  • Index Cond: (u.member_of && readers)
Planning time : 0.270 ms