PostgreSQL tala'aga o sauniga - fa'aopoopoga pgsentinel fou

Igoa pgsentinel tatalaina le pgsentinel faʻaopoopoga o le igoa tutusa (github faleoloa), lea e faʻaopoopoina le pg_active_session_history view i PostgreSQL - o le talaʻaga o faʻasalalauga faʻamalosi (e tutusa ma le Oracle's v$active_session_history).

O le mea moni, o nei mea na o le lua-le-lua snapshots mai le pg_stat_activity, ae o loʻo i ai mea taua:

1. O faʻamatalaga faʻaputu uma e teuina i totonu o le RAM, ma o le aofaʻi o le manatua e faʻatonutonuina e le numera o faʻamaumauga mulimuli na teuina.
2. O lo'o fa'aopoopoina le fa'ailoga fesili - o le queryid tutusa mai le fa'aopoopoga pg_stat_statements (mua'i fa'apipi'i mana'omia).
3. O le top_level_query field ua faʻaopoopoina - o le tusitusiga o le fesili na valaʻau ai le fesili o loʻo iai nei (pe a faʻaaoga pl/pgsql)

Lisi atoa o fanua pg_active_session_history:

      Koluma | Ituaiga ---------------------------------------------- ash_time | faailoga taimi ma sone taimi datid | oid datename | tusitusiga pid | fa'aoga numera numera | igoa fa'aoga | tusi talosaga_igoa | text client_addr | text client_hostname | text client_port | integer backend_start | faailoga taimi ma sone taimi xact_start | faailoga taimi ma sone taimi query_start | faailoga taimi ma sone taimi state_change | faailoga taimi ma sone taimi wait_event_type | tusitusiga faatalitali_event | tulaga mau | tusitusiga backend_xid | xid backend_xmin | xid top_level_query | fesili mau | text queryid | bigint backend_type | tusitusiga                     

E leai se afifi ua saunia mo le faʻapipiʻiina. E fautuaina e sii mai punaoa ma faʻapipiʻi le faletusi e oe lava. E te manaʻomia muamua faʻapipiʻi le pusa "devel" mo lau 'auʻaunaga ma seti le ala i le pg_config i le PATH fesuiaiga. Matou te aoina:

cd pgsentinel/src
fai
faʻaopoopo

Fa'aopoopo fa'amau i le postgres.conf:

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

# numera o fa'amaumauga lata mai o lo'o taofia i le manatua
pgsentinel_ash.max_entries = 10000

Toe amata PostgreSQL ma fai se faʻaopoopoga:

faia fa'aopoopoga pgsentinel;

O faʻamatalaga faʻaputuina e mafai ai ona matou taliina fesili e pei o:

• O a sauniga fa'atali na e fa'aaluina le tele o le taimi?
• O fea sauniga sa sili ona toaga?
• O a talosaga na sili ona malosi?

E mafai, ioe, maua tali i nei fesili e faʻaaoga ai fesili SQL, ae sili atu ona faigofie le vaʻaia o lenei mea i luga o se kalafi e ala i le faʻailogaina o taimi vaeluaga o le fiafia i le kiore. E mafai ona e faia lenei mea i se polokalama e leai se totogi PASH-Vaaiga (e mafai ona e siiina le binaries aoina i le vaega O faamalologa).

A amata, PASH-Viewer (amata mai le version 0.4.0) siaki le i ai o le pg_active_session_history view ma afai e i ai, e utaina le tala faʻaputu atoa mai ai ma faʻaauau ona faitau faʻamatalaga fou o loʻo oʻo mai, faʻafouina le kalafi i 15 sekone.

puna: www.habr.com