explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6Snr

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 4.311 ↓ 0.0 0 1

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

  • One-Time Filter: ((length(concat('')) <= 0) AND (length(concat('')) <= 0) AND (length(concat('')) <= 0) AND (length(concat('')) <= 0))
2. 4.308 4.308 ↓ 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.308..4.308 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
Planning time : 0.589 ms
Execution time : 4.366 ms