explain.depesz.com

PostgreSQL's explain analyze made readable

Result: h86E

Settings
# exclusive inclusive rows x rows loops node
1. 18,399.293 70,726.554 ↓ 5.2 5,242,490 1

HashAggregate (cost=76,611.97..86,762.52 rows=1,015,055 width=32) (actual time=64,488.412..70,726.554 rows=5,242,490 loops=1)

  • Group Key: lista_blanca_recargaygana.movil
2. 13,373.332 52,327.261 ↓ 5.9 6,034,324 1

Append (cost=0.00..74,074.33 rows=1,015,055 width=32) (actual time=426.236..52,327.261 rows=6,034,324 loops=1)

  • -> Seq Scan on lista_blanca_recargaygana (cost=0.00..33071.93 rows=1 width=12) (actual time=426.231..921.971 rows=344805 l
  • Filter: (fecha >= '2018-12-05'::date)
  • Rows Removed by Filter: 1502412
3. 29,070.663 29,070.663 ↓ 19,157.8 3,831,562 1

HashAggregate (cost=12.50..14.50 rows=200 width=32) (actual time=23,921.404..29,070.663 rows=3,831,562 loops=1)

  • Group Key: sus.movil
  • -> Function Scan on dblink sus (cost=0.00..10.00 rows=1000 width=32) (actual time=13064.379..17116.039 rows=3831562
4. 5,003.591 5,003.591 ↓ 844.1 844,103 1

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

5. 4,879.675 4,879.675 ↑ 1.0 1,013,854 1

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

  • Group Key: base_nuevos_desactivados_recuperados.movil
  • -> Seq Scan on base_nuevos_desactivados_recuperados (cost=0.00..18154.18 rows=1013854 width=12) (actual time=16.403.
  • Filter: (fecha >= '2018-12-05'::date)