explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8y7m

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 4.288 ↓ 0.0 0 1

Result (cost=0.56..4,307.30 rows=1 width=160) (actual time=4.288..4.288 rows=0 loops=1)

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

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

  • 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))))
  • Rows Removed by Filter: 5758