explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dVOk

Settings
# exclusive inclusive rows x rows loops node
1. 9.278 107,642.045 ↓ 1,909.0 1,909 1

HashAggregate (cost=1,882.73..1,883.01 rows=1 width=39) (actual time=107,641.054..107,642.045 rows=1,909 loops=1)

  • Group Key: cm.id_meter, pci.code_integrator_meter_type, pci.min_reading_value, pci.max_reading_value, pci.previous_reading_value, (cvpc.kmaxima)::numeric(7,3), 'load_process_itine'::text, now(), f_pci_get_integrator_meter_sort((pci.code_integrator_meter_type)::integer), (trunc(ped.contracted_power, 0))::bigint
2. 151.292 107,632.767 ↓ 1,909.0 1,909 1

Nested Loop (cost=15.30..1,882.71 rows=1 width=39) (actual time=402.230..107,632.767 rows=1,909 loops=1)

3. 8.732 107,450.931 ↓ 1,909.0 1,909 1

Nested Loop (cost=14.87..1,873.98 rows=1 width=41) (actual time=402.073..107,450.931 rows=1,909 loops=1)

  • Join Filter: ((cvpc.code_meter)::text = (cm.code_meter)::text)
4. 2.768 181.216 ↓ 1,909.0 1,909 1

Nested Loop (cost=14.45..256.96 rows=1 width=69) (actual time=168.295..181.216 rows=1,909 loops=1)

5. 0.410 168.548 ↓ 25.0 100 1

Bitmap Heap Scan on v_m_pci_principal_carga cvpc (cost=5.03..203.19 rows=4 width=43) (actual time=168.167..168.548 rows=100 loops=1)

  • Recheck Cond: (grupo = 101655)
  • Filter: (territorio = 'ERZ'::text)
  • Heap Blocks: exact=39
6. 168.138 168.138 ↑ 1.0 100 1

Bitmap Index Scan on in_v_m_pci_principal_carga_grupo (cost=0.00..5.03 rows=100 width=0) (actual time=168.138..168.138 rows=100 loops=1)

  • Index Cond: (grupo = 101655)
7. 4.200 9.900 ↓ 19.0 19 100

Bitmap Heap Scan on pln_cmc_integrator pci (cost=9.42..13.43 rows=1 width=42) (actual time=0.078..0.099 rows=19 loops=100)

  • Recheck Cond: ((id_cmc_meter = cvpc.id_cmc_meter) AND ((code_meter)::text = (cvpc.code_meter)::text))
  • Heap Blocks: exact=261
8. 0.378 5.700 ↓ 0.0 0 100

BitmapAnd (cost=9.42..9.42 rows=1 width=0) (actual time=0.057..0.057 rows=0 loops=100)

9. 1.500 1.500 ↓ 1.9 19 100

Bitmap Index Scan on in_cmc_integrator_id_cmc_meter (cost=0.00..4.51 rows=10 width=0) (actual time=0.015..0.015 rows=19 loops=100)

  • Index Cond: (id_cmc_meter = cvpc.id_cmc_meter)
10. 3.822 3.822 ↓ 1.5 20 98

Bitmap Index Scan on in_pln_cmc_integrator_code_meter (cost=0.00..4.66 rows=13 width=0) (actual time=0.039..0.039 rows=20 loops=98)

  • Index Cond: ((code_meter)::text = (cvpc.code_meter)::text)
11. 107,260.983 107,260.983 ↑ 1.0 1 1,909

Index Scan using uk_meter_pod_multipoint on cmc_meter cm (cost=0.42..1,617.00 rows=1 width=26) (actual time=55.182..56.187 rows=1 loops=1,909)

  • Index Cond: ((code_meter)::text = (pci.code_meter)::text)
12. 30.544 30.544 ↑ 1.0 1 1,909

Index Scan using pk_extractor_detail on pln_extractor_detail ped (cost=0.43..8.45 rows=1 width=14) (actual time=0.015..0.016 rows=1 loops=1,909)

  • Index Cond: (id_extractor_detail = cvpc.id_extractor_detail)
Planning time : 9.689 ms
Execution time : 107,642.265 ms