explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ktI4

Settings
# exclusive inclusive rows x rows loops node
1. 304.394 1,561.298 ↑ 1.0 1 1

Aggregate (cost=128,972.40..128,972.41 rows=1 width=0) (actual time=1,561.297..1,561.298 rows=1 loops=1)

2. 1,256.904 1,256.904 ↑ 1.3 2,526,493 1

Index Only Scan using idx_resultado_classificacao_idt_imovel on resultado_classificacao rc (cost=0.00..120,696.81 rows=3,310,238 width=0) (actual time=0.065..1,256.904 rows=2,526,493 loops=1)

  • Heap Fetches: 384123
Total runtime : 1,561.381 ms