Umlando weseshini esebenzayo ye-PostgreSQL - isandiso esisha se-pgsentinel

Firm pgsentinel ikhiphe isandiso se-pgsentinel segama elifanayo (github repository), okwengeza ukubuka kwe-pg_active_session_history ku-PostgreSQL — umlando wamaseshini asebenzayo (ofana ne-v$active_session_history ka-Oracle).

Empeleni, lezi izifinyezo nje zesibili nesekhondi kusuka ku-pg_stat_activity, kodwa kunamaphuzu abalulekile:

1. Lonke ulwazi oluqoqiwe lugcinwa kuphela ku-RAM, futhi inani lememori elisetshenzisiwe lilawulwa inani lamarekhodi agciniwe agciniwe.
2. Inkambu ye-queryid yengeziwe - umbuzo ofanayo osuka kusandiso se-pg_stat_statements (ukufakwa ngaphambilini kuyadingeka).
3. Kungezwe inkambu ye-top_level_query - umbhalo wombuzo okwabizwa ngawo umbuzo wamanje (uma usebenzisa i-pl/pgsql)

Uhlu olugcwele lwezinkambu ze-pg_active_session_history:

      Ikholomu | Uhlobo ------------------+------------------------- ash_time | isitembu sesikhathi esinendawo yesikhathi datid | oid datename | umbhalo pid | inombolo ephelele usesyid | i-oid usename | umbhalo_igama lesicelo | umbhalo client_addr | text client_hostname | text client_port | inombolo ephelele ye-backend_start | isitembu sesikhathi esinendawo yesikhathi xact_start | isitembu sesikhathi esinendawo yesikhathi query_start | isitembu sesikhathi esinendawo yesikhathi state_change | isitembu sesikhathi esinendawo yesikhathi ethi wait_event_type | umbhalo othi wait_event | isimo sombhalo | umbhalo backend_xid | xid backend_xmin | xid top_level_query | umbuzo wombhalo | umbhalo queryid | bigint backend_type | umbhalo                     

Alikho iphakheji eselilungele ukufakwa okwamanje. Kunconywa ukulanda imithombo futhi uzihlanganisele umtapo wolwazi. Okokuqala udinga ukufaka iphakheji ye-"devel" yeseva yakho bese usetha indlela eya ku-pg_config ku-PATH variable. Siqoqa:

cd pgsentinel/src
ukwenza
yenza ukufaka

Engeza izinhlaka ku-postgres.conf:

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

# inombolo yamarekhodi akamuva agcinwe enkumbulweni
pgsentinel_ash.max_entries = 10000

Qala kabusha i-PostgreSQL bese udala isandiso:

dala isandiso se-pgsentinel;

Ulwazi oluqoqiwe lusivumela ukuba siphendule imibuzo efana nalena:

• Yiziphi izikhathi zokulinda ochithe isikhathi esiningi kuzo?
• Yiziphi izikhathi ebezisebenza kakhulu?
• Yiziphi izicelo ebezisebenza kakhulu?

Yebo, ungathola izimpendulo zale mibuzo usebenzisa imibuzo ye-SQL, kodwa kulula kakhulu ukukubona lokhu ngokubona kugrafu ngokugqamisa izikhawu zesikhathi ozithakaselayo ngegundane. Ungakwenza lokhu ngohlelo lwamahhala PASH-Viewer (ungadawuniloda amabhanari aqoqiwe esigabeni Ukukhululwa Kwe).

Uma iqala, i-PASH-Viewer (esukela kunguqulo 0.4.0) ihlola ukuba khona kokubukwa kwe-pg_active_session_history futhi uma ikhona, ilayisha wonke umlando oqoqwe kuyo futhi iyaqhubeka nokufunda idatha entsha engenayo, ibuyekeza igrafu njalo ngemizuzwana eyi-15.

Source: www.habr.com