PostgreSQL nquag kev sib tham keeb kwm - tshiab pgsentinel txuas ntxiv

Ruaj pgsentinel ua tso tawm pgsentinel txuas ntxiv ntawm tib lub npe (github repository), uas ntxiv qhov pg_active_session_history saib rau PostgreSQL - keeb kwm ntawm kev sib tham nquag (zoo ib yam li Oracle's v$active_session_history).

Qhov tseem ceeb, cov no tsuas yog ob-los-thib ob snapshots los ntawm pg_stat_activity, tab sis muaj cov ntsiab lus tseem ceeb:

1. Tag nrho cov ntaub ntawv khaws tseg tsuas yog khaws cia hauv RAM, thiab kev siv lub cim xeeb yog tswj hwm los ntawm tus lej ntawm cov ntaub ntawv khaws tseg kawg.
2. Cov queryid teb yog ntxiv - tib queryid los ntawm pg_stat_statements extension (yuav tsum tau ua ntej-installation).
3. Sab saum toj_level_query teb yog ntxiv - cov ntawv nyeem ntawm cov lus nug los ntawm cov lus nug tam sim no hu ua (yog siv pl / pgsql)

Cov npe tag nrho ntawm pg_active_session_history teb:

      Kem | Hom -------------------+-------------------------------- ash_time | timestamp nrog lub sij hawm zone datid | oid datename | ntawv pid | integer sivysid | oid npe | ntawv thov_name | text client_addr | text client_hostname | text client_port | integer backend_start | timestamp with time zone xact_start | timestamp nrog lub sij hawm query_start | timestamp nrog lub sij hawm zone state_change | timestamp with time zone wait_event_type | ntawv wait_event | ntawv lub xeev | ntawv backend_xid | xid backend_xmin | xid top_level_query | lus nug | ntawv queryid | bigint backend_type | ntawv nyeem                     

Tseem tsis tau npaj txhij-ua pob rau installation tsis tau. Nws raug nquahu kom rub tawm cov peev txheej thiab sib sau cov tsev qiv ntawv koj tus kheej. Koj thawj zaug yuav tsum tau nruab lub pob "devel" rau koj lub server thiab teeb tsa txoj hauv kev rau pg_config hauv PATH hloov pauv. Peb sau:

cd pgsentinel/src
ua
ua nruab

Ntxiv parameters rau postgres.conf:

shared_preload_libraries = 'pg_stat_statements, pgsentinel'
track_activity_query_size = 2048
pg_stat_statements.track = tag nrho

# tus naj npawb ntawm cov ntaub ntawv tsis ntev los no tuav hauv nco
pgsentinel_ash.max_entries = 10000

Rov pib PostgreSQL thiab tsim qhov txuas ntxiv:

tsim extension pgsentinel;

Cov ntaub ntawv khaws tseg cia peb teb cov lus nug xws li:

• Cov kev tos twg koj tau siv sijhawm ntau tshaj plaws?
• Cov kev sib tham twg yog qhov nquag tshaj plaws?
• Cov kev thov twg yog qhov nquag tshaj plaws?

Koj tuaj yeem tau txais cov lus teb rau cov lus nug no siv SQL cov lus nug, tab sis nws yooj yim dua kom pom qhov pom ntawm daim duab los ntawm kev qhia txog lub sijhawm ntawm kev txaus siab nrog tus nas. Koj tuaj yeem ua qhov no nrog ib qho program pub dawb PASH-Viewer (koj tuaj yeem rub tawm cov ntawv sau binaries hauv ntu tawm).

Thaum pib, PASH-Viewer (pib los ntawm version 0.4.0) kuaj xyuas qhov muaj pg_active_session_history saib thiab yog tias nws muaj, nws thauj tag nrho cov keeb kwm sau los ntawm nws thiab txuas ntxiv nyeem cov ntaub ntawv tuaj tshiab, hloov kho cov duab txhua 15 vib nas this.

Tau qhov twg los: www.hab.com