{"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\/sq\/blog\/administrirovanie\/istoriya-aktivnyh-sessij-v-postgresql-novoe-rasshirenie-pgsentinel","title":{"rendered":"Historiku i sesioneve aktive n\u00eb PostgreSQL \u2014 zgjerimi i ri pgsentinel","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Kompania pgsentinel<\/a><\/noindex> ka publikuar zgjerimin me t\u00eb nj\u00ebjtin em\u00ebr pgsentinel (depoja n\u00eb github<\/a><\/noindex>), i cili shton n\u00eb PostgreSQL pamjen pg_active_session_history \u2014 historikun e sesioneve aktive (ngjash\u00ebm me v$active_session_history t\u00eb Oracle).<\/p>\n

N\u00eb thelb, b\u00ebhet fjal\u00eb thjesht p\u00ebr fotografi t\u00eb pg_stat_activity t\u00eb marra \u00e7do sekond\u00eb, por ka disa pika t\u00eb r\u00ebnd\u00ebsishme:<\/p>\n

    \n
  1. I gjith\u00eb informacioni i grumbulluar ruhet vet\u00ebm n\u00eb memorien operative, nd\u00ebrsa sasia e memories s\u00eb p\u00ebrdorur rregullohet nga numri i regjistrimeve t\u00eb fundit q\u00eb mbahen.<\/li>\n
  2. Shtohet fusha queryid \u2014 pik\u00ebrisht ai queryid nga zgjerimi pg_stat_statements (k\u00ebrkohet instalim paraprak).<\/li>\n
  3. Shtohet fusha top_level_query \u2014 teksti i pyetjes nga e cila \u00ebsht\u00eb thirrur pyetja aktuale (n\u00eb rast t\u00eb p\u00ebrdorimit t\u00eb pl\/pgsql)<\/li>\n<\/ol>\n

    <\/a><\/noindex>
    \nLista e plot\u00eb e fushave t\u00eb pg_active_session_history:<\/b><\/p>\n

    \n      Column      |           Type           \n------------------+--------------------------\n ash_time         | timestamp with time zone \n datid            | oid                      \n datname          | text                     \n pid              | integer                  \n usesysid         | oid                      \n usename          | text                     \n application_name | text                     \n client_addr      | text                     \n client_hostname  | text                     \n client_port      | integer                  \n backend_start    | timestamp with time zone \n xact_start       | timestamp with time zone \n query_start      | timestamp with time zone \n state_change     | timestamp with time zone \n wait_event_type  | text                     \n wait_event       | text                     \n state            | text                     \n backend_xid      | xid                      \n backend_xmin     | xid                      \n top_level_query  | text                     \n query            | text                     \n queryid          | bigint                   \n backend_type     | text                     \n<\/pre>\n
    Ende nuk ka nj\u00eb paket\u00eb t\u00eb gatshme p\u00ebr instalim. Sugjerohet t\u00eb shkarkoni kodin burimor dhe ta kompiloni vet\u00eb bibliotek\u00ebn. Paraprakisht duhet t\u00eb instaloni paket\u00ebn \u00abdevel\u00bb p\u00ebr serverin tuaj dhe t\u00eb shtoni n\u00eb variabl\u00ebn PATH rrug\u00ebn drejt pg_config. Kompilimi:<\/p>\n
    cd pgsentinel\/src
    \nmake
    \nmake install<\/p><\/blockquote>\n
    \nShtojm\u00eb parametrat n\u00eb postgres.conf:<\/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
    \nRinisni PostgreSQL dhe krijoni zgjerimin:<\/p>\n
    create extension pgsentinel;<\/p><\/blockquote>\n
    \nInformacioni i grumbulluar ju lejon t\u2019u p\u00ebrgjigjeni pyetjeve si k\u00ebto:<\/p>\n