explain.depesz.com

PostgreSQL's explain analyze made readable

Result: egDE

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Result (cost=0.56..4,461.60 rows=1 width=160) (actual rows= loops=)

  • One-Time Filter: ((length(concat('')) <= 0) AND (length(concat('')) <= 0) AND (length(concat('')) <= 0) AND (length(concat('')) <= 0))
2. 0.000 0.000 ↓ 0.0

Index Scan using tb_geometria_nm_geometria_key on tb_geometria g (cost=0.56..4,461.60 rows=1 width=160) (actual rows= loops=)

  • Index Cond: ((id_camada)::integer = 1122)
  • Filter: ((geom && '0103000020E61000000100000005000000A182F5978E8B41C06D04F8C0B73F20C0A182F5978E8B41C0C0273DEA581E20C0B387F567218341C0C0273DEA581E20C0B387F567218341C06D04F8C0B73F20C0A182F5978E8B41C06D04F8C0B73F20C0'::geometry) AND ((((valor1)::text = 'mecanizada'::text) AND (length(concat('mecanizada')) > 0)) OR ((length(concat('mecanizada')) <= 0) AND (length(concat('')) <= 0) AND (length(concat('')) <= 0) AND (length(concat('')) <= 0))) AND ((((valor2)::text = 'noturno / diaria'::text) AND (length(concat('noturno / diaria')) > 0)) OR ((length(concat('noturno / diaria')) <= 0) AND (length(concat('')) <= 0) AND (length(concat('')) <= 0) AND (length(concat('')) <= 0))))