explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HlcPh

Settings
# exclusive inclusive rows x rows loops node
1. 0.261 27,744.097 ↑ 1.0 1 1

Aggregate (cost=433,245.54..433,245.55 rows=1 width=8) (actual time=27,744.097..27,744.097 rows=1 loops=1)

  • Buffers: shared hit=31,652
2. 27,743.836 27,743.836 ↑ 406.6 1,227 1

Seq Scan on wfm_timepair wfm_timepair (cost=0..431,998.39 rows=498,861 width=0) (actual time=20,624.069..27,743.836 rows=1,227 loops=1)

  • Filter: ((("current_user"())::text <> ANY ('{wfmadmin,skipvpd}'::text[])) AND vpd_sec_usr.f_sel_policy_all(wfm_timepair.vpd_key, 'WFM_TIMEPAIR'::character varying))
  • Buffers: shared hit=31,652
Planning time : 0.838 ms
Execution time : 27,744.139 ms