explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9SmM

Settings
# exclusive inclusive rows x rows loops node
1. 175.820 778,952.928 ↑ 1.0 1 35,164

Limit (cost=3,872.59..3,872.60 rows=1 width=14) (actual time=22.150..22.152 rows=1 loops=35,164)

2. 949.428 778,777.108 ↑ 4.0 1 35,164

Sort (cost=3,872.59..3,872.60 rows=4 width=14) (actual time=22.147..22.147 rows=1 loops=35,164)

  • Sort Key: vix_ite_4.ite_dat_lan DESC
  • Sort Method: top-N heapsort Memory: 25kB
3. 777,827.680 777,827.680 ↓ 2.5 10 35,164

Seq Scan on vix_ite vix_ite_4 (cost=0.00..3,872.57 rows=4 width=14) (actual time=3.711..22.120 rows=10 loops=35,164)

  • Filter: ((ite_dat_lan <= '2019-01-31 23:59:59'::timestamp without time zone) AND (ite_6020_natureza = 2) AND (ite_pro_cod_pro = vix_pro.pro_cod_pro))