:hedgehog: PostHog is the leading platform for building self-driving products. Our developer tools – AI observability, analytics, session replay, flags, experiments, error tracking, logs, and more – capture all the context agents need to diagnose problems, uncover opportunities, and ship fixes. Steer it all from Slack, web, desktop, or the MCP.
Python ab-testingai-analyticsanalyticscdpdata-warehouseexperimentsfeature-flagsjavascriptproduct-analyticspythonreactsession-replaysurveystypescriptweb-analytics
from functools import cached_property
from posthog.schema import CachedLogsQueryResponse, LogsQuery
from posthog.hogql import ast
from posthog.hogql.constants import HogQLGlobalSettings
from posthog.hogql.parser import parse_select
from posthog.hogql.query import execute_hogql_query
from posthog.clickhouse.client.connection import Workload
from posthog.hogql_queries.query_runner import AnalyticsQueryRunner
from products.logs.backend.logs_query_runner import (
LogsQueryResponse,
LogsQueryRunnerMixin,
fail_fast_aggregate_settings,
)
class CountQueryRunner(AnalyticsQueryRunner[LogsQueryResponse], LogsQueryRunnerMixin):
"""Returns a scalar count of log entries matching the given filters."""
query: LogsQuery
cached_response: CachedLogsQueryResponse
@cached_property
def settings(self) -> HogQLGlobalSettings:
return fail_fast_aggregate_settings()
def _calculate(self) -> LogsQueryResponse:
response = execute_hogql_query(
query_type="LogsQuery",
query=self.to_query(),
modifiers=self.modifiers,
team=self.team,
workload=Workload.LOGS,
timings=self.timings,
limit_context=self.limit_context,
settings=self.settings,
)
count = response.results[0][0] if response.results else 0
return LogsQueryResponse(results={"count": count})
def to_query(self) -> ast.SelectQuery:
query = parse_select(
"SELECT count() FROM logs WHERE {where}",
placeholders={"where": self.where_with_timestamp_bounds()},
)
assert isinstance(query, ast.SelectQuery)
return query