{"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\/en\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix","title":{"rendered":"Monitoring PostgreSQL with Zabbix","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<p><img decoding=\"async\" alt=\"Monitoring PostgreSQL with Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/b17310212ae5dc4da0ca7d78312ca8ef.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<em>Daria Vilkova's Report for Zabbix Meetup Online <\/em><\/p>\n<p><\/p>\n<p>I would like to introduce you to a monitoring tool for PostgreSQL and operating systems, which is being developed by our company using Zabbix. <\/p>\n<p><\/p>\n<p>We chose Zabbix as our monitoring solution a long time ago because it is an open-source platform supported by an active community, which is very popular in Russia. <\/p>\n<p><\/p>\n<p>We created an active agent \u2014 Mamonsu, which provided more flexible monitoring than standard tools at the time, allowing for metric collection and transmission to the Zabbix Server. In our company, Mamonsu is used for auditing.<\/p>\n<p><noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h2 id=\"mamonsu\">Mamonsu<\/h2>\n<p><\/p>\n<p>Mamonsu is an active agent (Zabbix Trapper) for monitoring PostgreSQL and operating systems. Mamonsu (written in Python) allows you to configure PostgreSQL and operating system monitoring parameters in five minutes. <\/p>\n<p><\/p>\n<p>Mamonsu comes with additional tools:<\/p>\n<p><\/p>\n<ul>\n<li>mamonsu tune \u2014 a command that edits configuration parameters in the PostgreSQL configuration file for the machine on which the Mamonsu agent is installed. <\/li>\n<li>mamonsu report \u2014 a command that generates reports on the operating system and PostgreSQL.<\/li>\n<\/ul>\n<p><\/p>\n<p>Mamonsu is installed on the DBMS server, collects information, compiles it into JSON, and sends it for visualization to the Zabbix Server, where a template for its metrics should exist.<\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitoring PostgreSQL with Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/9d87556e4b31b27cb7698b32b5f1e2c4.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>Mamonsu Workflow<\/em> <\/p>\n<p><\/p>\n<h3 id=\"vozmozhnosti-mamonsu\">Mamonsu Features<\/h3>\n<p><\/p>\n<ul>\n<li><strong>Effective Work with PostgreSQL<\/strong>. A constant connection to PostgreSQL is the main advantage of Mamonsu. The maximum number of connections equals the maximum number of databases it connects to.<\/li>\n<li><strong>Scalability<\/strong>. Mamonsu is fully \"plugin-based,\" and thanks to the fixed structure of each plugin and the relative simplicity of Python, new plugins can be easily written or standard plugins can be modified, i.e., metric collection parameters.<\/li>\n<li><strong>Wide Coverage of Monitoring Metrics<\/strong> for PostgreSQL, including metrics from specific extensions. <\/li>\n<li>Quick Start, <strong>availability \"out of the box\"<\/strong>.<\/li>\n<li><strong>Export of templates and configuration files<\/strong>, as well as loading to Zabbix Server.<\/li>\n<li><strong>Cross-Platform Compatibility<\/strong>, which is important for our clients using various Linux distributions, including domestic ones.<\/li>\n<li><strong>BSD-clause license<\/strong>.<\/li>\n<\/ul>\n<p><\/p>\n<p>Currently, we offer a variety of plugins and strive to add something new in each subsequent version.<\/p>\n<p><\/p>\n<ul>\n<li>14 plugins for PostgreSQL, <\/li>\n<li>8 plugins for Linux OS,<\/li>\n<li>4 plugins for Windows OS.<\/li>\n<\/ul>\n<p><\/p>\n<p>Mamonsu collects over 110 metrics for PostgreSQL and operating systems:<\/p>\n<p><\/p>\n<ul>\n<li>70 metrics for PostgreSQL,<\/li>\n<li>40 metrics for Linux OS,<\/li>\n<li>8 metrics for Windows OS.<\/li>\n<\/ul>\n<p><\/p>\n<p>Key metrics include database availability, the number of connections, database size, checkpoints, read\/write speed, locks, number of autovacuum processes, and WAL generation speed. A complete list of available metrics and detailed descriptions of all tools are available at <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/postgrespro\/mamonsu\">the repository<\/a><\/noindex> the GitHub site. <\/p>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitoring PostgreSQL with Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/259cc7f1b6ab0cf137cef6b4e9a22c0f.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>The list of available metrics is on the GitHub site<\/em><\/p>\n<p><\/p>\n<h3 id=\"zapusk-mamonsu-za-5-minut\">Running Mamonsu in 5 minutes<\/h3>\n<p><\/p>\n<p>You can set up PostgreSQL and operating system monitoring with Mamonsu in just 5 minutes by following 5 simple steps.<\/p>\n<p><\/p>\n<ol>\n<li><strong>Installing Mamonsu<\/strong>. You can compile Mamonsu from source or use the available packages.<\/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>Configuring connections<\/strong>. You need to specify the connection parameters for PostgreSQL and Zabbix Server in the agent.conf file.<\/li>\n<\/ol>\n<p><\/p>\n<p><code>\/etc\/mamonsu\/agent.conf<\/code><\/p>\n<p><\/p>\n<ol>\n<li><strong>Exporting the template to 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>Adding a network node to Zabbix Server<\/strong>. The exported template will be automatically linked to the new network node on the 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>Start<\/strong>.<\/li>\n<\/ol>\n<p><\/p>\n<p><code>$ service mamonsu start<\/code><\/p>\n<p><\/p>\n<h3 id=\"napravleniya-razvitiya-mamonsu\">Development directions for Mamonsu<\/h3>\n<p><\/p>\n<p>As part of the development of Mamonsu, we plan to enhance metrics and create new plugins, such as a plugin for monitoring the size of individual tables. We also plan to improve and create additional tools, as well as expand auto-configuration capabilities via the command <strong>mamonsu tune<\/strong>. <\/p>\n<p><\/p>\n<h2 id=\"modul-monitoringa-postgresql-v-sostave-zabbix-agent-2\">PostgreSQL monitoring module as part of Zabbix Agent 2<\/h2>\n<p><\/p>\n<p>For connecting to PostgreSQL, we use a fast and popular driver <noindex><a rel=\"nofollow\" href=\"https:\/\/github.com\/jackc\/pgx\">pgx<\/a><\/noindex> (PG driver and toolkit for Go).<\/p>\n<p><\/p>\n<p>Currently, we use two interfaces: Exporter, which calls the handler by key, and Configurator for Zabbix Agent 2, which reads and checks the connection parameters to the server specified in the configuration file.<\/p>\n<p><\/p>\n<p>We have optimized the performance of the DBMS by grouping metrics and using a handler for metrics and groups of metrics, as well as using metric groups in JSON as dependent variables (dependency items) and low-level discovery (discovery rules). <\/p>\n<p><\/p>\n<h3 id=\"osnovnye-vozmozhnosti\">Key Features<\/h3>\n<p><\/p>\n<ul>\n<li>maintaining a persistent connection to PostgreSQL between checks; <\/li>\n<li>support for flexible polling intervals; <\/li>\n<li>compatibility with PostgreSQL versions starting from 10 and Zabbix Server starting from version 4.4;<\/li>\n<li>the ability to connect and monitor multiple PostgreSQL instances simultaneously, as Zabbix Agent 2 allows for the creation of multiple sessions.<\/li>\n<\/ul>\n<p><\/p>\n<h3 id=\"urovni-parametrov-podklyucheniya-k-postgresql\">Connection parameter levels for PostgreSQL<\/h3>\n<p><\/p>\n<p>There are three available levels of connection parameters for PostgreSQL, i.e., tasks and settings:<\/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>Global parameters are set at the agent level, while Session and Macros parameters define the database connection parameters.<\/p>\n<p>\n<\/li>\n<li>\n<p>PostgreSQL connection parameters \u2014 Sessions are specified in the file <strong>zabbix_agent2.conf<\/strong>. <\/p>\n<p>\n<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitoring PostgreSQL with Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/d88abf88cb106e81f0e7eb23a1d4a193.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>PostgreSQL connection parameters \u2014 Sessions<\/em><\/p>\n<p><\/p>\n<ul>\n<li>After the keyword <strong>Sessions<\/strong> a unique session name is specified, which must be included in the key (template). <\/li>\n<li>Parameters <strong>URI<\/strong> and <strong>UserName<\/strong> is mandatory for each session. <\/li>\n<li>If the database name is not specified, a common default database name is used for all sessions for PostgreSQL, which is also defined in the configuration file.<\/li>\n<\/ul>\n<p><\/p>\n<ol>\n<li>PostgreSQL connection parameters \u2014 Macros are defined in the metric key in the template (similarly to the method used in Zabbix Agent 1), i.e., created in the template and then indicated as parameters in the key. In this case, the sequence of macros is fixed, meaning, for example, <strong>URI<\/strong> it is always specified first.<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitoring PostgreSQL with Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/3918b9de0118f901e916542f955bd17b.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p><em>PostgreSQL connection parameters \u2014 Macros<\/em> <\/p>\n<p><\/p>\n<p>The PostgreSQL monitoring module includes over 95 metrics, allowing for a fairly wide range of PostgreSQL parameters, including:<\/p>\n<p><\/p>\n<ul>\n<li>the number of connections,<\/li>\n<li>the size of databases, <\/li>\n<li>archiving of WAL files,<\/li>\n<li>checkpoints,<\/li>\n<li>the number of \"bloated\" tables,<\/li>\n<li>replication status,<\/li>\n<li>replica lag.<\/li>\n<\/ul>\n<p><\/p>\n<p>PostgreSQL metrics are not informative without operating system parameters. However, Zabbix Agent 2 can already collect operating system parameters, so to get a complete picture, simply connect the necessary templates to the network node.<\/p>\n<p><\/p>\n<h3 id=\"obrabotchik-handler\">Handler<\/h3>\n<p><\/p>\n<p>A handler is the main unit of the module in which the query itself is executed and which allows for metrics retrieval.<\/p>\n<p><\/p>\n<p>To obtain a simple metric:<\/p>\n<p><\/p>\n<ol>\n<li>Create a file to collect a new metric:<\/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>Import the package and specify the unique key(s) for metrics:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitoring PostgreSQL with Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/692acc55377c18ee37a9e1d426ebeccb.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<ol>\n<li>Create a handler with the query, i.e., initialize a variable that will hold the result:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitoring PostgreSQL with Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/79e10e34edb78942acb6a264896be12d.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<ol>\n<li>Execute the query:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitoring PostgreSQL with Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/b7555bba37978302337ea0093dd1bb5c.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>It is necessary to check the query for errors, after which the result will be captured by the Zabbix Agent 2 process. <\/p>\n<p><\/p>\n<ol>\n<li>Register the key for the new metric:<\/li>\n<\/ol>\n<p><\/p>\n<p><img decoding=\"async\" alt=\"Monitoring PostgreSQL with Zabbix\" src=\"\/wp-content\/uploads\/2020\/08\/63256811903feacc5cf88e0a272aebd9.png\" style=\"display:block;margin: 0 auto;\" \/><\/p>\n<p><\/p>\n<p>After registering the metric, you can rebuild the agent with the new metric.<\/p>\n<p><\/p>\n<p>The module is available starting from Zabbix 5.0 on the website. <noindex><a rel=\"nofollow\" href=\"https:\/\/www.zabbix.com\/download\">https:\/\/www.zabbix.com\/download<\/a><\/noindex>. In this version of Zabbix, parameters are set separately via host and port. In Zabbix version 5.0.2, which will be released soon, the connection parameters will be combined into a single URI.<\/p>\n<p><\/p>\n<p>Thank you for your attention! <\/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\">Documentation for 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>Source: <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\/en\/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=\"en_US\" \/>\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\/en\/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\udd47Monitoring PostgreSQL using Zabbix | ProHoster","description":"Presentation by Daria Vilkova for the Zabbix Meetup.","canonical_url":"https:\/\/prohoster.info\/en\/blog\/administrirovanie\/monitoring-postgresql-s-ispolzovaniem-zabbix","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"en_US","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\/en\/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\/en\/wp-json\/wp\/v2\/posts\/91969","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/comments?post=91969"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/posts\/91969\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/media\/91970"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/media?parent=91969"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/categories?post=91969"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/en\/wp-json\/wp\/v2\/tags?post=91969"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}