explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dkPT : teste

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

GroupAggregate (cost=26,311.35..26,337.29 rows=200 width=32) (actual rows= loops=)

  • Filter: (count(*) = 1)
2.          

CTE extremos

3. 0.000 0.000 ↓ 0.0

Append (cost=0.00..26,067.36 rows=3,126 width=32) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on eixo_rodoviario t (cost=0.00..13,018.05 rows=1,563 width=411) (actual rows= loops=)

  • Filter: ((id_classe_do_objeto = ANY ('{1,5}'::integer[])) AND (geometrytype(geom) = ANY ('{MULTILINESTRING,LINESTRING}'::text[])))
5. 0.000 0.000 ↓ 0.0

Seq Scan on eixo_rodoviario t_1 (cost=0.00..13,018.05 rows=1,563 width=411) (actual rows= loops=)

  • Filter: ((id_classe_do_objeto = ANY ('{1,5}'::integer[])) AND (geometrytype(geom) = ANY ('{MULTILINESTRING,LINESTRING}'::text[])))
6. 0.000 0.000 ↓ 0.0

Sort (cost=243.99..251.80 rows=3,126 width=32) (actual rows= loops=)

  • Sort Key: extremos.geom
7. 0.000 0.000 ↓ 0.0

CTE Scan on extremos (cost=0.00..62.52 rows=3,126 width=32) (actual rows= loops=)