explain.depesz.com

PostgreSQL's explain analyze made readable

Result: leTZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.544 11,672.740 ↓ 0.0 0 1

Nested Loop (cost=35.55..164,977.67 rows=19 width=157) (actual time=11,672.74..11,672.74 rows=0 loops=1)

  • Buffers: shared hit=2,458,523
2. 0.266 2.472 ↓ 36.0 108 1

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

  • Group Key: t.objectid
  • Buffers: shared hit=11
3. 2.206 2.206 ↓ 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.099..2.206 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. 11,669.724 11,669.724 ↓ 0.0 0 108

Index Scan using payroll1_idx on wfm_payroll wfm_payroll (cost=0.43..54,980.78 rows=6 width=157) (actual time=108.053..108.053 rows=0 loops=108)

  • Index Cond: (wfm_payroll.timecardoid = t.objectid)
  • 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=2,458,512
Planning time : 0.292 ms
Execution time : 11,672.784 ms