

| parse field = arn ":assumed-role/*" as user nodrop | json field = responseElements "dBClusterIdentifier", "engine", "engineMode" as res_dBClusterIdentifier, res_engine, res_engineMode nodrop | json field = requestParameters "dBClusterIdentifier", "engine", "engineMode" as req_dBClusterIdentifier, req_engine, req_engineMode nodrop | json field = userIdentity "" as mfaAuthenticated nodrop | json field = userIdentity "type", "principalId", "arn", "userName", "accountId" nodrop | json "userIdentity", "eventSource", "eventName", "awsRegion", "sourceIPAddress", "userAgent", "eventType", "recipientAccountId", "requestParameters", "responseElements", "requestID", "errorCode", "errorMessage" nodrop ( _sourceCategory = * cloudtrail * or _sourceCategory = * AWS_EAGLE * ) "\"eventSource\":\"\"" ( "\"engine\":\"aurora-postgresql\"" ) "iAMDatabaseAuthenticationEnabled" : false , "dbClusterResourceId" : "cluster-LXLBREEIXOAMLSUUDXVKXFVIDA" , "dBClusterParameterGroupStatus" : "in-sync" ,

"dBInstanceIdentifier" : "psqldb968nitin02" , "earliestRestorableTime" : "2:17:31 PM" , "dBSubnetGroup" : "default-vpc-b81fc4d7" , "dBClusterParameterGroup" : "rora-postgresql9.6" , "finalDBSnapshotIdentifier" : "psqldb968nitin02-final-snapshot" "dBClusterIdentifier" : "nitinpsql968cluster01" , The following is an example of an AWS Cloud Trail log. The Sumo Logic App for Aurora PostgreSQL ULM uses the following logs and metrics:īelow are example logs and metrics collected from your Aurora PostgreSQL database as well as example queries. This guide provides an overview of the Aurora PostgreSQL ULM App pre-defined queries and dashboards, as well as instructions for collecting logs and metrics from Aurora PostgreSQL, and installing the App. For more information, see the Amazon Aurora PostgreSQL The metrics allow you to monitor database resource utilization and throughput performance.Īmazon Aurora PostgreSQL is a relational database service built for the cloud. The logs enable you to monitor database activity, user activity, incoming connections, query execution time, and errors. The Sumo Logic App for Aurora PostgreSQL ULM includes predefined searches and dashboards that allow you to monitor logs and metrics for the database. With Cloudtrail Logs, the app allows you to identify user, client host and client locations being used to configure Aurora PostgreSQL infrastructure.
Amazon aws postgresql images free#
The app allows you to monitor the number of connections made, CPU utilization, free memory, network utilization, volume read / write IOPS, disk queue depth, replica lags, latency, throughput and other resource utilization details. The Sumo Logic App for Aurora PostgreSQL uses unified logs and metrics (ULM) to monitor your Aurora PostgreSQL database.
