explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7wZf

Settings
# exclusive inclusive rows x rows loops node
1. 16,515.521 68,746.160 ↓ 5.2 5,242,491 1

HashAggregate (cost=76,611.97..86,762.52 rows=1,015,055 width=32) (actual time=62,363.529..68,746.160 rows=5,242,491 loops=1)

  • Group Key: lista_blanca_recargaygana.movil
2. 11,031.712 52,230.639 ↓ 5.9 6,034,326 1

Append (cost=0.00..74,074.33 rows=1,015,055 width=32) (actual time=331.959..52,230.639 rows=6,034,326 loops=1)

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

Seq Scan on lista_blanca_recargaygana (cost=0.00..33,071.93 rows=1 width=12) (actual time=331.954..858.168 rows=344,805 loops=1)

  • Filter: (fecha >= '2018-12-05'::date)
  • Rows Removed by Filter: 1502412
4. 11,348.237 29,451.837 ↓ 19,157.8 3,831,564 1

HashAggregate (cost=12.50..14.50 rows=200 width=32) (actual time=25,215.251..29,451.837 rows=3,831,564 loops=1)

  • Group Key: sus.movil
5. 18,103.600 18,103.600 ↓ 3,831.6 3,831,564 1

Function Scan on dblink sus (cost=0.00..10.00 rows=1,000 width=32) (actual time=13,220.966..18,103.600 rows=3,831,564 loops=1)

6. 5,022.009 5,022.009 ↓ 844.1 844,103 1

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

7. 4,160.613 5,866.913 ↑ 1.0 1,013,854 1

HashAggregate (cost=20,688.81..30,827.35 rows=1,013,854 width=12) (actual time=3,899.718..5,866.913 rows=1,013,854 loops=1)

  • Group Key: base_nuevos_desactivados_recuperados.movil
8. 1,706.300 1,706.300 ↑ 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=4.392..1,706.300 rows=1,013,854 loops=1)

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