{"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\/sq\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix","title":{"rendered":"Monitorimi i PostgreSQL me p\u00ebrdorimin e Zabbix","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"Monitorimi i PostgreSQL me p\u00ebrdorimin e Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/b17310212ae5dc4da0ca7d78312ca8ef.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<em>Raporti i Darya Vilkovaya p\u00ebr Zabbix Meetup Online <\/em><\/p>\n<p><\/p>\n<p>D\u00ebshiroj t'ju prezantoj me nj\u00eb mjet monitorimi p\u00ebr PostgreSQL dhe sistemin operativ, q\u00eb po zhvillohet nga kompania jon\u00eb duke p\u00ebrdorur Zabbix. <\/p>\n<p><\/p>\n<p>E kemi zgjedhur Zabbix si mjet monitorimi shum\u00eb koh\u00eb m\u00eb par\u00eb, sepse \u00ebsht\u00eb nj\u00eb platform\u00eb me burim t\u00eb hapur, e mb\u00ebshtetur nga nj\u00eb komunitet aktiv, q\u00eb g Enjoyin popullaritet t\u00eb madh n\u00eb Rusi. <\/p>\n<p><\/p>\n<p>Kemi krijuar nj\u00eb agjent aktiv \u2014 Mamonsu, i cili ofronte monitorim m\u00eb fleksib\u00ebl se \u00e7'k\u00ebshtu lejonin mjetet standarde n\u00eb at\u00eb koh\u00eb dhe siguronte mbledhjen e metrikeve dhe d\u00ebrgimin e tyre n\u00eb Zabbix Server. N\u00eb kompanin\u00eb ton\u00eb, Mamonsu p\u00ebrdoret gjat\u00eb auditimit.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2 id=\"mamonsu\">Mamonsu<\/h2>\n<p><\/p>\n<p>Mamonsu \u00ebsht\u00eb nj\u00eb agjent aktiv (Zabbix Trapper) p\u00ebr monitorimin e PostgreSQL dhe sistemit operativ. Mamonsu (i shkruar n\u00eb Python) lejon t\u00eb konfigurohen parametrat e monitorimit p\u00ebr PostgreSQL dhe sistemin operativ brenda pes\u00eb minutash. <\/p>\n<p><\/p>\n<p>Mamonsu posedon mjete shtes\u00eb:<\/p>\n<p><\/p>\n<ul>\n<li>mamonsu tune \u2014 nj\u00eb komand\u00eb q\u00eb redakton parametrat e konfigurimit n\u00eb skedarin e konfigurimit t\u00eb PostgreSQL p\u00ebr makinat ku \u00ebsht\u00eb instaluar agjenti Mamonsu. <\/li>\n<li>mamonsu report \u2014 nj\u00eb komand\u00eb q\u00eb krijon raporte rreth sistemit operativ dhe PostgreSQL.<\/li>\n<\/ul>\n<p><\/p>\n<p>Mamonsu instalohet n\u00eb serverin e DBMS, mbledh informacionin, e kompoziton at\u00eb n\u00eb JSON, t\u00eb cilin e d\u00ebrgon p\u00ebr vizualizim n\u00eb Zabbix Server, ku duhet t\u00eb ket\u00eb nj\u00eb template p\u00ebr metrike t\u00eb tij.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorimi i PostgreSQL me p\u00ebrdorimin e Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/9d87556e4b31b27cb7698b32b5f1e2c4.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Skema e funksionimit t\u00eb Mamonsu<\/em> <\/p>\n<p><\/p>\n<h3 id=\"vozmozhnosti-mamonsu\">Mund\u00ebsit\u00eb e Mamonsu<\/h3>\n<p><\/p>\n<ul>\n<li><strong>P\u00ebrgjegjshm\u00ebria efektive me PostgreSQL<\/strong>. K\u00ebtu, lidhja e vazhdueshme me PostgreSQL \u00ebsht\u00eb avantazhi kryesor i Mamonsu. Nd\u00ebrkoh\u00eb, numri maksimal i lidhjeve \u00ebsht\u00eb i barabart\u00eb me numrin maksimale t\u00eb bazave t\u00eb t\u00eb dh\u00ebnave me t\u00eb cilat ai lidhet.<\/li>\n<li><strong>Zgjerueshm\u00ebria<\/strong>. Mamonsu \u00ebsht\u00eb nj\u00eb agjent plot\u00ebsisht \"plugin\", dhe fal\u00eb struktur\u00ebs s\u00eb fixuar t\u00eb \u00e7do plugini dhe thjesht\u00ebsis\u00eb relative t\u00eb Python, \u00ebsht\u00eb e leht\u00eb t\u00eb m\u00ebsoni si t\u00eb shkruani t\u00eb rinj ose t\u00eb redaktoni pluginat standard\u00eb, dmth parametrat e mbledhjes s\u00eb metrikeve.<\/li>\n<li><strong>Kapacitet t\u00eb gjer\u00eb t\u00eb metrikeve p\u00ebr monitorim<\/strong> p\u00ebr PostgreSQL, p\u00ebrfshir\u00eb edhe metrikat specifike p\u00ebr zgjerime. <\/li>\n<li>Nisje e shpejt\u00eb, <strong>disponueshm\u00ebri \"nga kutia\"<\/strong>.<\/li>\n<li><strong>Shkarkimi i-templateve dhe skedar\u00ebve t\u00eb konfigurimit<\/strong>, si dhe ngarkimi n\u00eb Zabbix Server.<\/li>\n<li><strong>Kros-platform\u00eb<\/strong>, q\u00eb \u00ebsht\u00eb e r\u00ebnd\u00ebsishme p\u00ebr klient\u00ebt tan\u00eb, t\u00eb cil\u00ebt p\u00ebrdorin distribucione t\u00eb ndryshme Linux, p\u00ebrfshir\u00eb ato vendase.<\/li>\n<li><strong>Licenc\u00eb BSD-clause<\/strong>.<\/li>\n<\/ul>\n<p><\/p>\n<p>Aktualisht ofrojm\u00eb shum\u00eb plugina dhe n\u00eb \u00e7do version t\u00eb ardhsh\u00ebm p\u00ebrpiqemi t\u00eb shtojm\u00eb di\u00e7ka t\u00eb re.<\/p>\n<p><\/p>\n<ul>\n<li>14 plugina p\u00ebr PostgreSQL, <\/li>\n<li>8 plugina p\u00ebr OS Linux,<\/li>\n<li>4 plugina p\u00ebr OS Windows.<\/li>\n<\/ul>\n<p><\/p>\n<p>Mamonsu mbledh m\u00eb shum\u00eb se 110 metrika p\u00ebr PostgreSQL dhe sistemet operuese:<\/p>\n<p><\/p>\n<ul>\n<li>70 metrika PostgreSQL,<\/li>\n<li>40 metrika OS Linux,<\/li>\n<li>8 metrika OS Windows.<\/li>\n<\/ul>\n<p><\/p>\n<p>Metrikat kryesore p\u00ebrfshijn\u00eb disponueshm\u00ebrin\u00eb e DBMS, numrin e lidhjeve, madh\u00ebsin\u00eb e baz\u00ebs s\u00eb t\u00eb dh\u00ebnave, kontrollin, shpejt\u00ebsin\u00eb e leximit\/shkrimit, bllokimet, numrin e proceseve autovacuum dhe shpejt\u00ebsin\u00eb e gjenerimit t\u00eb WAL. Lista e plot\u00eb e metrikeve t\u00eb disponueshme, si dhe p\u00ebrshkrimi i detajuar i t\u00eb gjitha mjeteve \u00ebsht\u00eb n\u00eb <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/postgrespro\/mamonsu\">repotit\u00eb e tij<\/a><\/noindex> faqen GitHub. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorimi i PostgreSQL me p\u00ebrdorimin e Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/259cc7f1b6ab0cf137cef6b4e9a22c0f.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Lista e metrikeve t\u00eb disponueshme n\u00eb faqen GitHub<\/em><\/p>\n<p><\/p>\n<h3 id=\"zapusk-mamonsu-za-5-minut\">Nisja e Mamonsu p\u00ebr 5 minuta<\/h3>\n<p><\/p>\n<p>P\u00ebr t\u00eb konfiguruar monitorimin e PostgreSQL dhe sistemit operativ me Mamonsu mund t\u00eb b\u00ebhet brenda 5 minutash duke ndjekur 5 hapa t\u00eb thjesht\u00eb.<\/p>\n<p><\/p>\n<ol>\n<li><strong>Instalimi i Mamonsu<\/strong>. Mamonsu mund t\u00eb nd\u00ebrtohet nga kodi burimor ose t\u00eb p\u00ebrdoren paketat e disponueshme.<\/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>Konfigurimi i lidhjeve<\/strong>. Duhet t\u00eb jepni parametrat e lidhjes me PostgreSQL dhe Zabbix Server n\u00eb skedarin 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>Eksportimi i modelit n\u00eb Zabbix Server<\/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>Shtimi i nj\u00eb nodi rrjeti n\u00eb Zabbix Server<\/strong>. Modeli i eksportuar do t\u00eb lidhet automatikisht me nodin e ri n\u00eb Zabbix Server.<\/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>Nisja<\/strong>.<\/li>\n<\/ol>\n<p><\/p>\n<p><code>$ service mamonsu start<\/code><\/p>\n<p><\/p>\n<h3 id=\"napravleniya-razvitiya-mamonsu\">Direktivat e zhvillimit t\u00eb Mamonsu<\/h3>\n<p><\/p>\n<p>N\u00eb kuad\u00ebr t\u00eb zhvillimit t\u00eb Mamonsu ne planifikojm\u00eb t\u00eb p\u00ebrmir\u00ebsojm\u00eb metrikat dhe t\u00eb krijojm\u00eb plugina t\u00eb rinj, si\u00e7 \u00ebsht\u00eb plugin p\u00ebr monitorimin e madh\u00ebsis\u00eb s\u00eb tabelave t\u00eb ve\u00e7anta. Ne gjithashtu planifikojm\u00eb t\u00eb p\u00ebrmir\u00ebsojm\u00eb dhe t\u00eb krijojm\u00eb mjete t\u00eb tjera, si dhe t\u00eb zgjerojm\u00eb mund\u00ebsit\u00eb e vet\u00ebkonfigurimit p\u00ebrmes komand\u00ebs <strong>mamonsu tune<\/strong>. <\/p>\n<p><\/p>\n<h2 id=\"modul-monitoringa-postgresql-v-sostave-zabbix-agent-2\">Moduli i monitorimit PostgreSQL si pjes\u00eb e Zabbix Agent 2<\/h2>\n<p><\/p>\n<p>P\u00ebr lidhjen me PostgreSQL p\u00ebrdoret nj\u00eb driver i shpejt\u00eb dhe i njohur <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/jackc\/pgx\">pgx<\/a><\/noindex> (PG driver dhe toolkit p\u00ebr Go).<\/p>\n<p><\/p>\n<p>Aktualisht ne p\u00ebrdorim dy nd\u00ebrfaqe: Eksportues, i cili th\u00ebrret trajtuesin me \u00e7el\u00ebs, dhe Konfiguruesi Zabbix Agent 2, i cili lexon dhe kontrollon parametrat e lidhjes me serverin, t\u00eb vendosur n\u00eb skedarin e konfigurimit.<\/p>\n<p><\/p>\n<p>Ne kemi p\u00ebrpiquar t\u00eb optimizojm\u00eb funksionimin e DBMS duke grupuar metrikat dhe duke p\u00ebrdorur trajtues (handler) p\u00ebr metrikat dhe grupet e metrikeve, si dhe duke p\u00ebrdorur grupe metrikash n\u00eb JSON si variabla t\u00eb varura (dependency items) dhe zbules\u00eb t\u00eb niveleve t\u00eb ul\u00ebta (discovery rules). <\/p>\n<p><\/p>\n<h3 id=\"osnovnye-vozmozhnosti\">Ve\u00e7orit\u00eb kryesore<\/h3>\n<p><\/p>\n<ul>\n<li>ruajtja e nj\u00eb lidhjeje t\u00eb q\u00ebndrueshme me PostgreSQL midis kontrolleve; <\/li>\n<li>mb\u00ebshtetje p\u00ebr intervale fleksibile sondazhi; <\/li>\n<li>kompatibiliteti me versionet PostgreSQL, duke filluar nga 10, dhe Zabbix Server, duke filluar nga versioni 4.4;<\/li>\n<li>mund\u00ebsia p\u00ebr t\u00eb lidhur dhe monitoruar disa instanca PostgreSQL nj\u00ebkoh\u00ebsisht fal\u00eb faktit se Zabbix Agent 2 lejon krijimin e disa sesioneve.<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"urovni-parametrov-podklyucheniya-k-postgresql\">Nivelet e parameter\u00ebve t\u00eb lidhjes me PostgreSQL<\/h3>\n<p><\/p>\n<p>Ka gjithsej tre nivele parameteresh lidhjeje me PostgreSQL, dmth. detyrat dhe konfigurimet:<\/p>\n<p><\/p>\n<ul>\n<li>Global,<\/li>\n<li>Sesione,<\/li>\n<li>Makro.<\/li>\n<\/ul>\n<p><\/p>\n<ol>\n<li>\n<p>Parametrat Global vendosen n\u00eb nivelin e agentit, parametrat Sesion dhe Makro p\u00ebrcaktojn\u00eb parametrat e lidhjes me baz\u00ebn.<\/p>\n<p>\n<\/li>\n<li>\n<p>Parametrat e lidhjes me PostgreSQL \u2014 Sesionet vendosen n\u00eb skedarin <strong>zabbix_agent2.conf<\/strong>. <\/p>\n<p>\n<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorimi i PostgreSQL me p\u00ebrdorimin e Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/d88abf88cb106e81f0e7eb23a1d4a193.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Parametrat e lidhjes me PostgreSQL \u2014 Sesionet<\/em><\/p>\n<p><\/p>\n<ul>\n<li>Pas fjal\u00ebs ky\u00e7e <strong>Sesione<\/strong> jepet nj\u00eb em\u00ebr unik sesi q\u00eb duhet t\u00eb p\u00ebrmendet n\u00eb \u00e7el\u00ebs (shabllon). <\/li>\n<li>Parametrat <strong>URI<\/strong> dhe <strong>UserName<\/strong> jan\u00eb t\u00eb detyrueshme p\u00ebr \u00e7do sesion. <\/li>\n<li>N\u00ebse emri i baz\u00ebs nuk \u00ebsht\u00eb specifikuar, p\u00ebrdoret emri i p\u00ebrgjithsh\u00ebm i baz\u00ebs p\u00ebr t\u00eb gjitha sesionet p\u00ebr PostgreSQL, i cili gjithashtu p\u00ebrcaktohet n\u00eb skedarin e konfigurimit.<\/li>\n<\/ul>\n<p><\/p>\n<ol>\n<li>Parametrat e lidhjes me PostgreSQL \u2014 Makro vendosen n\u00eb \u00e7el\u00ebsin e metrik\u00ebs n\u00eb shabllon (n\u00eb m\u00ebnyr\u00eb t\u00eb ngjashme me metod\u00ebn e p\u00ebrdorur n\u00eb Zabbix Agent 1), dmth. krijohen n\u00eb shabllon dhe m\u00eb pas p\u00ebrmenden si parametra n\u00eb \u00e7el\u00ebs. N\u00eb t\u00eb nj\u00ebjt\u00ebn koh\u00eb, rendi i makrove \u00ebsht\u00eb i fiksuar, dmth., p\u00ebr shembull, <strong>URI<\/strong> p\u00ebrher\u00eb p\u00ebrmendet n\u00eb vendin e par\u00eb.<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorimi i PostgreSQL me p\u00ebrdorimin e Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/3918b9de0118f901e916542f955bd17b.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Parametrat e lidhjes me PostgreSQL \u2014 Makro<\/em> <\/p>\n<p><\/p>\n<p>Moduli i monitorimit PostgreSQL p\u00ebrfshin tashm\u00eb m\u00eb shum\u00eb se 95 metrika, t\u00eb cilat lejojn\u00eb mbulimin e nj\u00eb s\u00ebr\u00eb t\u00eb gjer\u00eb parametrash PostgreSQL, duke p\u00ebrfshir\u00eb:<\/p>\n<p><\/p>\n<ul>\n<li>numrin e lidhjeve,<\/li>\n<li>v\u00ebllimin e bazave t\u00eb t\u00eb dh\u00ebnave, <\/li>\n<li>arkivimin e skedar\u00ebve wal,<\/li>\n<li>pikave kontrolluese,<\/li>\n<li>numrin e tabelave \"t\u00eb fryra\",<\/li>\n<li>statusin e replikimit,<\/li>\n<li>pasivitetin e replik\u00ebs.<\/li>\n<\/ul>\n<p><\/p>\n<p>Metrikat e PostgreSQL nuk jan\u00eb informuese pa parametrat e sistemit operativ. Por Zabbix Agent 2 tashm\u00eb di t\u00eb mbledh\u00eb parametrat e sistemit operativ, k\u00ebshtu q\u00eb p\u00ebr t\u00eb marr\u00eb nj\u00eb pamje t\u00eb plot\u00eb thjesht lidhni shabllonet e nevojshme me nyj\u00ebn e rrjetit.<\/p>\n<p><\/p>\n<h3 id=\"obrabotchik-handler\">Trajtuesi (handler)<\/h3>\n<p><\/p>\n<p>Trajtuesi (handler) \u2014 nj\u00ebsia kryesore e moduli, n\u00eb t\u00eb cil\u00ebn kryhet vet\u00eb k\u00ebrkesa dhe e cila lejon marrjen e metrikave.<\/p>\n<p><\/p>\n<p>P\u00ebr t\u00eb marr\u00eb nj\u00eb metrik\u00eb t\u00eb thjesht\u00eb:<\/p>\n<p><\/p>\n<ol>\n<li>Krijoni nj\u00eb skedar p\u00ebr marrjen e nj\u00eb metrik\u00eb t\u00eb re:<\/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>Lidhni paket\u00ebn dhe p\u00ebrcaktoni \u00e7el\u00ebsin unik (\u00e7el\u00ebsat e) metrikave:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorimi i PostgreSQL me p\u00ebrdorimin e Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/692acc55377c18ee37a9e1d426ebeccb.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<ol>\n<li>Krijoni nj\u00eb trajtues (handler) me k\u00ebrkes\u00ebn, dmth. nisim nj\u00eb variab\u00ebl, n\u00eb t\u00eb cil\u00ebn do t\u00eb jet\u00eb rezultati:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorimi i PostgreSQL me p\u00ebrdorimin e Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/79e10e34edb78942acb6a264896be12d.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<ol>\n<li>Kryeni k\u00ebrkes\u00ebn:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorimi i PostgreSQL me p\u00ebrdorimin e Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/b7555bba37978302337ea0093dd1bb5c.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Duhet t\u00eb kontrolloni k\u00ebrkes\u00ebn p\u00ebr gabime, pas s\u00eb cil\u00ebs rezultati do t\u00eb kapet nga procesi Zabbix Agent 2. <\/p>\n<p><\/p>\n<ol>\n<li>Regjistrojm\u00eb \u00e7el\u00ebsin e matjes s\u00eb re:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitorimi i PostgreSQL me p\u00ebrdorimin e Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/63256811903feacc5cf88e0a272aebd9.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>Pasi t\u00eb regjistrohet matja, mund t\u00eb rikompilohet agjenti me matjen e re.<\/p>\n<p><\/p>\n<p>Moduli \u00ebsht\u00eb i disponuesh\u00ebm q\u00eb nga Zabbix 5.0 n\u00eb faqen <noindex><a rel=\"nofollow\" href=\"https:\/\/www.zabbix.com\/download\">https:\/\/www.zabbix.com\/download<\/a><\/noindex>. N\u00eb k\u00ebt\u00eb version t\u00eb Zabbix, parametrat p\u00ebrcaktohen ve\u00e7mas p\u00ebrmes host dhe port. N\u00eb versionin Zabbix 5.0.2, i cili do t\u00eb publikohet s\u00eb shpejti, parametrat e lidhjes do t\u00eb grumbullohen n\u00eb nj\u00eb URI.<\/p>\n<p><\/p>\n<p>Faleminderit p\u00ebr v\u00ebmendjen! <\/p>\n<p><\/p>\n<h2 id=\"poleznye-ssylki\">Useful links<\/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\">Dokumentacioni mbi 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>Burimi: <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.2 - 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\/sq\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix\" \/>\n\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.2\" \/>\n\t\t<meta property=\"og:locale\" content=\"sq_AL\" \/>\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\/sq\/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\udd47Monitorimi i PostgreSQL me p\u00ebrdorimin e Zabbix | ProHoster","description":"Referati i Darya Vilkova p\u00ebr Zabbix Meetup.","canonical_url":"https:\/\/prohoster.info\/sq\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"sq_AL","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\/sq\/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\/sq\/wp-json\/wp\/v2\/posts\/91969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/comments?post=91969"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/posts\/91969\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media\/91970"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/media?parent=91969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/categories?post=91969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/sq\/wp-json\/wp\/v2\/tags?post=91969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}