explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vuyS

Settings
# exclusive inclusive rows x rows loops node
1. 0.078 2.349 ↓ 0.0 0 1

Nested Loop (cost=39.7..302.36 rows=20 width=157) (actual time=2.349..2.349 rows=0 loops=1)

  • Buffers: shared hit=335
2. 0.056 2.163 ↓ 36.0 108 1

HashAggregate (cost=35.12..35.15 rows=3 width=8) (actual time=2.15..2.163 rows=108 loops=1)

  • Group Key: t.objectid
  • Buffers: shared hit=11
3. 2.107 2.107 ↓ 36.0 108 1

Index Scan using timecard5_idx on wfm_timecard t (cost=0.42..35.11 rows=3 width=8) (actual time=0.1..2.107 rows=108 loops=1)

  • Index Cond: ((t.payrollscheduleoid)::text = '1045173'::text)
  • Filter: ((("current_user"())::text <> ANY ('{wfmadmin,skipvpd}'::text[])) AND vpd_sec_usr.f_sel_policy_all(t.vpd_key, 'WFM_TIMECARD'::character varying))
  • Buffers: shared hit=11
4. 0.000 0.108 ↓ 0.0 0 108

Bitmap Heap Scan on wfm_payroll wfm_payroll (cost=4.58..89 rows=7 width=157) (actual time=0.001..0.001 rows=0 loops=108)

  • Filter: ((("current_user"())::text <> ANY ('{wfmadmin,skipvpd}'::text[])) AND vpd_sec_usr.f_sel_policy_all(wfm_payroll.vpd_key, 'WFM_PAYROLL'::character varying))
  • Buffers: shared hit=324
5. 0.108 0.108 ↓ 0.0 0 108

Bitmap Index Scan on payroll_idx5 (cost=0..4.58 rows=20 width=0) (actual time=0.001..0.001 rows=0 loops=108)

  • Index Cond: (wfm_payroll.timecardoid = t.objectid)
  • Buffers: shared hit=324
Planning time : 0.39 ms
Execution time : 2.389 ms