{"id":7026,"date":"2022-04-08T11:44:21","date_gmt":"2022-04-08T09:44:21","guid":{"rendered":"https:\/\/pandorafms.com\/library\/?p=7026"},"modified":"2025-07-07T10:30:28","modified_gmt":"2025-07-07T08:30:28","slug":"postgresql-monitoring","status":"publish","type":"post","link":"https:\/\/pandorafms.com\/library\/postgresql-monitoring\/","title":{"rendered":"PostgreSQL monitoring \"enterprise\""},"content":{"rendered":"

[et_pb_section fb_built=”1″ _builder_version=”4.16″ global_colors_info=”{}”][et_pb_row _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”][et_pb_column type=”4_4″ _builder_version=”4.16″ custom_padding=”|||” global_colors_info=”{}” custom_padding__hover=”|||”][et_pb_text _builder_version=”4.16″ background_size=”initial” background_position=”top_left” background_repeat=”repeat” global_colors_info=”{}”]<\/p>\n

\n

Important Notice:<\/strong> This plugin is no longer actively maintained or updated. We strongly advise you to explore alternative plugins available in our library for the latest features and support.<\/p>\n<\/div>\n

 <\/p>\n

Ver. 08-04-2022<\/p>\n

With this plug-in we will be able to monitor postgreSQL through customized queries.<\/p>\n

Type: Server plug-in<\/p>\n

Modules<\/strong><\/p>\n

The modules obtained by the plugin depend on the queries that we introduce, nevertheless, the plugin comes with a file with example queries that will create the following modules:<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
number_connections<\/td>\n<\/tr>\n
connections_waiting_in_locks<\/td>\n<\/tr>\n
connections_idle_in_transaction<\/td>\n<\/tr>\n
number_users<\/td>\n<\/tr>\n
number_roles<\/td>\n<\/tr>\n
psql_version<\/td>\n<\/tr>\n
num_blocks<\/td>\n<\/tr>\n
psql_diskspace<\/td>\n<\/tr>\n
number_commits<\/td>\n<\/tr>\n
number_rollbacks<\/td>\n<\/tr>\n
tuples_returned<\/td>\n<\/tr>\n
tuples_searched<\/td>\n<\/tr>\n
tuples_inserted<\/td>\n<\/tr>\n
tuples_removed<\/td>\n<\/tr>\n
state<\/td>\n<\/tr>\n
tuples_updated<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

Documentation<\/strong><\/p>\n

EN: Pandora PostgreSQL remote EN<\/a>
\nES: \u00a0Pandora PostgreSQL remote ES<\/a><\/p>\n

 <\/p>\n

Only enterprise users can view the download links.<\/p>[\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":"

Important Notice: This plugin is no longer actively maintained or updated. We strongly advise you to explore alternative plugins available in our library for the latest features and support.   Ver. 08-04-2022 With this plug-in we will be able to monitor postgreSQL through customized queries. Type: Server plug-in Modules The modules obtained by the plugin […]<\/p>\n","protected":false},"author":4033,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_et_pb_use_builder":"on","_et_pb_old_content":"

\r\n \r\n

Important Notice:<\/strong> This plugin is no longer actively maintained or updated. We strongly advise you to explore alternative plugins available in our library for the latest features and support.

\r\n<\/div>\r\n\r\n
\r\n\r\nVer. 08-04-2022\r\n\r\nWith this plug-in we will be able to monitor postgreSQL through customized queries.\r\n\r\nType: Server plug-in\r\n\r\nModules<\/strong>\r\n\r\nThe modules obtained by the plugin depend on the queries that we introduce, nevertheless, the plugin comes with a file with example queries that will create the following modules:\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n\r\n
number_connections<\/td>\r\n<\/tr>\r\n
connections_waiting_in_locks<\/td>\r\n<\/tr>\r\n
connections_idle_in_transaction<\/td>\r\n<\/tr>\r\n
number_users<\/td>\r\n<\/tr>\r\n
number_roles<\/td>\r\n<\/tr>\r\n
psql_version<\/td>\r\n<\/tr>\r\n
num_blocks<\/td>\r\n<\/tr>\r\n
psql_diskspace<\/td>\r\n<\/tr>\r\n
number_commits<\/td>\r\n<\/tr>\r\n
number_rollbacks<\/td>\r\n<\/tr>\r\n
tuples_returned<\/td>\r\n<\/tr>\r\n
tuples_searched<\/td>\r\n<\/tr>\r\n
tuples_inserted<\/td>\r\n<\/tr>\r\n
tuples_removed<\/td>\r\n<\/tr>\r\n
state<\/td>\r\n<\/tr>\r\n
tuples_updated<\/td>\r\n<\/tr>\r\n<\/tbody>\r\n<\/table>\r\n

<\/p>\r\nDocumentation<\/strong>\r\n\r\nEN: Pandora PostgreSQL remote EN<\/a>\r\nES: \u00a0Pandora PostgreSQL remote ES<\/a>\r\n\r\n\u00a0\r\n\r\n[enterprise]\r\n\r\nPSPZ2\r\n\r\npandora_postgresql<\/a>\r\n\r\nBinario\r\n\r\npandora_postgresql<\/a>\r\n\r\n[\/enterprise]","_et_gb_content_width":"","footnotes":""},"categories":[15,45],"tags":[196,450,81],"_links":{"self":[{"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/posts\/7026"}],"collection":[{"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/users\/4033"}],"replies":[{"embeddable":true,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/comments?post=7026"}],"version-history":[{"count":3,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/posts\/7026\/revisions"}],"predecessor-version":[{"id":9158,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/posts\/7026\/revisions\/9158"}],"wp:attachment":[{"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/media?parent=7026"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/categories?post=7026"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/pandorafms.com\/library\/wp-json\/wp\/v2\/tags?post=7026"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}