explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xxL2

Settings
# exclusive inclusive rows x rows loops node
1. 305.165 1,717.693 ↑ 1.0 1 1

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

2. 1,412.528 1,412.528 ↑ 1.3 2,526,487 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.222..1,412.528 rows=2,526,487 loops=1)

  • Heap Fetches: 397928
Total runtime : 1,717.803 ms