explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BJDg

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

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

  • Filter: ((empid)::text = '100'::text)
  • Rows Removed by Filter: 73866
Planning time : 0.083 ms
Execution time : 80.325 ms