freeExec

но нет никакого фитбэка от пользователей.
Я думаю это достаточно серьёзная проблема, может кто подсказать как лучше поступить?

UPDATE pg_database SET datallowconn = 'false' WHERE datname = 'database_name';

SELECT pg_terminate_backend(pg_stat_activity.pid)
FROM pg_stat_activity
WHERE pg_stat_activity.datname = 'database_name' AND pid <> pg_backend_pid();

select id_user, array_agg(data) from tablename group by id_user

select json_agg((
select json_build_object('id_user', id_user, 'data', json_agg(data)) from tablename group by id_user
));

select 
current_date - interval '1 month' * s
from 
generate_series(0, 5) s

function makeGoogleApiRequest($params)
    {
        $apiUrl = "https://maps.googleapis.com/maps/api/geocode/json";
        $context = stream_context_create(['http'=>['timeout'=>5]]);
        
        
        
        // Make request
        $response = json_decode(file_get_contents($apiUrl . "?" . http_build_query($params), false, $context)); 

        
        
        // Check response
        if (
            json_last_error() ||
            !isset($response->status) || 
            $response->status !== "OK" ||
            !isset($response->results[0]->place_id) || 
            !isset($response->results[0]->formatted_address) ||
            !isset($response->results[0]->address_components) ||           
            !isset($response->results[0]->geometry->location->lat) ||
            !isset($response->results[0]->geometry->location->lng)           
        ) {                
            throw new \UnexpectedValueException ("Google Api Request Failed");
        }
        
        
        
        return $response;
    }

   



    /* Пример использования */
    $place = makeGoogleApiRequest([
        'address' => "Москва, Лаврушинский пер, 10",
        'language' => "ru"
    ]);

SELECT 
  city, count(*)
FROM 
  ip
GROUP BY
  city 
ORDER BY
  city ASC;