{"id":91969,"date":"2020-08-21T07:42:01","date_gmt":"2020-08-21T05:42:01","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix"},"modified":"2020-08-21T07:42:01","modified_gmt":"2020-08-21T05:42:01","slug":"monitoring-postgresql-s-ispolzovaniem-zabbix","status":"publish","type":"post","link":"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix","title":{"rendered":"Monitoring PostgreSQL pomoc\u00ed Zabbix","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"Monitoring PostgreSQL pomoc\u00ed Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/b17310212ae5dc4da0ca7d78312ca8ef.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<em>Prezentace Darii Vilkov\u00e9 pro Zabbix Meetup Online <\/em><\/p>\n<p><\/p>\n<p>Cht\u011bl bych v\u00e1s sezn\u00e1mit s monitorovac\u00edm n\u00e1strojem PostgreSQL a opera\u010dn\u00edho syst\u00e9mu, kter\u00fd vyv\u00edj\u00ed na\u0161e spole\u010dnost za pou\u017eit\u00ed Zabbixu. <\/p>\n<p><\/p>\n<p>Zabbix jsme si vybrali jako monitorovac\u00ed n\u00e1stroj ji\u017e d\u00e1vno, proto\u017ee je to platforma s otev\u0159en\u00fdm zdrojov\u00fdm k\u00f3dem, podporovan\u00e1 aktivn\u00ed komunitou a velmi popul\u00e1rn\u00ed v Rusku. <\/p>\n<p><\/p>\n<p>Vytvo\u0159ili jsme aktivn\u00edho agenta \u2014 Mamonsu, kter\u00fd nab\u00edzel flexibiln\u011bj\u0161\u00ed monitorov\u00e1n\u00ed, ne\u017e to umo\u017e\u0148ovaly standardn\u00ed n\u00e1stroje, a zaji\u0161\u0165oval sb\u011br metrik a jejich odes\u00edl\u00e1n\u00ed na Zabbix Server. V na\u0161\u00ed spole\u010dnosti se Mamonsu pou\u017e\u00edv\u00e1 p\u0159i prov\u00e1d\u011bn\u00ed auditu.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2 id=\"mamonsu\">Mamonsu<\/h2>\n<p><\/p>\n<p>Mamonsu je aktivn\u00ed agent (Zabbix Trapper) pro monitorov\u00e1n\u00ed PostgreSQL a opera\u010dn\u00edho syst\u00e9mu. Mamonsu (napsan\u00fd v Pythonu) umo\u017e\u0148uje nastavit parametry monitorov\u00e1n\u00ed PostgreSQL a opera\u010dn\u00edho syst\u00e9mu b\u011bhem p\u011bti minut. <\/p>\n<p><\/p>\n<p>Mamonsu nab\u00edz\u00ed dal\u0161\u00ed n\u00e1stroje:<\/p>\n<p><\/p>\n<ul>\n<li>mamonsu tune \u2014 p\u0159\u00edkaz, kter\u00fd upravuje parametry nastaven\u00ed v konfigura\u010dn\u00edm souboru PostgreSQL podle stroje, na kter\u00fd je nainstalov\u00e1n agent Mamonsu. <\/li>\n<li>mamonsu report \u2014 p\u0159\u00edkaz, kter\u00fd vytv\u00e1\u0159\u00ed odpov\u011bdi o opera\u010dn\u00edm syst\u00e9mu a PostgreSQL.<\/li>\n<\/ul>\n<p><\/p>\n<p>Mamonsu se instaluje na serveru DBMS, shroma\u017e\u010fuje informace, kompiluje je do JSON, kter\u00fd odes\u00edl\u00e1 pro vizualizaci na Zabbix Server, kde mus\u00ed b\u00fdt \u0161ablona pro jeho metriky.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitoring PostgreSQL pomoc\u00ed Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/9d87556e4b31b27cb7698b32b5f1e2c4.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Sch\u00e9ma fungov\u00e1n\u00ed Mamonsu<\/em> <\/p>\n<p><\/p>\n<h3 id=\"vozmozhnosti-mamonsu\">Mo\u017enosti Mamonsu<\/h3>\n<p><\/p>\n<ul>\n<li><strong>Efektivn\u00ed pr\u00e1ce s PostgreSQL<\/strong>. St\u00e1l\u00e9 spojen\u00ed s PostgreSQL je hlavn\u00ed v\u00fdhodou Mamonsu. P\u0159itom maxim\u00e1ln\u00ed po\u010det spojen\u00ed odpov\u00edd\u00e1 maxim\u00e1ln\u00edmu po\u010dtu datab\u00e1z\u00ed, ke kter\u00fdm se p\u0159ipojuje.<\/li>\n<li><strong>\u0160k\u00e1lovatelnost<\/strong>. Mamonsu je pln\u011b \"pluginov\u00fd\" agent a d\u00edky pevn\u00e9 struktu\u0159e ka\u017ed\u00e9ho pluginu a relativn\u00ed jednoduchosti Pythonu se snadno nau\u010d\u00edte ps\u00e1t nov\u00e9 nebo upravovat standardn\u00ed pluginy, t.j. parametry sb\u011bru metrik.<\/li>\n<li><strong>\u0160irok\u00fd z\u00e1b\u011br metrik pro monitorov\u00e1n\u00ed<\/strong> pro PostgreSQL v\u010detn\u011b metrik specifick\u00fdch roz\u0161\u00ed\u0159en\u00ed. <\/li>\n<li>Rychl\u00e9 spu\u0161t\u011bn\u00ed, <strong>dostupnost \"z krabice\"<\/strong>.<\/li>\n<li><strong>Export \u0161ablon a konfigura\u010dn\u00edch soubor\u016f<\/strong>, stejn\u011b jako nahr\u00e1v\u00e1n\u00ed na Zabbix Server.<\/li>\n<li><strong>K\u0159\u00ed\u017eov\u00e1 kompatibilita<\/strong>, co\u017e je d\u016fle\u017eit\u00e9 pro na\u0161e z\u00e1kazn\u00edky, kte\u0159\u00ed pou\u017e\u00edvaj\u00ed r\u016fzn\u00e9 distribuce Linuxu, v\u010detn\u011b dom\u00e1c\u00edch.<\/li>\n<li><strong>BSD-clause licence<\/strong>.<\/li>\n<\/ul>\n<p><\/p>\n<p>V tuto chv\u00edli nab\u00edz\u00edme \u0159adu plugin\u016f a v ka\u017ed\u00e9 dal\u0161\u00ed verzi se sna\u017e\u00edme p\u0159idat n\u011bco nov\u00e9ho.<\/p>\n<p><\/p>\n<ul>\n<li>14 plugin\u016f pro PostgreSQL, <\/li>\n<li>8 plugin\u016f pro OS Linux,<\/li>\n<li>4 pluginy pro OS Windows.<\/li>\n<\/ul>\n<p><\/p>\n<p>Mamonsu shroma\u017e\u010fuje v\u00edce ne\u017e 110 metrik PostgreSQL a opera\u010dn\u00edch syst\u00e9m\u016f:<\/p>\n<p><\/p>\n<ul>\n<li>70 metrik PostgreSQL,<\/li>\n<li>40 metrik OS Linux,<\/li>\n<li>8 metrik OS Windows.<\/li>\n<\/ul>\n<p><\/p>\n<p>Hlavn\u00ed metriky zahrnuj\u00ed dostupnost DBMS, po\u010det p\u0159ipojen\u00ed, velikost datab\u00e1ze, kontroln\u00ed body, rychlost \u010dten\u00ed\/z\u00e1pisu, z\u00e1mky, po\u010det proces\u016f autovakua a rychlost generov\u00e1n\u00ed WAL. Kompletn\u00ed seznam dostupn\u00fdch metrik a podrobn\u00e9 popisy v\u0161ech n\u00e1stroj\u016f jsou k dispozici na <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/postgrespro\/mamonsu\">repozit\u00e1\u0159e<\/a><\/noindex> webu GitHub. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitoring PostgreSQL pomoc\u00ed Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/259cc7f1b6ab0cf137cef6b4e9a22c0f.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Seznam dostupn\u00fdch metrik na webu GitHub<\/em><\/p>\n<p><\/p>\n<h3 id=\"zapusk-mamonsu-za-5-minut\">Spu\u0161t\u011bn\u00ed Mamonsu za 5 minut<\/h3>\n<p><\/p>\n<p>Nastaven\u00ed monitorov\u00e1n\u00ed PostgreSQL a opera\u010dn\u00edho syst\u00e9mu pomoc\u00ed Mamonsu lze prov\u00e9st za 5 minut, pokud provedete 5 jednoduch\u00fdch krok\u016f.<\/p>\n<p><\/p>\n<ol>\n<li><strong>Instalace Mamonsu<\/strong>. Mamonsu lze sestavit ze zdrojov\u00e9ho k\u00f3du nebo pou\u017e\u00edt dostupn\u00e9 bal\u00ed\u010dky.<\/li>\n<\/ol>\n<p><\/p>\n<p><code>$ git clone ... &amp;&amp; cd mamonsu &amp;&amp; python setup.py<\/code><\/p>\n<p><\/p>\n<p><code>build &amp;&amp; python setup.py install<\/code><\/p>\n<p><\/p>\n<ol>\n<li><strong>Nastaven\u00ed p\u0159ipojen\u00ed<\/strong>. Je nutn\u00e9 uv\u00e9st parametry p\u0159ipojen\u00ed k PostgreSQL a Zabbix Serveru v souboru agent.conf.<\/li>\n<\/ol>\n<p><\/p>\n<p><code>\/etc\/mamonsu\/agent.conf<\/code><\/p>\n<p><\/p>\n<ol>\n<li><strong>Export \u0161ablony do Zabbix Serveru<\/strong>.<\/li>\n<\/ol>\n<p><\/p>\n<p><code>$ mamonsu zabbix template export<\/code><\/p>\n<p><\/p>\n<p><code>\/usr\/share\/mamonsu\/example.xml<\/code><\/p>\n<p><\/p>\n<ol>\n<li><strong>P\u0159id\u00e1n\u00ed uzlu s\u00edt\u011b do Zabbix Serveru<\/strong>. Exportovan\u00e1 \u0161ablona bude automaticky p\u0159ipojena k nov\u00e9mu uzlu s\u00edt\u011b na Zabbix Serveru.<\/li>\n<\/ol>\n<p><\/p>\n<p><code>$ mamonsu zabbix host create mamonsu-demo<\/code><\/p>\n<p><\/p>\n<ol>\n<li><strong>Spu\u0161t\u011bn\u00ed<\/strong>.<\/li>\n<\/ol>\n<p><\/p>\n<p><code>$ service mamonsu start<\/code><\/p>\n<p><\/p>\n<h3 id=\"napravleniya-razvitiya-mamonsu\">Sm\u011bry rozvoje Mamonsu<\/h3>\n<p><\/p>\n<p>V r\u00e1mci rozvoje Mamonsu pl\u00e1nujeme vylep\u0161ovat metriky a vytv\u00e1\u0159et nov\u00e9 pluginy, nap\u0159\u00edklad plugin pro monitorov\u00e1n\u00ed velikosti jednotliv\u00fdch tabulek. Tak\u00e9 pl\u00e1nujeme zlep\u0161ovat a vytv\u00e1\u0159et dal\u0161\u00ed n\u00e1stroje a roz\u0161i\u0159ovat mo\u017enosti automatizace konfigurace pomoc\u00ed p\u0159\u00edkazu <strong>mamonsu tune<\/strong>. <\/p>\n<p><\/p>\n<h2 id=\"modul-monitoringa-postgresql-v-sostave-zabbix-agent-2\">Modul pro monitorov\u00e1n\u00ed PostgreSQL v\u010detn\u011b Zabbix Agent 2<\/h2>\n<p><\/p>\n<p>Pro p\u0159ipojen\u00ed k PostgreSQL se pou\u017e\u00edv\u00e1 rychl\u00fd a popul\u00e1rn\u00ed ovlada\u010d <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/jackc\/pgx\">pgx<\/a><\/noindex> (PG ovlada\u010d a n\u00e1strojov\u00e1 sada pro Go).<\/p>\n<p><\/p>\n<p>Zat\u00edm pou\u017e\u00edv\u00e1me dv\u011b rozhran\u00ed: Exporter, kter\u00fd vyvol\u00e1v\u00e1 zpracovatele podle kl\u00ed\u010de, a Konfigur\u00e1tor Zabbix Agent 2, kter\u00fd \u010dte a ov\u011b\u0159uje parametry p\u0159ipojen\u00ed k serveru zadefinovan\u00e9 v konfigura\u010dn\u00edm souboru.<\/p>\n<p><\/p>\n<p>Sna\u017eili jsme se optimalizovat pr\u00e1ci DBMS t\u00edm, \u017ee jsme skupinovali metriky a pou\u017e\u00edvali zpracovatele (handler) pro metriky a skupiny metrik, a tak\u00e9 vyu\u017e\u00edvali skupiny metrik v JSON jako z\u00e1visl\u00e9 prom\u011bnn\u00e9 (dependency items) a n\u00edzko\u00farov\u0148ov\u00e9 objevovac\u00ed pravidla (discovery rules). <\/p>\n<p><\/p>\n<h3 id=\"osnovnye-vozmozhnosti\">Hlavn\u00ed funkce<\/h3>\n<p><\/p>\n<ul>\n<li>udr\u017eov\u00e1n\u00ed st\u00e1l\u00e9ho p\u0159ipojen\u00ed k PostgreSQL mezi kontrolami; <\/li>\n<li>podpora flexibiln\u00edch interval\u016f dotazov\u00e1n\u00ed; <\/li>\n<li>kompatibilita s verzemi PostgreSQL od 10 a Zabbix Serverem od verze 4.4;<\/li>\n<li>mo\u017enost p\u0159ipojen\u00ed a monitorov\u00e1n\u00ed n\u011bkolika instanc\u00ed PostgreSQL najednou, d\u00edky tomu, \u017ee Zabbix Agent 2 umo\u017e\u0148uje vytv\u00e1\u0159et n\u011bkolik relac\u00ed.<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"urovni-parametrov-podklyucheniya-k-postgresql\">\u00darovn\u011b p\u0159ipojen\u00ed k PostgreSQL<\/h3>\n<p><\/p>\n<p>Celkem jsou k dispozici t\u0159i \u00farovn\u011b parametr\u016f p\u0159ipojen\u00ed k PostgreSQL, tj. \u00fakol\u016f a nastaven\u00ed:<\/p>\n<p><\/p>\n<ul>\n<li>Global,<\/li>\n<li>Sessions,<\/li>\n<li>Macros.<\/li>\n<\/ul>\n<p><\/p>\n<ol>\n<li>\n<p>Parametry Global jsou definov\u00e1ny na \u00farovni agenta, parametry Session a Macros definuj\u00ed parametry p\u0159ipojen\u00ed k datab\u00e1zi.<\/p>\n<p>\n<\/li>\n<li>\n<p>Parametry p\u0159ipojen\u00ed k PostgreSQL \u2014 Sessions jsou nastaveny v souboru <strong>zabbix_agent2.conf<\/strong>. <\/p>\n<p>\n<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitoring PostgreSQL pomoc\u00ed Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/d88abf88cb106e81f0e7eb23a1d4a193.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Parametry p\u0159ipojen\u00ed k PostgreSQL \u2014 Sessions<\/em><\/p>\n<p><\/p>\n<ul>\n<li>Po kl\u00ed\u010dov\u00e9m slovu <strong>Sessions<\/strong> je uvedeno unik\u00e1tn\u00ed jm\u00e9no relace, kter\u00e9 mus\u00ed b\u00fdt uvedeno ve kl\u00ed\u010di (\u0161ablon\u011b). <\/li>\n<li>Parametry <strong>URI<\/strong> a <strong>UserName<\/strong> jsou povinn\u00e9 pro ka\u017edou relaci. <\/li>\n<li>Pokud nen\u00ed zad\u00e1no jm\u00e9no datab\u00e1ze, pou\u017eije se v\u00fdchoz\u00ed spole\u010dn\u00e9 jm\u00e9no datab\u00e1ze pro v\u0161echny relace pro PostgreSQL, kter\u00e9 je tak\u00e9 definov\u00e1no v konfigura\u010dn\u00edm souboru.<\/li>\n<\/ul>\n<p><\/p>\n<ol>\n<li>Parametry p\u0159ipojen\u00ed k PostgreSQL \u2014 Macros jsou definov\u00e1ny v kl\u00ed\u010di metriky v \u0161ablon\u011b (podobn\u011b jako zp\u016fsob pou\u017eit\u00fd v Zabbix Agent 1), tj. jsou vytvo\u0159eny v \u0161ablon\u011b a pot\u00e9 uvedeny jako parametry v kl\u00ed\u010di. P\u0159itom je sekvence maker fixn\u00ed, tj. nap\u0159\u00edklad, <strong>URI<\/strong> se v\u017edy uv\u00e1d\u00ed na prvn\u00edm m\u00edst\u011b.<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitoring PostgreSQL pomoc\u00ed Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/3918b9de0118f901e916542f955bd17b.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Parametry p\u0159ipojen\u00ed k PostgreSQL \u2014 Macros<\/em> <\/p>\n<p><\/p>\n<p>Modul pro monitorov\u00e1n\u00ed PostgreSQL zahrnuje ji\u017e v\u00edce ne\u017e 95 metrik, kter\u00e9 pokr\u00fdvaj\u00ed pom\u011brn\u011b \u0161irok\u00fd rozsah parametr\u016f PostgreSQL, v\u010detn\u011b:<\/p>\n<p><\/p>\n<ul>\n<li>po\u010dtu p\u0159ipojen\u00ed,<\/li>\n<li>objemu datab\u00e1z\u00ed, <\/li>\n<li>archivace wal soubor\u016f,<\/li>\n<li>kontroln\u00edch bod\u016f,<\/li>\n<li>po\u010dtu \u201enafouknut\u00fdch\u201c tabulek,<\/li>\n<li>stavu replikace,<\/li>\n<li>zpo\u017ed\u011bn\u00ed repliky.<\/li>\n<\/ul>\n<p><\/p>\n<p>Metriky PostgreSQL nejsou informativn\u00ed bez parametr\u016f opera\u010dn\u00edho syst\u00e9mu. Ale Zabbix Agent 2 u\u017e um\u00ed shroma\u017e\u010fovat parametry opera\u010dn\u00edho syst\u00e9mu, proto pro z\u00edsk\u00e1n\u00ed \u00fapln\u00e9ho obrazu jednodu\u0161e p\u0159ipoj\u00edme k uzlu s\u00edt\u011b pot\u0159ebn\u00e9 \u0161ablony.<\/p>\n<p><\/p>\n<h3 id=\"obrabotchik-handler\">Handler (obslu\u017en\u00fd program)<\/h3>\n<p><\/p>\n<p>Handler (obslu\u017en\u00fd program) \u2014 hlavn\u00ed jednotka modulu, ve kter\u00e9 se prov\u00e1d\u00ed samotn\u00fd dotaz a kter\u00e1 umo\u017e\u0148uje z\u00edsk\u00e1vat metriky.<\/p>\n<p><\/p>\n<p>Pro z\u00edsk\u00e1n\u00ed jednoduch\u00e9 metriky:<\/p>\n<p><\/p>\n<ol>\n<li>Vytvo\u0159\u00edme soubor pro z\u00edsk\u00e1n\u00ed nov\u00e9 metriky:<\/li>\n<\/ol>\n<p><\/p>\n<p><strong>zabbix\/src\/go\/plugins\/postgres\/handler_uptime.go<\/strong><\/p>\n<p><\/p>\n<ol>\n<li>P\u0159ipoj\u00edme bal\u00ed\u010dek a uvedeme unik\u00e1tn\u00ed kl\u00ed\u010d (kl\u00ed\u010de) metrik:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitoring PostgreSQL pomoc\u00ed Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/692acc55377c18ee37a9e1d426ebeccb.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<ol>\n<li>Vytvo\u0159te handler (obslu\u017en\u00fd program) s dotazem, tj. inicializujeme prom\u011bnnou, ve kter\u00e9 bude v\u00fdsledek:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitoring PostgreSQL pomoc\u00ed Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/79e10e34edb78942acb6a264896be12d.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<ol>\n<li>Provedeme dotaz:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitoring PostgreSQL pomoc\u00ed Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/b7555bba37978302337ea0093dd1bb5c.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Je t\u0159eba zkontrolovat dotaz na chyby, po kter\u00fdch bude v\u00fdsledek zpracov\u00e1n procesem Zabbix Agent 2. <\/p>\n<p><\/p>\n<ol>\n<li>Registrov\u00e1me kl\u00ed\u010d nov\u00e9 metriky:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitoring PostgreSQL pomoc\u00ed Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/63256811903feacc5cf88e0a272aebd9.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Po registraci metriky m\u016f\u017eete znovu sestavit agenta s novou metrikou.<\/p>\n<p><\/p>\n<p>Modul je k dispozici od Zabbix 5.0 na webu <noindex><a rel=\"nofollow\" href=\"https:\/\/www.zabbix.com\/download\">https:\/\/www.zabbix.com\/download<\/a><\/noindex>. V t\u00e9to verzi Zabbix jsou parametry zad\u00e1v\u00e1ny odd\u011blen\u011b p\u0159es host a port. Ve verzi Zabbix 5.0.2, kter\u00e1 brzy vyjde, budou p\u0159ipojovac\u00ed parametry slou\u010deny do jednoho URI.<\/p>\n<p><\/p>\n<p>D\u011bkujeme za pozornost! <\/p>\n<p><\/p>\n<h2 id=\"poleznye-ssylki\">U\u017eite\u010dn\u00e9 odkazy<\/h2>\n<p><\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/postgrespro\/mamonsu\">GitHub Mamonsu<\/a><\/noindex><\/p>\n<p><\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/postgrespro.ru\/docs\/postgrespro\/11\/mamonsu\">Dokumentace k Mamonsu<\/a><\/noindex><\/p>\n<p><\/p>\n<p><noindex><a rel=\"nofollow\" href=\"https:\/\/git.zabbix.com\/projects\/ZBX\/repos\/zabbix\/browse\/src\/go\/plugins\/postgres\">Zabbix Git<\/a><\/noindex><\/p>\n<p>Zdroj: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/company\/zabbix\/blog\/515816\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u0414\u043e\u043a\u043b\u0430\u0434 \u0414\u0430\u0440\u044c\u0438 \u0412\u0438\u043b\u043a\u043e\u0432\u043e\u0439 \u0434\u043b\u044f Zabbix Meetup Online \u042f \u0445\u043e\u0447\u0443 \u043f\u043e\u0437\u043d\u0430\u043a\u043e\u043c\u0438\u0442\u044c \u0432\u0430\u0441 \u0441\u043e \u0441\u0440\u0435\u0434\u0441\u0442\u0432\u043e\u043c \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430 PostgreSQL \u0438 \u043e\u043f\u0435\u0440\u0430\u0446\u0438\u043e\u043d\u043d\u043e\u0439 \u0441\u0438\u0441\u0442\u0435\u043c\u044b, \u043a\u043e\u0442\u043e\u0440\u043e\u0435 \u0440\u0430\u0437\u0440\u0430\u0431\u0430\u0442\u044b\u0432\u0430\u0435\u0442\u0441\u044f \u043d\u0430\u0448\u0435\u0439 \u043a\u043e\u043c\u043f\u0430\u043d\u0438\u0435\u0439 \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c Zabbix. \u041c\u044b \u0432\u044b\u0431\u0440\u0430\u043b\u0438 Zabbix \u0432 \u043a\u0430\u0447\u0435\u0441\u0442\u0432\u0435 \u0441\u0440\u0435\u0434\u0441\u0442\u0432\u0430 \u043c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433\u0430 \u0443\u0436\u0435 \u0434\u0430\u0432\u043d\u043e, \u043f\u043e\u0442\u043e\u043c\u0443 \u0447\u0442\u043e \u044d\u0442\u043e \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u0430 \u0441 \u043e\u0442\u043a\u0440\u044b\u0442\u044b\u043c \u0438\u0441\u0445\u043e\u0434\u043d\u044b\u043c \u043a\u043e\u0434\u043e\u043c, \u043f\u043e\u0434\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u043c\u0430\u044f \u0430\u043a\u0442\u0438\u0432\u043d\u044b\u043c \u0441\u043e\u043e\u0431\u0449\u0435\u0441\u0442\u0432\u043e\u043c, \u043a\u043e\u0442\u043e\u0440\u0430\u044f \u043f\u043e\u043b\u044c\u0437\u0443\u0435\u0442\u0441\u044f \u0431\u043e\u043b\u044c\u0448\u043e\u0439 \u043f\u043e\u043f\u0443\u043b\u044f\u0440\u043d\u043e\u0441\u0442\u044c\u044e \u0432 \u0420\u043e\u0441\u0441\u0438\u0438. \u041c\u044b \u0441\u043e\u0437\u0434\u0430\u043b\u0438 \u0430\u043a\u0442\u0438\u0432\u043d\u044b\u0439 \u0430\u0433\u0435\u043d\u0442 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":91970,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-91969","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u0414\u043e\u043a\u043b\u0430\u0434 \u0414\u0430\u0440\u044c\u0438 \u0412\u0438\u043b\u043a\u043e\u0432\u043e\u0439 \u0434\u043b\u044f Zabbix Meetup.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u041c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433 PostgreSQL \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c Zabbix | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u0414\u043e\u043a\u043b\u0430\u0434 \u0414\u0430\u0440\u044c\u0438 \u0412\u0438\u043b\u043a\u043e\u0432\u043e\u0439 \u0434\u043b\u044f Zabbix Meetup.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-08-21T05:42:01+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-08-21T05:42:01+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Monitorov\u00e1n\u00ed PostgreSQL pomoc\u00ed Zabbix | ProHoster","description":"Prezentace Darii Vilkov\u00e9 na Zabbix Meetup.","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"cs_CZ","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u041c\u043e\u043d\u0438\u0442\u043e\u0440\u0438\u043d\u0433 PostgreSQL \u0441 \u0438\u0441\u043f\u043e\u043b\u044c\u0437\u043e\u0432\u0430\u043d\u0438\u0435\u043c Zabbix | ProHoster","og:description":"\u0414\u043e\u043a\u043b\u0430\u0434 \u0414\u0430\u0440\u044c\u0438 \u0412\u0438\u043b\u043a\u043e\u0432\u043e\u0439 \u0434\u043b\u044f Zabbix Meetup.","og:url":"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-08-21T05:42:01+00:00","article:modified_time":"2020-08-21T05:42:01+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"91969","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 10:20:01","updated":"2022-09-28 12:43:55","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/91969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=91969"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/91969\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media\/91970"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=91969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=91969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=91969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}