{"id":38073,"date":"2019-10-31T22:21:32","date_gmt":"2019-10-31T19:21:32","guid":{"rendered":"https:\/\/prohoster.info\/blog\/istoriya-aktivnyh-sessij-v-postgresql-novoe-rasshirenie-pgsentinel\/"},"modified":"2019-10-31T22:21:32","modified_gmt":"2019-10-31T19:21:32","slug":"istoriya-aktivnyh-sessij-v-postgresql-novoe-rasshirenie-pgsentinel","status":"publish","type":"post","link":"https:\/\/prohoster.info\/hu\/blog\/administrirovanie\/istoriya-aktivnyh-sessij-v-postgresql-novoe-rasshirenie-pgsentinel","title":{"rendered":"Akt\u00edv munkamenetek t\u00f6rt\u00e9nete PostgreSQL-ben \u2014 \u00faj pgsentinel b\u0151v\u00edtm\u00e9ny","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

C\u00e9g pgsentinel<\/a><\/noindex> kiadta az azonos nev\u0171 pgsentinel b\u0151v\u00edtm\u00e9nyt (github k\u00e9szlet<\/a><\/noindex>), amely hozz\u00e1adja a PostgreSQL-hez a pg_active_session_history n\u00e9zetet \u2014 az akt\u00edv \u00fcl\u00e9sek t\u00f6rt\u00e9nete (hasonl\u00f3an az Oracle v$active_session_history-j\u00e1hoz).<\/p>\n

L\u00e9nyeg\u00e9ben ezek m\u00e1sodpercenk\u00e9nti pillanatfelv\u00e9telek a pg_stat_activity-r\u0151l, de fontos r\u00e9szletek vannak:<\/p>\n

    \n
  1. Minden felhalmozott inform\u00e1ci\u00f3 kiz\u00e1r\u00f3lag a mem\u00f3ri\u00e1ban t\u00e1rol\u00f3dik, a felhaszn\u00e1l\u00e1sra ker\u00fcl\u0151 mem\u00f3ria mennyis\u00e9ge pedig az utols\u00f3 t\u00e1rolt bejegyz\u00e9sek sz\u00e1m\u00e1val szab\u00e1lyozhat\u00f3.<\/li>\n
  2. Hozz\u00e1ad\u00f3dik a queryid mez\u0151 \u2014 az a queryid, amely a pg_stat_statements b\u0151v\u00edtm\u00e9nyb\u0151l sz\u00e1rmazik (el\u0151zetes telep\u00edt\u00e9s sz\u00fcks\u00e9ges).<\/li>\n
  3. Hozz\u00e1ad\u00f3dik a top_level_query mez\u0151 \u2014 a lek\u00e9rdez\u00e9s sz\u00f6vege, amelyb\u0151l a jelenlegi lek\u00e9rdez\u00e9s sz\u00e1rmazik (pl\/pgsql haszn\u00e1lata eset\u00e9n)<\/li>\n<\/ol>\n

    <\/a><\/noindex>
    \nA pg_active_session_history mez\u0151k teljes list\u00e1ja:<\/b><\/p>\n

    \n      Oszlop         |           T\u00edpus           \n------------------+--------------------------\n ash_time         | id\u0151b\u00e9lyeg z\u00f3n\u00e1val egy\u00fctt \n datid            | oid                      \n datname          | sz\u00f6veg                   \n pid              | eg\u00e9sz sz\u00e1m               \n usesysid         | oid                      \n usename          | sz\u00f6veg                   \n application_name | sz\u00f6veg                   \n client_addr      | sz\u00f6veg                   \n client_hostname  | sz\u00f6veg                   \n client_port      | eg\u00e9sz sz\u00e1m               \n backend_start    | id\u0151b\u00e9lyeg z\u00f3n\u00e1val egy\u00fctt \n xact_start       | id\u0151b\u00e9lyeg z\u00f3n\u00e1val egy\u00fctt \n query_start      | id\u0151b\u00e9lyeg z\u00f3n\u00e1val egy\u00fctt \n state_change     | id\u0151b\u00e9lyeg z\u00f3n\u00e1val egy\u00fctt \n wait_event_type  | sz\u00f6veg                   \n wait_event       | sz\u00f6veg                   \n state            | sz\u00f6veg                   \n backend_xid      | xid                      \n backend_xmin     | xid                      \n top_level_query  | sz\u00f6veg                   \n query            | sz\u00f6veg                   \n queryid          | bigint                   \n backend_type     | sz\u00f6veg                     \n<\/pre>\n
    Jelenleg nincs k\u00e9sz telep\u00edt\u0151csomag. Javasolt let\u00f6lteni a forr\u00e1sokat \u00e9s a k\u00f6nyvt\u00e1rat maga \u00f6ssze\u00e1ll\u00edtani. El\u0151zetesen telep\u00edteni kell a saj\u00e1t szerver sz\u00e1m\u00e1ra a \"devel\" csomagot, \u00e9s a PATH v\u00e1ltoz\u00f3ba be\u00edrni a pg_config el\u00e9rhet\u0151s\u00e9g\u00e9t. \u00d6ssze\u00e1ll\u00edtjuk:<\/p>\n
    cd pgsentinel\/src
    \nmake
    \nmake install<\/p><\/blockquote>\n
    \nHozz\u00e1adjuk a param\u00e9tereket a postgres.conf f\u00e1jlhoz:<\/p>\n
    shared_preload_libraries = 'pg_stat_statements,pgsentinel'
    \ntrack_activity_query_size = 2048
    \npg_stat_statements.track = all<\/p>\n
    # \u043a\u043e\u043b\u0438\u0447\u0435\u0441\u0442\u0432\u043e \u0443\u0434\u0435\u0440\u0436\u0438\u0432\u0430\u0435\u043c\u044b\u0445 \u0432 \u043f\u0430\u043c\u044f\u0442\u0438 \u043f\u043e\u0441\u043b\u0435\u0434\u043d\u0438\u0445 \u0437\u0430\u043f\u0438\u0441\u0435\u0439
    \npgsentinel_ash.max_entries = 10000<\/p><\/blockquote>\n
    \n\u00dajraind\u00edtjuk a PostgreSQL-t \u00e9s l\u00e9trehozzuk a b\u0151v\u00edtm\u00e9nyt:<\/p>\n
    create extension pgsentinel;<\/p><\/blockquote>\n
    \nA felhalmozott inform\u00e1ci\u00f3 lehet\u0151v\u00e9 teszi, hogy v\u00e1laszoljunk olyan k\u00e9rd\u00e9sekre, mint:<\/p>\n