{"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":"Historia e seancave aktive n\u00eb PostgreSQL \u2014 nj\u00eb zgjatje e re pgsentinel","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"

Kompania pgsentinel<\/a><\/noindex> l\u00ebshoi nj\u00eb zgjatje me t\u00eb nj\u00ebjtin em\u00ebr pgsentinel (repository github<\/a><\/noindex>), e cila shton n\u00eb PostgreSQL pamjen pg_active_session_history \u2014 historin\u00eb e seancave aktive (si\u00e7 \u00ebsht\u00eb n\u00eb v$active_session_history e Oracle).<\/p>\n

N\u00eb thelb, k\u00ebto jan\u00eb thjesht fotografi \u00e7do sekond\u00eb nga pg_stat_activity, por ka disa pika t\u00eb r\u00ebnd\u00ebsishme:<\/p>\n

    \n
  1. I gjith\u00eb informacioni i akumuluar ruhet vet\u00ebm n\u00eb memorien e p\u00ebrkohshme, dhe sasia e memories s\u00eb konsumuar rregullohet nga numri i rekordeve t\u00eb fundit t\u00eb ruajtura.<\/li>\n
  2. Shtohet fusha queryid \u2014 ai queryid nga zgjatja pg_stat_statements (e cila k\u00ebrkon instalimin paraprak).<\/li>\n
  3. Shtohet fusha top_level_query \u2014 teksti i k\u00ebrkes\u00ebs nga e cila u thirr k\u00ebrkesa aktuale (n\u00eb rastin e p\u00ebrdorimit t\u00eb pl\/pgsql)<\/li>\n<\/ol>\n

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

    \n      Kolona      |           Lloji           \n------------------+--------------------------\n ash_time         | timestamp me kohen zon\u00eb \n datid            | oid                      \n datname          | tekst                     \n pid              | integer                  \n usesysid         | oid                      \n usename          | tekst                     \n application_name | tekst                     \n client_addr      | tekst                     \n client_hostname  | tekst                     \n client_port      | integer                  \n backend_start    | timestamp me kohen zon\u00eb \n xact_start       | timestamp me kohen zon\u00eb \n query_start      | timestamp me kohen zon\u00eb \n state_change     | timestamp me kohen zon\u00eb \n wait_event_type  | tekst                     \n wait_event       | tekst                     \n state            | tekst                     \n backend_xid      | xid                      \n backend_xmin     | xid                      \n top_level_query  | tekst                     \n query            | tekst                     \n queryid          | bigint                   \n backend_type     | tekst                     \n<\/pre>\n
    Nuk ka nj\u00eb paket\u00eb t\u00eb gatshme p\u00ebr instalim. Propozohet q\u00eb t\u00eb shkarkohet burimi dhe t\u00eb mblidhet biblioteka vet\u00eb. N\u00eb fillim k\u00ebrkohet t\u00eb instaloni paket\u00ebn \"devel\" p\u00ebr serverin tuaj dhe t\u00eb regjistroni rrug\u00ebn n\u00eb variabl\u00ebn PATH deri te pg_config. Mblidhni:<\/p>\n
    cd pgsentinel\/src
    \nmake
    \nmake install<\/p><\/blockquote>\n
    \nShto 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 akumuluar lejon t\u00eb p\u00ebrgjigjeni n\u00eb pyetje si:<\/p>\n