add database statistics

docker exec -it -u 0 poleznygorodru_postgis_1 /bin/sh -c 'apt-get -y install sudo && sudo -u postgres psql -U postgres -d gis  -c "SELECT * FROM usefulcity_user WHERE email=(SELECT u.email FROM usefulcity_user u GROUP BY u.email HAVING count(u.email) > 1)"'


docker exec -it -u 0 poleznygorodru_postgis_1 bash
docker exec -it -u 0 poleznygorodru_postgis_1 sudo -u postgres psql -U postgres -d gis  -c "SELECT * FROM usefulcity_user"
apt-get -y install sudo
sudo -u postgres psql -U postgres -d gis
SELECT * FROM usefulcity_user where count \g
SELECT * FROM pg_available_extensions WHERE name = 'pg_stat_statements' and installed_version is not null;
CREATE EXTENSION pg_stat_statements;

# postgis
shared_preload_libraries = 'pg_stat_statements, pg_shard'               # (change requires restart)
pg_stat_statements.max = 10000
pg_stat_statements.track = all

shared_preload_libraries = 'pg_stat_statements, pg_shard'\npg_stat_statements.max = 10000\npg_stat_statements.track = all

# reloads DB in container
docker exec -it -u 0 poleznygorodru_postgis_1 sudo -u postgres psql -U postgres -c "SELECT pg_reload_conf();"