--- title: Postgres query activity and logs in Host Details | daily.dev description: Last9's Discover Databases view now has an Activity tab for PostgreSQL that lists query samples, explain plans, and waiting and blocking sessions, with... canonical: https://daily.dev/posts/postgres-query-activity-and-logs-in-host-details-fha3a6ekc twitter:card: summary_large_image twitter:site: @dailydotdev og:type: website og:site_name: daily.dev og:title: Postgres query activity and logs in Host Details | daily.dev og:description: Last9's Discover Databases view now has an Activity tab for PostgreSQL that lists query samples, explain plans, and waiting and blocking sessions, with... og:url: https://daily.dev/posts/postgres-query-activity-and-logs-in-host-details-fha3a6ekc og:image: https://api.daily.dev/og/posts/Fha3a6Ekc.png og:image:alt: Postgres query activity and logs in Host Details og:image:width: 1200 og:image:height: 630 og:locale: en --- > ## Documentation Index > Fetch the complete documentation index at: https://daily.dev/llms.txt > Use this file to discover all available pages before exploring further. # Postgres query activity and logs in Host Details **[Last9](https://daily.dev/sources/last9)** · 4 min read · 0 upvotes · 0 comments ## Summary Last9's Discover Databases view now has an Activity tab for PostgreSQL that lists query samples, explain plans, and waiting and blocking sessions, with Blocking Only on by default. Host Details gains a Logs tab showing a host's Kubernetes node logs when a single node name is available. Dashboards get a 1h auto-refresh option and now save their chosen refresh interval. The changelog also fixes a bug where negative-threshold alert rules like 'expr < -16' were evaluated incorrectly and the Firing Alerts view failed with an error. ## Full article daily.dev links to this article rather than hosting it. Read it at the original source: ## Questions this post answers ### How can I see waiting and blocking sessions for a PostgreSQL database in Last9? Last9's Discover Databases view has an Activity tab under Queries for PostgreSQL databases that lists query samples, explain plans, and waiting and blocking sessions. The 'Blocking Only' filter is on by default, and selecting a row opens the waiting and blocking sessions, the plan, and recorded details. _Teams debugging Postgres lock contention can track observability tooling updates like this on daily.dev._ ### Why would an alert rule with a negative threshold like expr < -16 fail to fire correctly? In Last9, a rule with a negative threshold such as 'expr < -16' was evaluated as 'expr < 16', causing the Overview Firing Alerts block and the Alert Monitor to fail with 'Something went wrong' while such a rule was firing. This was a bug that has since been fixed. _Anyone tuning alert thresholds can follow fixes like this on daily.dev before they hit the same bug._ ## Similar posts on daily.dev - [Discover Databases, starting with Postgres](https://daily.dev/posts/discover-databases-starting-with-postgres-vudl6ia8e) · Last9 · 1 upvotes · 0 comments - [Postgres wait events, now in Query Insights](https://daily.dev/posts/postgres-wait-events-now-in-query-insights-sdbknr20z) · ClickHouse · 2 upvotes · 0 comments - [Dasha 1.8: index recommendations, I/O analysis, schema checks and log insights](https://daily.dev/posts/dasha-1-8-index-recommendations-i-o-analysis-schema-checks-and-log-insights-ugyubqr7o) · PostgreSQL · 0 upvotes · 0 comments - [Postgres Monitoring for SQL Server DBAs: Statistics and Logs 101](https://daily.dev/posts/postgres-monitoring-for-sql-server-dbas-statistics-and-logs-101-am6ptsgaz) · pganalyze · 2 upvotes · 0 comments --- Tags: [#devops](https://daily.dev/tags/devops), [#kubernetes](https://daily.dev/tags/kubernetes), [#postgresql](https://daily.dev/tags/postgresql), [#observability](https://daily.dev/tags/observability) [View this post on daily.dev](https://daily.dev/posts/postgres-query-activity-and-logs-in-host-details-fha3a6ekc) ```json {"@context":"https://schema.org","@graph":[{"@type":"Organization","@id":"https://daily.dev/#organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180},"sameAs":["https://twitter.com/dailydotdev","https://github.com/dailydotdev","https://www.linkedin.com/company/daily-dev-ltd"]},{"@type":"WebSite","@id":"https://daily.dev/#website","url":"https://daily.dev","name":"daily.dev","publisher":{"@id":"https://daily.dev/#organization"},"potentialAction":{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https://daily.dev/search?q={search_term_string}"},"query-input":"required name=search_term_string"}}]} {"@context":"https://schema.org","@type":"TechArticle","headline":"Postgres query activity and logs in Host Details","url":"https://daily.dev/posts/postgres-query-activity-and-logs-in-host-details-fha3a6ekc","mainEntityOfPage":{"@type":"WebPage","@id":"https://daily.dev/posts/postgres-query-activity-and-logs-in-host-details-fha3a6ekc"},"datePublished":"2026-10-27T11:10:13.030Z","dateModified":"2026-10-27T11:10:38.335Z","description":"Last9's Discover Databases view now has an Activity tab for PostgreSQL that lists query samples, explain plans, and waiting and blocking sessions, with...","image":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/638bfae469216b95a8655ffbc04389fe?_a=AQAEuop","thumbnailUrl":"https://media.daily.dev/image/upload/f_auto,q_auto/v1/posts/638bfae469216b95a8655ffbc04389fe?_a=AQAEuop","isAccessibleForFree":true,"articleSection":"Last9","inLanguage":"en","publisher":{"@type":"Organization","name":"daily.dev","url":"https://daily.dev","logo":{"@type":"ImageObject","url":"https://daily.dev/apple-touch-icon.png","width":180,"height":180}},"author":{"@type":"Organization","name":"Last9","logo":"https://media.daily.dev/image/upload/t_logo,f_auto/v1/logos/0542036d401f4cb1885680f1984fb880","url":"https://daily.dev/sources/last9"},"commentCount":0,"discussionUrl":"https://daily.dev/posts/postgres-query-activity-and-logs-in-host-details-fha3a6ekc","interactionStatistic":[{"@type":"InteractionCounter","interactionType":{"@type":"LikeAction"},"userInteractionCount":0},{"@type":"InteractionCounter","interactionType":{"@type":"CommentAction"},"userInteractionCount":0}],"keywords":"devops,kubernetes,postgresql,observability","timeRequired":"PT4M"} {"@context":"https://schema.org","@type":"BreadcrumbList","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https://daily.dev"},{"@type":"ListItem","position":2,"name":"Last9","item":"https://daily.dev/sources/last9"},{"@type":"ListItem","position":3,"name":"Postgres query activity and logs in Host Details"}]} {"@context":"https://schema.org","@type":"FAQPage","@id":"https://daily.dev/posts/postgres-query-activity-and-logs-in-host-details-fha3a6ekc#faq","mainEntity":[{"@type":"Question","name":"How can I see waiting and blocking sessions for a PostgreSQL database in Last9?","acceptedAnswer":{"@type":"Answer","text":"Last9's Discover Databases view has an Activity tab under Queries for PostgreSQL databases that lists query samples, explain plans, and waiting and blocking sessions. The 'Blocking Only' filter is on by default, and selecting a row opens the waiting and blocking sessions, the plan, and recorded details. Teams debugging Postgres lock contention can track observability tooling updates like this on daily.dev."}},{"@type":"Question","name":"Why would an alert rule with a negative threshold like expr \u003c -16 fail to fire correctly?","acceptedAnswer":{"@type":"Answer","text":"In Last9, a rule with a negative threshold such as 'expr \u003c -16' was evaluated as 'expr \u003c 16', causing the Overview Firing Alerts block and the Alert Monitor to fail with 'Something went wrong' while such a rule was firing. This was a bug that has since been fixed. Anyone tuning alert thresholds can follow fixes like this on daily.dev before they hit the same bug."}}]} ```