explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KRr3

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 22,039.040 ↑ 200.0 1 1

Sort (cost=1,828,716.17..1,828,716.67 rows=200 width=64) (actual time=22,039.039..22,039.040 rows=1 loops=1)

  • Sort Key: (CASE WHEN (core_eleitor_min.renda_mensal_presumida > 3390::numeric) THEN 3390 ELSE CASE WHEN (core_eleitor_min.renda_mensal_presumida > 2034::numeric) THEN 2034 ELSE CASE WHEN (core_eleitor_min.renda_mensal_presumida > 1356::numeric) THEN 1356 ELSE (-1) END END END)
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=225 read=277,252
2. 858.471 22,039.030 ↑ 200.0 1 1

HashAggregate (cost=1,828,706.53..1,828,708.53 rows=200 width=64) (actual time=22,039.029..22,039.030 rows=1 loops=1)

  • Buffers: shared hit=225 read=277,252
3. 16,792.670 21,180.559 ↑ 19.0 79,883 1

HashAggregate (cost=1,270,995.15..1,491,044.54 rows=1,517,582 width=47) (actual time=20,954.936..21,180.559 rows=79,883 loops=1)

  • Buffers: shared hit=225 read=277,252
4. 4,387.889 4,387.889 ↑ 1.0 15,156,898 1

Seq Scan on core_eleitor_min (cost=0.00..588,083.38 rows=15,175,817 width=47) (actual time=0.008..4,387.889 rows=15,156,898 loops=1)

  • Filter: ((idade >= 4) AND (idade <= 100))
  • Rows Removed by Filter: 5,550,194
  • Buffers: shared hit=225 read=277,252
Total runtime : 22,045.263 ms