# DB Version: 9.6
# OS Type: linux
# DB Type: oltp
# Total Memory (RAM): 32 GB
# Number of Connections: 100

max_connections = 100
shared_buffers = 8GB
effective_cache_size = 24GB
work_mem = 83886kB
maintenance_work_mem = 2GB
min_wal_size = 2GB
max_wal_size = 4GB
checkpoint_completion_target = 0.9
wal_buffers = 16MB
default_statistics_target = 100

select 
relname
,last_vacuum
,last_autovacuum
,last_analyze
,last_autoanalyze
from pg_stat_all_tables s
where schemaname='public';

vacuum analyze verbose;

$ grep  "^[A-Za-z]" p.conf | cat -
listen_addresses = '*'          # what IP address(es) to listen on;
port = 5432                             # (change requires restart)
max_connections = 100                   # (change requires restart)
shared_buffers = 8192MB         # min 128kB
work_mem = 512MB                                # min 64kB
dynamic_shared_memory_type = windows    # the default is the first option
shared_preload_libraries = 'online_analyze, plantuner'          # (change requires restart)
fsync = off                             # flush data to disk for crash safety
log_destination = 'stderr'              # Valid values are combinations of
logging_collector = on          # Enable capturing of stderr and csvlog
log_line_prefix = '%t '                 # special values:
log_timezone = 'Europe/Moscow'
datestyle = 'iso, dmy'
timezone = 'Europe/Moscow'
lc_messages = 'Russian_Russia.1251'                     # locale for system error message
lc_monetary = 'Russian_Russia.1251'                     # locale for monetary formatting
lc_numeric = 'Russian_Russia.1251'                      # locale for number formatting
lc_time = 'Russian_Russia.1251'                         # locale for time formatting
default_text_search_config = 'pg_catalog.russian'
max_locks_per_transaction = 150         # min 10
escape_string_warning = off
standard_conforming_strings = off
online_analyze.threshold = 50
online_analyze.scale_factor = 0.1
online_analyze.enable = on
online_analyze.verbose = off
online_analyze.min_interval = 10000
online_analyze.table_type = 'temporary'
plantuner.fix_empty_table = false

## Запуск на клиенте (подключение к базе через сеть)
$ psql -h MY_SERVER_NAME -p 5432 -d postgres -U postgres

## Запуск на сервер (локальное подключение к базе)
$ psql
psql (9.6.5)
Type "help" for help.

postgres=# select
postgres-# relname
postgres-# ,last_vacuum
postgres-# ,last_autovacuum
postgres-# ,last_analyze
postgres-# ,last_autoanalyze
postgres-# from pg_stat_all_tables s
postgres-# where schemaname='public';
   relname   | last_vacuum | last_autovacuum |         last_analyze          | last_autoanalyze
-------------+-------------+-----------------+-------------------------------+------------------
 staff_1_10  |             |                 | 2017-09-28 15:50:37.221614+03 |
 staff       |             |                 | 2017-09-28 15:50:37.225214+03 |
 staff_10_20 |             |                 | 2017-09-28 15:50:37.223481+03 |
(3 rows)

postgres=# vacuum analyze verbose;
INFO:  analyzing "public.staff_1_10"
INFO:  "staff_1_10": scanned 1 of 1 pages, containing 1 live rows and 0 dead rows; 1 rows in sample, 1 estimated total rows
INFO:  analyzing "public.staff_10_20"
INFO:  "staff_10_20": scanned 1 of 1 pages, containing 2 live rows and 0 dead rows; 2 rows in sample, 2 estimated total rows
INFO:  analyzing "public.staff"
INFO:  "staff": scanned 1 of 1 pages, containing 1 live rows and 0 dead rows; 1 rows in sample, 1 estimated total rows

...
postgres-# where schemananame='public';
ОШИБКА:  столбец "schemananame" не существует
СТРОКА 4: where schemananame='public';
                ^
ПОДСКАЗКА:  Возможно, предполагалась ссылка на столбец "s.schemaname".
...

Vadim Lejnin,

Я не знаю. установили 1С кластер, Postgre, потом в кластере 1С создали базу(с отметкой создать БД в postgre, если база отсутствует), потом зашли в конфигуратор и загрузили .DT файл. НУ и зачем мне сейчас это? это даст какие то данные, чтоб понять причину такой низкой производительности?
...

postgres=# where schemaname='public';
ОШИБКА:  ошибка синтаксиса (примерное положение: "where")
СТРОКА 1: where schemaname='public';
          ^
postgres=#

select 
relname
,last_vacuum
,last_autovacuum
,last_analyze
,last_autoanalyze
from pg_stat_all_tables s
where schemaname='public';

VACUUM ANALYZE VERBOSE;