explain.depesz.com

PostgreSQL's explain analyze made readable

Result: veCq

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

Append (cost=0.00..20.65 rows=1 width=86) (actual time=0.017..0.018 rows=1 loops=1)

2. 0.017 0.017 ↑ 1.0 1 1

Seq Scan on ten_year_staff_05_01 (cost=0.00..20.65 rows=1 width=86) (actual time=0.017..0.017 rows=1 loops=1)

  • Filter: ((hiredate = '2019-01-04 12:09:00'::timestamp without time zone) AND ((ename)::text = 'Shankar'::text))