explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HZK5

Settings
# exclusive inclusive rows x rows loops node
1. 0.016 661.231 ↑ 20.9 23 1

Nested Loop (cost=5.36..13,327.18 rows=481 width=140) (actual time=103.182..661.231 rows=23 loops=1)

  • Buffers: shared hit=396
2. 660.686 660.686 ↓ 2.9 23 1

Seq Scan on wfm_notesxref notesxref1_ (cost=0..11,102.61 rows=8 width=51) (actual time=103.145..660.686 rows=23 loops=1)

  • Filter: (((notesxref1_.entityname)::text = ANY ('{TIMECARD,TIMEPAIR}'::text[])) AND (("current_user"())::text <> ANY ('{wfmadmin,skipvpd}'::text[])) AND vpd_sec_usr.f_sel_policy_all(notesxref1_.vpd_key, 'WFM_NOTESXREF'::character varying) 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[])))
  • Buffers: shared hit=350
3. 0.483 0.529 ↑ 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.023 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.274 ms
Execution time : 661.264 ms