- 필수 기능
- 시작하기
- Glossary
- 표준 속성
- Guides
- Agent
- 통합
- 개방형텔레메트리
- 개발자
- API
- Datadog Mobile App
- CoScreen
- Cloudcraft
- 앱 내
- 서비스 관리
- 인프라스트럭처
- 애플리케이션 성능
- APM
- Continuous Profiler
- 스팬 시각화
- 데이터 스트림 모니터링
- 데이터 작업 모니터링
- 디지털 경험
- 소프트웨어 제공
- 보안
- AI Observability
- 로그 관리
- 관리
PostgreSQL uses logging to track the time it takes to complete an SQL query.
The “log_duration” parameter allows recording the duration of each completed PostgreSQL statement. Logging this attribute enables administrators to monitor for potential issues in the database.
Complete steps in Microsoft’s Customize server configuration parameters for Azure Database for PostgreSQL documentation to enable log_duration in Server Parameters.
Get a list of your PostgreSQL servers by running the following in Azure Powershell:
az postgres server list
--output table
--query '[*].{name:name, resourceGroup:resourceGroup}'
Run the ‘postgres server configuration set’ command:
az postgres server configuration set
--server-name "INSERT-SERVER-NAME-HERE-FROM-STEP-2"
--resource-group "cloud-shell-storage-westeurope"
--name log_duration
--value on
Repeat steps two and three for each server that is not configured correctly.