explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UXYoS

Settings
# exclusive inclusive rows x rows loops node
1. 0.056 2.075 ↑ 1.1 18 1

Nested Loop (cost=39.7..302.36 rows=20 width=157) (actual time=1.499..2.075 rows=18 loops=1)

  • Buffers: shared hit=231
2. 0.041 1.459 ↓ 23.3 70 1

HashAggregate (cost=35.12..35.15 rows=3 width=8) (actual time=1.448..1.459 rows=70 loops=1)

  • Group Key: t.objectid
  • Buffers: shared hit=11
3. 1.418 1.418 ↓ 23.3 70 1

Index Scan using timecard5_idx on wfm_timecard t (cost=0.42..35.11 rows=3 width=8) (actual time=0.104..1.418 rows=70 loops=1)

  • Index Cond: ((t.payrollscheduleoid)::text = '901463'::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.420 0.560 ↓ 0.0 0 70

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

  • Filter: ((("current_user"())::text <> ANY ('{wfmadmin,skipvpd}'::text[])) AND vpd_sec_usr.f_sel_policy_all(wfm_payroll.vpd_key, 'WFM_PAYROLL'::character varying))
  • Heap Blocks: exact=10
  • Buffers: shared hit=220
5. 0.140 0.140 ↓ 0.0 0 70

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

  • Index Cond: (wfm_payroll.timecardoid = t.objectid)
  • Buffers: shared hit=210
Planning time : 0.344 ms
Execution time : 2.115 ms