explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fsP7

Settings
# exclusive inclusive rows x rows loops node
1. 24.367 4,139.065 ↑ 2.7 56,644 1

Unique (cost=380,615.63..382,250.35 rows=150,259 width=114) (actual time=4,075.773..4,139.065 rows=56,644 loops=1)

2. 1,116.695 4,114.698 ↑ 1.9 170,240 1

Sort (cost=380,615.63..381,432.99 rows=326,943 width=114) (actual time=4,075.772..4,114.698 rows=170,240 loops=1)

  • Sort Key: contr_contrato
  • Sort Method: external merge Disk: 22328kB
3. 2,998.003 2,998.003 ↑ 1.9 170,240 1

Seq Scan on tb_parcela (cost=0.00..330,551.81 rows=326,943 width=114) (actual time=0.086..2,998.003 rows=170,240 loops=1)

  • Filter: (parc_liquidada OR (parc_dt_liquidacao IS NOT NULL))
  • Rows Removed by Filter: 10376278
Planning time : 0.344 ms
Execution time : 4,146.343 ms