explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9ibJ

Settings
# exclusive inclusive rows x rows loops node
1. 27.277 192.455 ↑ 1.0 10,000 1

Limit (cost=0.00..49,034.80 rows=10,000 width=152) (actual time=0.029..192.455 rows=10,000 loops=1)

2. 165.178 165.178 ↑ 3.3 10,000 1

Seq Scan on empleado (cost=0.00..161,912.91 rows=33,020 width=152) (actual time=0.028..165.178 rows=10,000 loops=1)

  • Filter: (((documento)::text <> '0'::text) AND ((upper((sexo)::text) = 'M'::text) OR (upper((sexo)::text) = 'F'::text)))
  • Rows Removed by Filter: 150