explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kURA

Settings
# exclusive inclusive rows x rows loops node
1. 21.840 5,652.019 ↑ 2.7 56,644 1

Unique (cost=380,615.63..382,250.35 rows=150,259 width=114) (actual time=5,596.902..5,652.019 rows=56,644 loops=1)

2. 990.493 5,630.179 ↑ 1.9 170,240 1

Sort (cost=380,615.63..381,432.99 rows=326,943 width=114) (actual time=5,596.901..5,630.179 rows=170,240 loops=1)

  • Sort Key: contr_contrato, parc_nro_parcela
  • Sort Method: external merge Disk: 22,328kB
3. 4,639.686 4,639.686 ↑ 1.9 170,240 1

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

  • Filter: (parc_liquidada OR (parc_dt_liquidacao IS NOT NULL))
  • Rows Removed by Filter: 10,376,278
Planning time : 0.202 ms
Execution time : 5,658.147 ms