explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lfr

Settings
# exclusive inclusive rows x rows loops node
1. 17,444.866 69,479.836 ↓ 5.2 5,242,493 1

HashAggregate (cost=43,544.49..53,695.04 rows=1,015,055 width=32) (actual time=62,680.485..69,479.836 rows=5,242,493 loops=1)

  • Group Key: lista_blanca_recargaygana.movil
2. 11,520.782 52,034.970 ↓ 5.9 6,034,328 1

Append (cost=0.43..41,006.85 rows=1,015,055 width=32) (actual time=9.410..52,034.970 rows=6,034,328 loops=1)

3. 505.212 505.212 ↓ 344,805.0 344,805 1

Index Scan using idx_fecha_lista_blanca_recargaygana on lista_blanca_recargaygana (cost=0.43..4.45 rows=1 width=12) (actual time=9.409..505.212 rows=344,805 loops=1)

  • Index Cond: (fecha >= '2018-12-05'::date)
4. 10,962.468 30,400.431 ↓ 19,157.8 3,831,566 1

HashAggregate (cost=12.50..14.50 rows=200 width=32) (actual time=25,686.292..30,400.431 rows=3,831,566 loops=1)

  • Group Key: sus.movil
5. 19,437.963 19,437.963 ↓ 3,831.6 3,831,566 1

Function Scan on dblink sus (cost=0.00..10.00 rows=1,000 width=32) (actual time=15,103.915..19,437.963 rows=3,831,566 loops=1)

6. 4,739.617 4,739.617 ↓ 844.1 844,103 1

Function Scan on dblink t2 (cost=0.00..10.00 rows=1,000 width=32) (actual time=3,917.951..4,739.617 rows=844,103 loops=1)

7. 3,422.364 4,868.928 ↑ 1.0 1,013,854 1

HashAggregate (cost=20,688.81..30,827.35 rows=1,013,854 width=12) (actual time=3,216.364..4,868.928 rows=1,013,854 loops=1)

  • Group Key: base_nuevos_desactivados_recuperados.movil
8. 1,446.564 1,446.564 ↑ 1.0 1,013,854 1

Seq Scan on base_nuevos_desactivados_recuperados (cost=0.00..18,154.18 rows=1,013,854 width=12) (actual time=3.513..1,446.564 rows=1,013,854 loops=1)

  • Filter: (fecha >= '2018-12-05'::date)