explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Qc0l

Settings
# exclusive inclusive rows x rows loops node
1. 0.291 1.133 ↑ 1.0 3 1

Hash Join (cost=26.93..56.92 rows=3 width=16) (actual time=1.130..1.133 rows=3 loops=1)

  • Hash Cond: (((ie.indicador)::text = (indicadores_economicos.indicador)::text) AND (ie.fecha = (max(indicadores_economicos.fecha))))
2. 0.197 0.197 ↑ 1.0 1,201 1

Seq Scan on indicadores_economicos ie (cost=0.00..20.55 rows=1,255 width=16) (actual time=0.005..0.197 rows=1,201 loops=1)

3. 0.002 0.645 ↑ 1.0 3 1

Hash (cost=26.89..26.89 rows=3 width=8) (actual time=0.645..0.645 rows=3 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 1kB
4. 0.430 0.643 ↑ 1.0 3 1

HashAggregate (cost=26.82..26.86 rows=3 width=8) (actual time=0.642..0.643 rows=3 loops=1)

5. 0.213 0.213 ↑ 1.0 1,201 1

Seq Scan on indicadores_economicos (cost=0.00..20.55 rows=1,255 width=8) (actual time=0.001..0.213 rows=1,201 loops=1)

Total runtime : 1.167 ms