explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IYp7

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.246 ↑ 1.0 1 1

Sort (cost=41.79..41.79 rows=1 width=131) (actual time=0.245..0.246 rows=1 loops=1)

  • Sort Key: chrempposi0_.modified_on DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=13
2. 0.003 0.240 ↑ 1.0 1 1

Nested Loop (cost=8.76..41.78 rows=1 width=131) (actual time=0.176..0.24 rows=1 loops=1)

  • Buffers: shared hit=13
3. 0.001 0.207 ↑ 1.0 1 1

Nested Loop (cost=8.76..37.79 rows=1 width=134) (actual time=0.169..0.207 rows=1 loops=1)

  • Buffers: shared hit=12
4. 0.004 0.189 ↑ 1.0 1 1

Nested Loop (cost=8.63..37.31 rows=1 width=116) (actual time=0.151..0.189 rows=1 loops=1)

  • Buffers: shared hit=10
5. 0.108 0.127 ↑ 1.0 1 1

Bitmap Heap Scan on chr_associate associatee1_ (cost=4.32..20.65 rows=1 width=46) (actual time=0.115..0.127 rows=1 loops=1)

  • Filter: ((("current_user"())::text <> ANY ('{wfmadmin,skipvpd}'::text[])) AND vpd_sec_usr.f_sel_policy_all_static(associatee1_.vpd_key))
  • Heap Blocks: exact=3
  • Buffers: shared hit=5
6. 0.019 0.019 ↑ 1.3 3 1

Bitmap Index Scan on chr_associate_idx7 (cost=0..4.32 rows=4 width=0) (actual time=0.018..0.019 rows=3 loops=1)

  • Index Cond: ((associatee1_.aoid)::text = 'G31NT1W5SD9M1A09'::text)
  • Buffers: shared hit=2
7. 0.047 0.058 ↑ 1.0 1 1

Bitmap Heap Scan on chr_emp_position chrempposi0_ (cost=4.31..16.66 rows=1 width=78) (actual time=0.032..0.058 rows=1 loops=1)

  • Filter: ((("current_user"())::text <> ANY ('{wfmadmin,skipvpd}'::text[])) AND vpd_sec_usr.f_sel_policy_all_static(chrempposi0_.vpd_key))
  • Heap Blocks: exact=3
  • Buffers: shared hit=5
8. 0.011 0.011 ↑ 1.0 3 1

Bitmap Index Scan on chr_emp_position_idx14 (cost=0..4.31 rows=3 width=0) (actual time=0.011..0.011 rows=3 loops=1)

  • Index Cond: ((chrempposi0_.userid)::text = (associatee1_.userid)::text)
  • Buffers: shared hit=2
9. 0.017 0.017 ↑ 1.0 1 1

Index Scan using location_pk on wfm_location location2_ (cost=0.13..0.46 rows=1 width=26) (actual time=0.016..0.017 rows=1 loops=1)

  • Index Cond: ((location2_.locationid)::text = (chrempposi0_.locationid)::text)
  • Filter: ((("current_user"())::text <> ANY ('{wfmadmin,skipvpd}'::text[])) AND vpd_sec_usr.f_sel_policy_ty_static(location2_.vpd_key))
  • Buffers: shared hit=2
10. 0.030 0.030 ↓ 2.8 11 1

Seq Scan on wfm_mstimezone mstimezone3_ (cost=0..3.94 rows=4 width=43) (actual time=0.006..0.03 rows=11 loops=1)

  • Filter: ((("current_user"())::text <> ANY ('{wfmadmin,skipvpd}'::text[])) AND vpd_sec_usr.f_sel_policy_ty_static(mstimezone3_.vpd_key))
  • Buffers: shared hit=1
Planning time : 0.888 ms
Execution time : 0.33 ms