explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7xwc

Settings
# exclusive inclusive rows x rows loops node
1. 0.027 1.288 ↑ 20.9 23 1

Nested Loop (cost=5.78..2,457.74 rows=481 width=140) (actual time=0.231..1.288 rows=23 loops=1)

  • Buffers: shared hit=198
2. 0.755 0.755 ↓ 2.9 23 1

Index Scan using notesxref_idx8 on wfm_notesxref notesxref1_ (cost=0.41..233.17 rows=8 width=51) (actual time=0.196..0.755 rows=23 loops=1)

  • Index Cond: (((notesxref1_.entityname)::text = ANY ('{TIMECARD,TIMEPAIR}'::text[])) AND ((notesxref1_.entityoid)::text = ANY ('{8737961,4730486,10117246,5412082,7748092,9075746,8553645,11706266,8081043,7349965,14935444,3500747,6347602,5055674,8063448,7067373,7547671,9768563,6459450,3865330,11566772,6603291,6581075}'::text[])))
  • Filter: ((("current_user"())::text <> ANY ('{wfmadmin,skipvpd}'::text[])) AND vpd_sec_usr.f_sel_policy_all(notesxref1_.vpd_key, 'WFM_NOTESXREF'::character varying))
  • Buffers: shared hit=152
3. 0.460 0.506 ↑ 60.0 1 23

Bitmap Heap Scan on wfm_notes notes0_ (cost=5.36..277.47 rows=60 width=89) (actual time=0.022..0.022 rows=1 loops=23)

  • Filter: ((notes0_.isviewablebyemployee = 'T'::bpchar) AND (("current_user"())::text <> ANY ('{wfmadmin,skipvpd}'::text[])) AND vpd_sec_usr.f_sel_policy_all(notes0_.vpd_key, 'WFM_NOTES'::character varying))
  • Heap Blocks: exact=23
  • Buffers: shared hit=46
4. 0.046 0.046 ↑ 180.0 1 23

Bitmap Index Scan on wfm_notes_idx6 (cost=0..5.35 rows=180 width=0) (actual time=0.002..0.002 rows=1 loops=23)

  • Index Cond: (notes0_.noteoid = notesxref1_.noteoid)
  • Buffers: shared hit=23
Planning time : 0.345 ms
Execution time : 1.319 ms