explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YDsG

Settings
# exclusive inclusive rows x rows loops node
1. 21.620 10,653.100 ↑ 2.7 56,644 1

Unique (cost=380,615.63..382,250.35 rows=150,259 width=114) (actual time=10,597.597..10,653.100 rows=56,644 loops=1)

2. 1,041.568 10,631.480 ↑ 1.9 170,240 1

Sort (cost=380,615.63..381,432.99 rows=326,943 width=114) (actual time=10,597.595..10,631.480 rows=170,240 loops=1)

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

Seq Scan on tb_parcela (cost=0.00..330,551.81 rows=326,943 width=114) (actual time=2.997..9,589.912 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.332 ms
Execution time : 10,658.880 ms