Tarihin zama mai aiki na PostgreSQL - sabon tsawaita pgsentinel

M pgsentinel saki pgsentinel tsawo na wannan sunan (github wurin ajiya), wanda ke ƙara ra'ayi pg_active_session_history zuwa PostgreSQL - tarihin zaman aiki (mai kama da Oracle's v$active_session_history).

Mahimmanci, waɗannan hotuna ne kawai na biyu zuwa na biyu daga pg_stat_activity, amma akwai mahimman bayanai:

1. Duk bayanan da aka tara ana adana su ne kawai a cikin RAM, kuma adadin ƙwaƙwalwar da aka cinye ana sarrafa shi ta adadin bayanan da aka adana na ƙarshe.
2. An ƙara filin tambaya - tambaya iri ɗaya daga pg_stat_statements tsawo (wanda ake buƙatar shigarwa kafin shigarwa).
3. Ana ƙara filin top_level_query - rubutun tambayar da aka kira tambayar yanzu (idan ana amfani da pl/pgsql)

Cikakken jerin filayen pg_active_session_history:

      Rukunin | Nau'in -------------------+-------------------------------------lokacin ash_ timestamp tare da yankin lokaci datid | oid datename | rubutu pid | lamba userysid | oid username | text application_name | rubutu client_addr | rubutu abokin ciniki_hostname | rubutu client_port | lamba backend_start | timestamp tare da yankin lokaci xact_start | timestamp tare da yankin lokaci query_start | timestamp tare da yankin lokaci state_change | timestamp tare da yankin lokaci wait_event_type | text wait_event | yanayin rubutu | rubutu backend_xid | xid backend_xmin | xid top_level_query | tambayar rubutu | text queryid | bigint backend_type | rubutu                     

Babu wani fakitin da aka shirya don shigarwa tukuna. Ana ba da shawarar zazzage tushen kuma tattara ɗakin karatu da kanku. Da farko kuna buƙatar shigar da kunshin “devel” don uwar garken ku kuma saita hanya zuwa pg_config a cikin madaidaicin PATH. Muna tattara:

cd pgsentinel/src
yi
yi shigar

Ƙara sigogi zuwa postgres.conf:

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

# adadin rikodin kwanan nan da aka riƙe a ƙwaƙwalwar ajiya
pgsentinel_ash.max_entries = 10000

Sake kunna PostgreSQL kuma ƙirƙirar tsawo:

ƙirƙirar pgsentinel tsawo;

Bayanan da aka tara suna ba mu damar amsa tambayoyi kamar:

• Wadanne zaman jira kuka fi ciyarwa akai?
• Wadanne zaman ne suka fi aiki?
• Wadanne buƙatun ne suka fi aiki?

Kuna iya, ba shakka, samun amsoshin waɗannan tambayoyin ta amfani da tambayoyin SQL, amma ya fi dacewa don ganin wannan a gani akan jadawali ta hanyar nuna tazarar lokaci na sha'awa tare da linzamin kwamfuta. Kuna iya yin wannan tare da shirin kyauta PASH-Mai duba (zaku iya sauke binaries da aka tattara a cikin sashin sake).

Lokacin farawa, PASH-Viewer (farawa daga sigar 0.4.0) yana bincika kasancewar pg_active_session_history view kuma idan akwai, yana loda dukkan tarihin da aka tara daga gare shi kuma ya ci gaba da karanta sabbin bayanai masu shigowa, yana sabunta jadawali kowane sakan 15.

source: www.habr.com