Google Logs Explorer Changes PostgreSQL Metrics Cloud SQL

For PostgreSQL-compatible workloads, Google Cloud offers multiple options: the Spanner, AlloyDB for PostgreSQL, and Cloud SQL for PostgreSQL

[{"selector":"#anim-2ea50911-38f6-41fe-9095-7c9ca1347d13 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-35.21169345865223%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] [{"selector":"#anim-4012e710-a7fa-4d79-86be-32552850cf2a","keyframes":{"transform":["translate3d(-115.2381%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-150305be-a1dc-4f27-8047-a974d9cd7b48","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-97c105fc-0542-4a86-94ad-6f452a099f99","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}]

you can use Google Logs Explorer to monitor and publish a new statistic for any entries that are published into postgres

[{"selector":"#anim-639a4b85-6173-4374-a83a-0e00f38f9f04 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-19.1150699060494%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] [{"selector":"#anim-748e217e-ec36-4ab4-a906-d7b02021afa7","keyframes":{"transform":["translate3d(-115.2381%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-91e4061d-7f0f-40e9-aae9-943b8b41f23d","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-61487c08-66ca-4825-b04f-549c17db3b82","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}]

The Google Cloud CLI and the Logging API can also be used to read log data

[{"selector":"#anim-418a827b-1cda-4ece-b885-347940106821 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-37.56491090377284%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] [{"selector":"#anim-2921fd4d-2398-4fb0-bf22-b33beeaf5c8e","keyframes":{"transform":["rotate(-540deg) scale(0.1)","none"],"opacity":[0,1]},"delay":0,"duration":1000,"fill":"both","iterations":1}]

You can see log entries, parse and analyse them, and set query parameters using the Google Logs Explorer interface

[{"selector":"#anim-0bec6878-8615-4597-b5a3-2f04f060ee56 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate(1.0658141036401503e-14%, 0%) scale(1.5)","translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"easing":"cubic-bezier(.3,0,.55,1)","fill":"forwards"}] [{"selector":"#anim-0f47a444-0ca5-4f56-b10b-3f472fa650d2","keyframes":{"transform":["translate3d(-115.2381%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-a9658946-74d4-48b0-804f-c4c6813fb355","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-24aa3bce-df69-4149-bd2d-479154fb81e9","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}]

Find log entries that match your search terms or phrases using the search-text field

[{"selector":"#anim-d79ee6f7-b622-4a48-b671-7c972b2ae30c [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-35.21169345865223%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] [{"selector":"#anim-64f65de2-9274-4423-b5cb-ddbb2e7b1859","keyframes":{"transform":["translate3d(115.55555%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-2d7819f0-860b-4ccb-934a-f0f670aa4431","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-26d8bd05-09f2-4f3a-abcd-c3966e903e9a","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}]

Access queries you have saved and queries shared with you by other Google Cloud project participants

[{"selector":"#anim-5db76c8f-b0b9-4abe-9f7d-068740c632f2 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-34.103260773104424%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] [{"selector":"#anim-fd93d843-907a-409e-b8df-05d3068d5ef6","keyframes":{"transform":["translate3d(-115.87301%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-f8d72b00-5f07-4a14-a22c-4189f7b28065","keyframes":{"opacity":[0,1]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"both"}] [{"selector":"#anim-38757a89-91b4-4b14-b138-9c2743d886dc","keyframes":{"transform":["scale(0.15)","scale(1)"]},"delay":0,"duration":600,"easing":"cubic-bezier(0.4, 0.4, 0.0, 1)","fill":"forwards"}]

Adjust the Google Logs Explorer page layout to display or conceal the Histogram pane

[{"selector":"#anim-79a2c6b1-8294-4588-8a82-e93f8157198e [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-35.21169345865223%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] [{"selector":"#anim-d1e79b53-5ed2-489a-b740-b417cd7cb6a9","keyframes":{"transform":["translate3d(-115.87301%, 0px, 0)","translate3d(0px, 0px, 0)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .8, 1)","fill":"both"}] [{"selector":"#anim-2d78a3ea-08b3-494e-8333-d48c23e88c96","keyframes":{"transform":["rotateZ(-180deg)","rotateZ(0deg)"]},"delay":0,"duration":1000,"easing":"cubic-bezier(.2, 0, .5, 1)","fill":"forwards"}]

This increases the amount of horizontal space in the log entry, allowing you to view more information For more details govindhtech.com

[{"selector":"#anim-4cb3f7f2-caaa-4835-8038-ff4844623cc6 [data-leaf-element=\"true\"]","keyframes":{"transform":["translate3d(-34.83455873150611%, 0, 0) translate(-25%, 0%) scale(1.5)","translate3d(0%, 0, 0) translate(0%, 0%) scale(1)"]},"delay":0,"duration":2000,"fill":"forwards"}] [{"selector":"#anim-e0449c56-09c8-4ddc-82df-047dad5d690c","keyframes":[{"offset":0,"transform":"translate3d(0, -143.27136%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.29,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.45,"transform":"translate3d(0, -40.287906432%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.61,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.71,"transform":"translate3d(0, -13.696742016%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.8,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.85,"transform":"translate3d(0, -5.143441824%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":0.92,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"},{"offset":0.96,"transform":"translate3d(0, -2.2350332159999997%, 0)","easing":"cubic-bezier(.5, 0, 1, 1)"},{"offset":1,"transform":"translate3d(0, 0%, 0)","easing":"cubic-bezier(0, 0, .5, 1)"}],"delay":0,"duration":600,"fill":"both"}]