explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PrmJ

Settings
# exclusive inclusive rows x rows loops node
1. 6.128 6.128 ↑ 1.0 1 1

Seq Scan on ehrsys.pw_hr_asgn_t (cost=0.00..2,032.34 rows=1 width=3,694) (actual time=0.009..6.128 rows=1 loops=1)

  • Output: service_id, empid, asno, srvc_asno, mjob_type, company, empno, pers_type, poi_type, start_dt, end_dt, notes, start_action_id, end_action_id, attrct, attr01, attr02, attr03, attr04, attr05, attr06, attr07, attr08, attr09, attr10, attr11, attr12, attr13, attr14, attr15, add_person_id, add_dttm, upd_person_id, upd_dttm
  • Filter: ((pw_hr_asgn_t.empid)::text = '100'::text)
  • Rows Removed by Filter: 73866
  • Buffers: shared hit=1109
Planning time : 0.069 ms
Execution time : 6.148 ms