explain.depesz.com

PostgreSQL's explain analyze made readable

Result: NuXG

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 1.791 ↑ 5.0 1 1

Sort (cost=1,124.7..1,124.72 rows=5 width=131) (actual time=1.791..1.791 rows=1 loops=1)

  • Sort Key: chrempposi0_.modified_on DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=135
2. 0.003 1.786 ↑ 5.0 1 1

Nested Loop (cost=8.82..1,124.64 rows=5 width=131) (actual time=0.77..1.786 rows=1 loops=1)

  • Buffers: shared hit=135
3. 0.002 1.744 ↑ 15.0 1 1

Nested Loop (cost=8.82..1,119.79 rows=15 width=134) (actual time=0.757..1.744 rows=1 loops=1)

  • Buffers: shared hit=134
4. 0.007 1.722 ↑ 41.0 1 1

Nested Loop (cost=8.69..1,100.46 rows=41 width=116) (actual time=0.735..1.722 rows=1 loops=1)

  • Buffers: shared hit=132
5. 1.636 1.658 ↑ 44.0 1 1

Bitmap Heap Scan on chr_associate associatee1_ (cost=5.29..407.03 rows=44 width=46) (actual time=0.697..1.658 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=125
  • Buffers: shared hit=127
6. 0.022 0.022 ↑ 1.0 132 1

Bitmap Index Scan on chr_associate_idx7 (cost=0..5.28 rows=132 width=0) (actual time=0.022..0.022 rows=132 loops=1)

  • Index Cond: ((associatee1_.aoid)::text = 'G4VPBP5A31K10002'::text)
  • Buffers: shared hit=2
7. 0.046 0.057 ↑ 1.0 1 1

Bitmap Heap Scan on chr_emp_position chrempposi0_ (cost=3.4..15.75 rows=1 width=78) (actual time=0.033..0.057 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..3.4 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.020 0.020 ↑ 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.02..0.02 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.008 0.039 ↓ 2.8 11 1

Materialize (cost=0..3.96 rows=4 width=43) (actual time=0.011..0.039 rows=11 loops=1)

  • Buffers: shared hit=1
11. 0.031 0.031 ↓ 2.8 11 1

Seq Scan on wfm_mstimezone mstimezone3_ (cost=0..3.94 rows=4 width=43) (actual time=0.006..0.031 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 : 1.905 ms
Execution time : 1.879 ms