PostgreSQL hītori wātū hohe - toronga pgsentinel hou

Firm pgsentinel i tukuna te toronga pgsentinel o taua ingoa (putunga github), ka taapiri i te tirohanga pg_active_session_history ki PostgreSQL — te hitori o nga huihuinga hohe (he rite ki te v$active_session_history a Oracle).

Ko te tikanga, he whakaahua tuarua-a-rua enei mai i te pg_stat_activity, engari he mea nui:

1. Ko nga korero katoa kua kohia ka rongoa ki roto i te RAM anake, a ko te nui o te mahara ka whakatauhia e te maha o nga rekoata penapena whakamutunga.
2. Kua tāpirihia te āpure pātai - he ōrite te id pātai mai i te toronga pg_stat_statements (me hiahia i mua i te whakaurunga).
3. Kua tāpirihia te āpure top_level_query - te kuputuhi o te patai i karangahia ai te patai o naianei (mehemea kei te whakamahi pl/pgsql)

Rārangi katoa o ngā āpure pg_active_session_history:

      Tīwae | Momo ------------------ + tohuwā me te rohe wa i mua | ingoa ingoa | kupu pid | tauoti usesysid | ingoa ingoa | kupu tono_ingoa | kupu kiritaki_addr | kupu kiritaki_kaihautū ingoa | tauranga kiritaki_kupu | integer backend_start | waitohuwā me te rohe wa xact_start | waitohuwā me te rohe wa query_start | waitohuwā me te rohe wa state_change | waitohuwā me te rohe wa tatari_ahua_momo | kupu tatari_takahanga | ahua kupu | kuputuhi backend_xid | xid backend_xmin | xid top_level_query | patai kupu | id patai kupu | bigint backend_type | kuputuhi                     

Karekau he kete kua rite mo te whakaurunga. Ko te whakaaro me tango ake nga puna me te whakahiato i te whare pukapuka. Me whakauru tuatahi koe i te kete "devel" mo to kaimau ka tautuhi i te ara ki te pg_config i roto i te taurangi PATH. Ka kohia e matou:

cd pgsentinel/src
hanga
me whakarite

Tāpiri tawhā ki postgres.conf:

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

# te maha o nga rekoata hou e mau ana ki te mahara
pgsentinel_ash.max_entries = 10000

Tīmataria anō te PostgreSQL ka hanga he toronga:

hanga toronga pgsentinel;

Ko nga korero kua whakaemihia ka taea e maatau te whakautu i nga paatai ​​penei:

• He aha nga waahi tatari i whakapau kaha koe?
• Ko ēhea wahanga i tino kaha?
• He aha nga tono i tino kaha?

Ko te tikanga, ka taea e koe te tiki whakautu ki enei patai ma te whakamahi i nga patai SQL, engari he pai ake te kite i tenei ahua i runga i te kauwhata ma te tohu i nga waahi o te waa ki te kiore. Ka taea e koe tenei ma te kaupapa kore utu PASH-Tirohanga (Ka taea e koe te tango i nga raarangi kua kohia i te waahanga putanga).

I te wa e timata ana, ka tirotirohia e te PASH-Viewer (mai i te putanga 0.4.0) te aroaro o te tirohanga pg_active_session_history a mena kei te noho tonu, ka utaina e ia te katoa o nga hitori kua whakaemihia mai i a ia ka haere tonu ki te panui i nga raraunga taumai hou, me te whakahou i te kauwhata ia 15 hēkona.

Source: will.com