Query Metrics
107
Database Queries
51
Different statements
153.68 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
25.31 ms (16.47%) |
1 |
select mgm.climate_zone, count (*) as blg, --edificios sum(mgm.numberofdwellings) as dwe, --viviendas sum(mgm.habitantes) as hab, --habitantes (sum(mgm.kpi_2_final_energy_consumption*mgm.grossfloorarea )/1000000)::int as kpi_2_final_energy_consumption, -- Unidades: GWh año (sum(mgm.kpi_8_ghg_emissions*mgm.grossfloorarea)/1000)::int as kpi_8_ghg_emissions, -- Unidades: TCO año (100*avg(mgm.kpi_21_average_price_renting_compared_family_income))::int as kpi_21_average_price_renting_compared_family_income -- Unidades: % de los ingresos from mat_map_geo_buildings mgm where adminunit in (8173) and mgm.use <> '-' group by mgm.climate_zone
Parameters:
[] |
|
22.17 ms (14.43%) |
1 |
SELECT adminunitname, geom, Box2D(ST_envelope(geom)) AS envelope FROM public.map_geo_municipio WHERE adminunit = 8173 LIMIT 1;
Parameters:
[] |
|
20.31 ms (13.22%) |
1 |
SELECT t0.id AS id_1, t0.question AS question_2, t0.response AS response_3, t0.datecache AS datecache_4, t0.adminunit AS adminunit_5 FROM cache_ai t0
Parameters:
[] |
|
5.79 ms (3.76%) |
2 |
select * from stat_analytic_related_kpis sa join kpi k on k.id = sa.kpi left join analytic_related_kpis ark on ark.analytic_id = sa.analytic and ark.kpi_id = sa.kpi where adminunit in (8173) and analytic = 9 order by ark.order
Parameters:
[] |
|
4.00 ms (2.60%) |
10 |
SELECT t0.id AS id_1, t0.question AS question_2, t0.response AS response_3, t0.datecache AS datecache_4, t0.adminunit AS adminunit_5 FROM cache_ai t0 WHERE t0.question = ? AND t0.adminunit = ? LIMIT 1
Parameters:
[ "Indicadores: tema: Edificios prioritarios para la rehabilitación bajo la EPBD 2024 edificios: 31 (14%) habitantes: 62 (12%) precio de la vivienda (€/m2): 4.10 (nivel: bajo)\nprecio medio alquiler comparado ingresos familiares (%): 0.24 (nivel: bajo)\nEmisiones de gases de efecto invernadero (KgCO2/m²año): 41.45 (nivel: alto)\nviviendas energéticamente eficientes: 0.00 (nivel: bajo)\npoblación con ingresos inferiores al 60% de la media: 0.00 (nivel: bajo)\nequipamiento urbano a 15 minutos caminando: 0.00 (nivel: bajo)\nsuperficies de zonas verdes (Ha): 0.26 (nivel: bajo)\npotencial de generación solar fotovoltaica (kWh/m²año): 6279.94 (nivel: bajo)\nacceso al carril bici: 0.00 (nivel: bajo)\nacceso a puntos de recarga: (nivel: )\n" 8173 ] |
|
2.89 ms (1.88%) |
2 |
select * from stat_analytic_related_kpis sa join kpi k on k.id = sa.kpi left join analytic_related_kpis ark on ark.analytic_id = sa.analytic and ark.kpi_id = sa.kpi where adminunit in (8173) and analytic = 2 order by ark.order
Parameters:
[] |
|
2.89 ms (1.88%) |
2 |
select * from stat_analytic_related_kpis sa join kpi k on k.id = sa.kpi left join analytic_related_kpis ark on ark.analytic_id = sa.analytic and ark.kpi_id = sa.kpi where adminunit in (8173) and analytic = 5 order by ark.order
Parameters:
[] |
|
2.88 ms (1.88%) |
2 |
select * from stat_analytic_related_kpis sa join kpi k on k.id = sa.kpi left join analytic_related_kpis ark on ark.analytic_id = sa.analytic and ark.kpi_id = sa.kpi where adminunit in (8173) and analytic = 3 order by ark.order
Parameters:
[] |
|
2.78 ms (1.81%) |
2 |
select * from stat_analytic_related_kpis sa join kpi k on k.id = sa.kpi left join analytic_related_kpis ark on ark.analytic_id = sa.analytic and ark.kpi_id = sa.kpi where adminunit in (8173) and analytic = 4 order by ark.order
Parameters:
[] |
|
2.76 ms (1.79%) |
2 |
select * from stat_analytic_grossfloorarea where adminunit in (8173) and analytic = 9
Parameters:
[] |
|
2.74 ms (1.78%) |
2 |
select * from stat_analytic_data where adminunit in (8173) and analytic = 9
Parameters:
[] |
|
2.70 ms (1.75%) |
2 |
select * from stat_analytic_buildinguse where adminunit in (8173) and analytic = 9
Parameters:
[] |
|
2.56 ms (1.67%) |
2 |
select * from stat_analytic_ocupacion where adminunit in (8173) and analytic = 9
Parameters:
[] |
|
2.23 ms (1.45%) |
2 |
select * from stat_analytic_year where adminunit in (8173) and analytic = 9
Parameters:
[] |
|
2.20 ms (1.43%) |
3 |
SELECT x.* FROM public.analytic x WHERE x.status = 1
Parameters:
[] |
|
1.93 ms (1.26%) |
2 |
select * from stat_analytic_buildinguse where adminunit in (8173) and analytic = 4
Parameters:
[] |
|
1.81 ms (1.18%) |
2 |
select * from stat_analytic_buildinguse where adminunit in (8173) and analytic = 3
Parameters:
[] |
|
1.75 ms (1.14%) |
2 |
select * from stat_analytic_year where adminunit in (8173) and analytic = 4
Parameters:
[] |
|
1.70 ms (1.10%) |
2 |
select * from stat_analytic_ocupacion where adminunit in (8173) and analytic = 3
Parameters:
[] |
|
1.63 ms (1.06%) |
1 |
SELECT kpi_legend.bgcolor, kpi_legend.min, kpi_legend.max, kpi_legend.kpi_id FROM public.kpi_legend -- GROUP BY kpi_legend.kpi_id, kpi_legend.id order by kpi_legend.kpi_id, kpi_legend.min ASC
Parameters:
[] |
|
1.62 ms (1.05%) |
2 |
select * from stat_analytic_grossfloorarea where adminunit in (8173) and analytic = 8
Parameters:
[] |
|
1.58 ms (1.03%) |
2 |
select * from stat_analytic_grossfloorarea where adminunit in (8173) and analytic = 3
Parameters:
[] |
|
1.49 ms (0.97%) |
2 |
select * from stat_analytic_buildinguse where adminunit in (8173) and analytic = 6
Parameters:
[] |
|
1.46 ms (0.95%) |
2 |
select * from stat_analytic_data where adminunit in (8173) and analytic = 5
Parameters:
[] |
|
1.44 ms (0.94%) |
2 |
select * from stat_analytic_buildinguse where adminunit in (8173) and analytic = 1
Parameters:
[] |
|
1.41 ms (0.92%) |
2 |
select * from stat_analytic_buildinguse where adminunit in (8173) and analytic = 5
Parameters:
[] |
|
1.40 ms (0.91%) |
2 |
select * from stat_analytic_ocupacion where adminunit in (8173) and analytic = 6
Parameters:
[] |
|
1.38 ms (0.90%) |
2 |
select * from stat_analytic_grossfloorarea where adminunit in (8173) and analytic = 4
Parameters:
[] |
|
1.38 ms (0.90%) |
2 |
select * from stat_analytic_data where adminunit in (8173) and analytic = 1
Parameters:
[] |
|
1.37 ms (0.89%) |
2 |
select * from stat_analytic_year where adminunit in (8173) and analytic = 3
Parameters:
[] |
|
1.36 ms (0.89%) |
2 |
select * from stat_analytic_data where adminunit in (8173) and analytic = 6
Parameters:
[] |
|
1.36 ms (0.88%) |
2 |
select * from stat_analytic_year where adminunit in (8173) and analytic = 1
Parameters:
[] |
|
1.34 ms (0.87%) |
2 |
select * from stat_analytic_year where adminunit in (8173) and analytic = 6
Parameters:
[] |
|
1.34 ms (0.87%) |
2 |
select * from stat_analytic_data where adminunit in (8173) and analytic = 8
Parameters:
[] |
|
1.30 ms (0.84%) |
2 |
select * from stat_analytic_ocupacion where adminunit in (8173) and analytic = 4
Parameters:
[] |
|
1.29 ms (0.84%) |
2 |
select * from stat_analytic_year where adminunit in (8173) and analytic = 5
Parameters:
[] |
|
1.29 ms (0.84%) |
2 |
select * from stat_analytic_ocupacion where adminunit in (8173) and analytic = 8
Parameters:
[] |
|
1.29 ms (0.84%) |
2 |
select * from stat_analytic_grossfloorarea where adminunit in (8173) and analytic = 1
Parameters:
[] |
|
1.28 ms (0.83%) |
2 |
select * from stat_analytic_year where adminunit in (8173) and analytic = 8
Parameters:
[] |
|
1.25 ms (0.81%) |
2 |
select * from stat_analytic_buildinguse where adminunit in (8173) and analytic = 8
Parameters:
[] |
|
1.23 ms (0.80%) |
2 |
select * from stat_analytic_grossfloorarea where adminunit in (8173) and analytic = 5
Parameters:
[] |
|
1.23 ms (0.80%) |
2 |
select * from stat_analytic_grossfloorarea where adminunit in (8173) and analytic = 6
Parameters:
[] |
|
1.22 ms (0.79%) |
2 |
select * from stat_analytic_data where adminunit in (8173) and analytic = 2
Parameters:
[] |
|
1.19 ms (0.77%) |
2 |
select * from stat_analytic_ocupacion where adminunit in (8173) and analytic = 2
Parameters:
[] |
|
1.19 ms (0.77%) |
2 |
select * from stat_analytic_ocupacion where adminunit in (8173) and analytic = 5
Parameters:
[] |
|
1.19 ms (0.77%) |
2 |
select * from stat_analytic_data where adminunit in (8173) and analytic = 3
Parameters:
[] |
|
1.18 ms (0.77%) |
2 |
select * from stat_analytic_buildinguse where adminunit in (8173) and analytic = 2
Parameters:
[] |
|
1.17 ms (0.76%) |
2 |
select * from stat_analytic_ocupacion where adminunit in (8173) and analytic = 1
Parameters:
[] |
|
1.16 ms (0.75%) |
2 |
select * from stat_analytic_data where adminunit in (8173) and analytic = 4
Parameters:
[] |
|
1.14 ms (0.74%) |
2 |
select * from stat_analytic_year where adminunit in (8173) and analytic = 2
Parameters:
[] |
|
1.14 ms (0.74%) |
2 |
select * from stat_analytic_grossfloorarea where adminunit in (8173) and analytic = 2
Parameters:
[] |
Database Connections
| Name | Service |
|---|---|
| default | doctrine.dbal.default_connection |
Entity Managers
| Name | Service |
|---|---|
| default | doctrine.orm.default_entity_manager |
Second Level Cache
Second Level Cache is not enabled.
Entities Mapping
| Class | Mapping errors |
|---|---|
| App\Entity\CacheAi | No errors. |
| App\Entity\Municipio | No errors. |
| App\Entity\Analytic | No errors. |