PostgreSQL akụkọ ihe mere eme nnọkọ - ndọtị pgsentinel ọhụrụ

Ike pgsentinel weputara ndọtị pgsentinel nke otu aha ahụ (github ebe nchekwa), nke na-agbakwụnye echiche pg_active_session_history na PostgreSQL - akụkọ ihe mere eme nke nnọkọ (nke yiri Oracle's v$active_session_history).

N'ụzọ bụ isi, ndị a bụ foto nke abụọ na nke abụọ site na pg_stat_activity, mana enwere isi ihe dị mkpa:

1. A na-echekwa ozi niile ekpokọbara naanị na RAM, yana ọnụọgụ ndekọ echekwara na-ahazi oke ebe nchekwa riri.
2. A na-agbakwunye mpaghara ajụjụ - otu ajụjụ ahụ sitere na pg_stat_statements ndọtị (nwụnye nke mbụ achọrọ).
3. A na-agbakwunye mpaghara top_level_query - ederede nke ajụjụ a si na ya kpọọ ajụjụ dị ugbu a (ọ bụrụ na ị na-eji pl/pgsql)

Ndepụta zuru ezu nke ubi pg_active_session_history:

      Ogidi | Ụdị ------------------+----------------------------------- ash_time | timestamp na oge mpaghara datid | oid datename | ederede pid | ọnụọgụ ọnụọgụ | aha njirimara oid | ederede ngwa_name | ederede client_addr | ederede client_hostname | ederede client_port | integer backend_start | timestamp na mpaghara oge xact_start | timestamp nwere mpaghara oge query_start | timestamp nwere oge mpaghara state_change | timestamp nwere oge mpaghara wait_event_type | ederede chere_ementị | steeti ederede | ederede backend_xid | xid backend_xmin | xid top_level_query | ajụjụ ederede | ederede queryid | bigint backend_type | ederede                     

Enweghị ngwungwu emebere maka nwụnye ma. A na-atụ aro ka ibudata isi mmalite ma chịkọta ọba akwụkwọ n'onwe gị. Buru ụzọ tinye ngwungwu “mmepe” maka nkesa gị wee tọọ ụzọ pg_config na mgbanwe PATH. Anyị na-anakọta:

cd pgsentinel/src
-eme ka
dozie

Tinye paramita na postgres.conf:

shared_preload_libraries = 'pg_stat_statements, pgsentinel'
track_activity_query_size = 2048
pg_stat_statements.track = niile

# ọnụọgụ ndekọ na nso nso a ejidere na ebe nchekwa
pgsentinel_ash.max_entries = 10000

Malitegharịa PostgreSQL wee mepụta ndọtị:

mepụta ndọtị pgsentinel;

Ozi anakọtara na-enye anyị ohere ịza ajụjụ dịka:

• Kedu oge nchere ị na-etinye oge kacha na ya?
• Kedu nnọkọ kacha arụ ọrụ?
• Kedu arịrịọ ndị kacha arụ ọrụ?

Ị nwere ike, n'ezie, nweta azịza nye ajụjụ ndị a site na iji ajụjụ SQL, mana ọ ka mma ịhụ nke a anya na eserese site n'igosi oge mmasị na òké ahụ. Ị nwere ike ime nke a na mmemme efu PASH-nlele (ị nwere ike ibudata ọnụọgụ abụọ anakọtara na ngalaba releases).

Mgbe ị na-amalite, PASH-Viewer (malite na ụdị 0.4.0) na-enyocha maka ọnụnọ nke pg_active_session_history elele ma ọ bụrụ na ọ dị, ọ na-ebufe akụkọ ihe mere eme niile na ya wee gaa n'ihu na-agụ data ọhụrụ na-abata, na-emelite eserese ọ bụla 15 sekọnd.

isi: www.habr.com