Moran analysis does not finish because of query

[javisantana]

• load a table with 120k registers (this table https://cartoworkshops.carto.com/u/partnerbr24/dataset/crime_lat_long_mxdf )
• create a centroids analysis (group by cuadrante)
• add a moran

Moran take ages

the query from pg_stats_activity is:

 
 /* 4612388e-559c-4762-bedd-a39bd4727db0 */ /* analysis:moran */BEGIN;DELETE FROM analysis_91837cbb3c_872747c77461
aafbd2ff80c5fee0b17dbe1a011a;INSERT INTO analysis_91837cbb3c_872747c77461aafbd2ff80c5fee0b17dbe1a011a SELECT input
_query.*, m.quads, m.significance, m.moran, m.vals
 FROM (SELECT
   row_number() over() as cartodb_id,
   ST_Centroid(ST_Collect(the_geom)) as the_geom,
   cuadrante as category,
   count(1) as value
 FROM (SELECT * FROM crime_lat_long_mxdf) q
 GROUP BY cuadrante) input_query, (
   SELECT * FROM
   cdb_crankshaft.CDB_AreasOfInterestLocal(
     'SELECT
   row_number() over() as cartodb_id,
   ST_Centroid(ST_Collect(the_geom)) as the_geom,
   cuadrante as category,
   count(1) as value
 FROM (SELECT * FROM crime_lat_long_mxdf) q
 GROUP BY cuadrante',
     'value',
     'knn',