Unlock instant, AI-driven research and patent intelligence for your innovation.

Method and system for monitoring and traceability analysis of PostgreSQL database

A database and method invocation technology, applied in the field of information, can solve problems such as the inability to view historical operating status, and achieve the effect of strong security and flexibility

Pending Publication Date: 2021-09-03
BEIJING XJ ELECTRIC
View PDF0 Cites 0 Cited by
  • Summary
  • Abstract
  • Description
  • Claims
  • Application Information

AI Technical Summary

Problems solved by technology

[0003] Aiming at the problem that the historical operation status cannot be viewed in the prior art, the technical problem to be solved by the present invention is to provide a method and system for constructing PostgreSQL database monitoring and traceability analysis based on database snapshot sampling storage, so as to improve the efficiency of database operation and maintenance and ease of use

Method used

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
View more

Image

Smart Image Click on the blue labels to locate them in the text.
Viewing Examples
Smart Image
  • Method and system for monitoring and traceability analysis of PostgreSQL database
  • Method and system for monitoring and traceability analysis of PostgreSQL database
  • Method and system for monitoring and traceability analysis of PostgreSQL database

Examples

Experimental program
Comparison scheme
Effect test

Embodiment Construction

[0029] In order to make the object, technical solution and advantages of the present invention clearer, the present invention will be further described in detail below in conjunction with the accompanying drawings. It should be understood that the specific embodiments described here are only used to explain the present invention, not to limit the present invention.

[0030] The post-assessment method will be further described below in conjunction with the accompanying drawings and the embodiments of the present invention.

[0031] Such as figure 1 As shown, the embodiment of the present disclosure proposes a method for building PostgreSQL database monitoring and traceability analysis based on snapshot sampling technology, including:

[0032] The program uses the hook hook to load synchronously when the database starts through the hook_proc(void) function, and calls through the proc_entry_memsize(void) function method to request memory allocation from the database main process...

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

PUM

No PUM Login to View More

Abstract

The embodiment of the invention provides a processing method and system for constructing a PostgreSQL database based on a snapshot sampling technology, and the method comprises the steps: synchronously loading a monitoring plug-in by using a hook when the database is started, requesting for memory allocation from a host process of the database, and creating a monitoring sub-process; after the monitoring sub-process is started, obtaining database parameters, wherein the database parameters comprise a database state, an sql statement, an execution plan, lock information, data block change and host system information; shooting a database snapshot in real time by monitoring an sql statement of database operation and a database running state in real time; and storing a database snapshot shot in real time into a corresponding table and a view by calling a snapshoot (void) function.

Description

technical field [0001] The invention belongs to the field of information technology, and in particular relates to a method and system for constructing PostgreSQL database monitoring and traceability analysis based on database snapshot sampling storage. Background technique [0002] In the daily operation and maintenance of the database, diagnosing database performance, performance optimization, and fault tracing are important parts of the daily operation and maintenance work. There is ASH (Active Session History) in Oracle. ASH provides the most direct and effective basis for analyzing performance problems at the latest moment by extracting active session samples every second. However, in PostgreSQL, performance problems generally occur, which can only be observed through the system’s built-in performance view pg_stat_activity combined with top and iostat commands at the operating system level. The biggest defect is that the pg_stat_activity view can only see the currently r...

Claims

the structure of the environmentally friendly knitted fabric provided by the present invention; figure 2 Flow chart of the yarn wrapping machine for environmentally friendly knitted fabrics and storage devices; image 3 Is the parameter map of the yarn covering machine
Login to View More

Application Information

Patent Timeline
no application Login to View More
Patent Type & Authority Applications(China)
IPC IPC(8): G06F11/30G06F16/21G06F16/242G06F16/2455G06F9/445G06F9/50
CPCG06F11/302G06F11/3051G06F16/21G06F16/2433G06F16/2455G06F9/44526G06F9/5016
Inventor 李朋王伟崔志敏
Owner BEIJING XJ ELECTRIC