Skip to content

Instantly share code, notes, and snippets.

@dmius

dmius/f003.md Secret

Last active December 20, 2018 12:39
Show Gist options
  • Save dmius/5e3186dbf1aa52cd1eda59c288e0708e to your computer and use it in GitHub Desktop.
Save dmius/5e3186dbf1aa52cd1eda59c288e0708e to your computer and use it in GitHub Desktop.

A004 Cluster information

Observations

Master (dev)

Indicator Value
Postgres Version PostgreSQL 9.6.11 on x86_64-pc-linux-gnu (Debian 9.6.11-1.pgdg80+1), compiled by gcc (Debian 4.9.2-10+deb8u1) 4.9.2, 64-bit
Config file /etc/postgresql/9.6/main/postgresql.conf
Role Master
Replicas
Started At 2018-11-19 10:27:11+00
Uptime 31 days 02:00:44
Checkpoints 49368
Forced Checkpoints 7.4%
Checkpoint MB/sec 0.007179
Database Name postila_ru
Database Size 5984 MB
Stats Since 2018-01-02 04:20:52+00
Stats Age 352 days 08:07:04
Installed Extensions dblink 1.1, file_fdw 1.0, pg_stat_kcache 2.1.1, pg_stat_statements 1.4, pgcrypto 1.1plpgsql 1.0, plpython2u 1.0, plpythonu 1.0, plsh 2, rum 1.2tablefunc 1.0, uuid-ossp 1.0
Cache Effectiveness 97.16%
Successful Commits 98.83%
Conflicts 0
Temp Files: total size 2337 MB
Temp Files: total number of files 240
Temp Files: avg file size 9971 kB
Deadlocks 0

Databases sizes

Database Size
postila_ru 6 GiB
juntosdev 18 GiB
spheremail 9 MiB
elaine_development 26 GiB
localpensieve_test 14 MiB
rupostgres 8 MiB
otter 8 MiB
template0 8 MiB
postila_prod 310 GiB
postfix 8 MiB
dev_dm 52 MiB
dtw 8 MiB
goodfilm 8 MiB
kong 9 MiB
postgres 10 MiB
template1 8 MiB
vegas 74 MiB
postila_test 134 GiB
localpensieve_dev 3 GiB
boost_development 25 MiB
d1_perepel_ru 444 MiB
_boost_deve2 16 MiB
umka 10 MiB
test 11 GiB
redash 8 MiB
contrib_regression 13 MiB
lc 13 MiB
test2 8 MiB
penstest 11 MiB
test_search_path 8 MiB
_4vkusa_ru 6 GiB
sysbench 8 MiB
test11 44 MiB
cwlogs 8 MiB
powa 247 MiB
vyagofarov 8 MiB
dba 8 MiB
postgres_ai_bak 8 MiB
postgres_ai 144 MiB
pgreplay_tmp 8 MiB
test10 645 MiB
pgreplay_tmp1 6 GiB
postgres_ai_test 17 MiB

Conclusions

Recommendations

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment