PostgreSQL inoshanda chikamu nhoroondo - itsva pgsentinel yekuwedzera

The company pgsentinel yakaburitsa pgsentinel yekuwedzera yezita rimwechete (github repository), iyo inowedzera pg_active_session_history maonero kuPostgreSQL - nhoroondo yezvikamu zvinoshanda (zvakafanana neOracle's v $active_session_history).

Chaizvoizvo, aya angori echipiri-ne-sekondi snapshots kubva pg_stat_activity, asi pane akakosha mapoinzi:

1. Ruzivo rwese rwakaunganidzirwa runochengetwa muRAM chete, uye huwandu hunodyiwa hwendangariro hunodzorwa nehuwandu hwekupedzisira akachengetwa marekodhi.
2. Munda wemubvunzo unowedzerwa - iwowo queryid kubva pg_stat_statements yekuwedzera (pre-installation inodiwa).
3. Iyo yepamusoro_level_query ndima inowedzerwa - iwo mavara emubvunzo kubva payazvino mubvunzo wakadaidzwa (kana uchishandisa pl/pgsql)

Runyorwa ruzere rwepg_active_session_history ndima:

      Column | Type ------------------+------------------------- ash_time | timestamp ine nguva zone datid | oid datename | text pid | integer usesyid | oid usename | text application_name | text client_addr | text client_hostname | text client_port | integer backend_start | timestamp ine nguva zone xact_start | chitambi chenguva chine nguva query_start | timestamp ine nguva zone state_change | chitambi chenguva chine nguva yenguva wait_event_type | text wait_event | text state | text backend_xid | xid backend_xmin | xid top_level_query | text query | text queryid | bigint backend_type | text                     

Hapasati pasati pave nepasuru yakagadzirwa. Zvinokurudzirwa kudhawunirodha masosi uye kuunganidza raibhurari iwe pachako. Iwe unofanirwa kutanga waisa iyo "devel" package yeserver yako uye isa nzira yekuenda pg_config mune PATH shanduko. Tinounganidza:

cd pgsentinel/src
kuita
make install

Wedzera paramita kune postgres.conf:

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

# nhamba yemarekodhi achangoburwa akachengetwa mundangariro
pgsentinel_ash.max_entries = 10000

Tangazve PostgreSQL uye gadzira yekuwedzera:

gadzira kuwedzera pgsentinel;

Ruzivo rwakaunganidzwa runotibvumira kupindura mibvunzo yakadai se:

• Ndedzipi nguva dzekumirira dzawakapedza nguva yakawanda uchiita?
• Ndedzipi misangano yainyanya kushanda?
• Zvikumbiro zvipi zvainyanya kushanda?

Iwe unogona, hongu, kuwana mhinduro kumibvunzo iyi uchishandisa SQL mibvunzo, asi zviri nyore kuona izvi nemaziso pagirafu nekusimbisa nguva dzenguva dzekufarira negonzo. Iwe unogona kuita izvi nepurogiramu yemahara PASH-Viewer (unogona kudhawunirodha akaunganidzwa mabhinari muchikamu Releases).

Paunotanga, PASH-Viewer (kutanga kubva mushanduro 0.4.0) inotarisa kuvapo kwe pg_active_session_history maonero uye kana iripo, inotakura nhoroondo yose yakaunganidzwa kubva mairi uye inoenderera mberi nekuverenga data itsva inouya, ichivandudza girafu mumasekonzi gumi nemashanu.

Source: www.habr.com