explain.depesz.com

PostgreSQL's explain analyze made readable

Result: G9FY

Settings
# exclusive inclusive rows x rows loops node
1. 9,464.454 9,464.454 ↓ 2.0 6 1

Seq Scan on empleado (cost=0.00..169,874.44 rows=3 width=152) (actual time=1,623.638..9,464.454 rows=6 loops=1)

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