rendered paste bodyotel-collector | 2026-10-09T06:20:23.084Z error postgresqlreceiver@v0.160.0/scraper.go:509 failed to explain query {"resource": {"service.instance.id": "cc2a6c61-7530-4111-9fff-c733cbc27bb5", "service.name": "otelcol-contrib", "service.version": "0.160.0"}, "otelcol.component.id": "postgresql", "otelcol.component.kind": "receiver", "otelcol.signal": "logs", "query": "SELECT\n COALESCE(sa.datname, $1) AS datname,\n COALESCE(sa.usename, $2) AS usename,\n COALESCE(sa.client_addr::TEXT, $3) AS client_addr,\n COALESCE(sa.client_hostname, $4) AS client_hostname,\n COALESCE(sa.client_port::TEXT, $5) AS client_port,\n COALESCE(sa.query_start::TEXT, $6) AS query_start,\n COALESCE(sa.wait_event_type, $7) AS wait_event_type,\n COALESCE(sa.wait_event, $8) AS wait_event,\n COALESCE(sa.query_id::TEXT, $9) AS query_id,\n COALESCE(sa.pid::TEXT, $10) AS pid,\n COALESCE(sa.application_name::TEXT, $11) AS application_name,\n EXTRACT($12 FROM sa.query_start) AS _query_start_timestamp,\n sa.state,\n sa.query,\n CASE\n WHEN sa.state = $13 THEN\n EXTRACT($14 FROM (clock_timestamp() - sa.query_start)) * $15\n WHEN sa.state IN ($16 /*, ... */)\n AND sa.state_change IS NOT NULL THEN\n EXTRACT($17 FROM (sa.state_change - sa.query_start)) * $18\n ELSE\n $19\n END AS duration_ms,\n -- Blocking info\n COALESCE(pg_blocking_pids(sa.pid)::TEXT, $20) AS blocking_pids,\n CASE WHEN bl.waitstart IS NOT NULL\n THEN to_char(bl.waitstart AT TIME ZONE $21, $22)\n ELSE $23 END AS blocking_start_time,\n COALESCE(EXTRACT($24 FROM (clock_timestamp() - bl.waitstart))::BIGINT, $25) AS blocking_wait_duration,\n COALESCE(bl.mode, $26) AS blocking_lock_mode,\n COALESCE(bl.locktype, $27) AS blocking_lock_type,\n COALESCE(c.relname, $28) AS blocking_lock_relation,\n CASE WHEN sa.xact_start IS NOT NULL\n THEN to_char(sa.xact_start AT TIME ZONE $29, $30)\n ELSE $31 END AS blocking_transaction_start\nFROM pg_stat_activity sa\nLEFT JOIN LATERAL (\n SELECT mode, locktype, relation, waitstart\n FROM pg_locks\n WHERE pid = sa.pid AND NOT granted\n ORDER BY waitstart ASC NULLS LAST\n LIMIT $32\n) bl ON $33\nLEFT JOIN pg_class c\n ON c.oid = bl.relation\nWHERE\n coalesce(\n TRIM(sa.query),\n $34\n ) != $35\n \n AND sa.pid != pg_backend_pid()\n \n AND sa.query_start IS NOT NULL\n AND NOT (\n \n sa.query_start < TO_TIMESTAMP($36)\n AND sa.state = $37\n -- Keep idle-in-transaction sessions that are blocking others\n AND sa.pid NOT IN (\n SELECT unnest(pg_blocking_pids(pid))\n FROM pg_stat_activity\n WHERE cardinality(pg_blocking_pids(pid)) > $38\n )\n )\nLIMIT $39", "error": "pq: syntax error at or near \"$12\" at position 13:13 (42601)"}otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.(*postgreSQLScraper).collectTopQueryotel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/scraper.go:509otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.(*postgreSQLScraper).scrapeTopQueryotel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/scraper.go:304otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.createLogsReceiver.func3otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/factory.go:150otel-collector | go.opentelemetry.io/collector/scraper.ScrapeLogsFunc.ScrapeLogsotel-collector | go.opentelemetry.io/collector/scraper@v0.160.0/logs.go:25otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper.wrapObsLogs.func1otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/obs_logs.go:49otel-collector | go.opentelemetry.io/collector/scraper.ScrapeLogsFunc.ScrapeLogsotel-collector | go.opentelemetry.io/collector/scraper@v0.160.0/logs.go:25otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper.scrapeLogsotel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/controller.go:145otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper.NewLogsController.func1otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/controller.go:109otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper/internal/controller.(*Controller[...]).startScraping.func1otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/internal/controller/controller.go:122otel-collector | sync.(*WaitGroup).Go.func1otel-collector | sync/waitgroup.go:258otel-collector | 2026-10-09T06:20:23.093Z error postgresqlreceiver@v0.160.0/client.go:221 failed to explain statement {"resource": {"service.instance.id": "cc2a6c61-7530-4111-9fff-c733cbc27bb5", "service.name": "otelcol-contrib", "service.version": "0.160.0"}, "otelcol.component.id": "postgresql", "otelcol.component.kind": "receiver", "otelcol.signal": "logs", "error": "pq: permission denied for table products (42501)"}otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.(*postgreSQLClient).explainQueryotel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/client.go:221otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.(*postgreSQLScraper).collectTopQueryotel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/scraper.go:507otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.(*postgreSQLScraper).scrapeTopQueryotel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/scraper.go:304otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.createLogsReceiver.func3otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/factory.go:150otel-collector | go.opentelemetry.io/collector/scraper.ScrapeLogsFunc.ScrapeLogsotel-collector | go.opentelemetry.io/collector/scraper@v0.160.0/logs.go:25otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper.wrapObsLogs.func1otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/obs_logs.go:49otel-collector | go.opentelemetry.io/collector/scraper.ScrapeLogsFunc.ScrapeLogsotel-collector | go.opentelemetry.io/collector/scraper@v0.160.0/logs.go:25otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper.scrapeLogsotel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/controller.go:145otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper.NewLogsController.func1otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/controller.go:109otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper/internal/controller.(*Controller[...]).startScraping.func1otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/internal/controller/controller.go:122otel-collector | sync.(*WaitGroup).Go.func1otel-collector | sync/waitgroup.go:258otel-collector | 2026-10-09T06:20:23.094Z error postgresqlreceiver@v0.160.0/scraper.go:509 failed to explain query {"resource": {"service.instance.id": "cc2a6c61-7530-4111-9fff-c733cbc27bb5", "service.name": "otelcol-contrib", "service.version": "0.160.0"}, "otelcol.component.id": "postgresql", "otelcol.component.kind": "receiver", "otelcol.signal": "logs", "query": "INSERT INTO catalog.products (id, name, description, picture, price_currency_code, price_units, price_nanos, categories)\nVALUES\n ($1, $2, $3, $4, $5, $6, $7, $8),\n ($9, $10, $11, $12, $13, $14, $15, $16),\n ($17, $18, $19, $20, $21, $22, $23, $24),\n ($25, $26, $27, $28, $29, $30, $31, $32),\n ($33, $34, $35, $36, $37, $38, $39, $40),\n ($41, $42, $43, $44, $45, $46, $47, $48),\n ($49, $50, $51, $52, $53, $54, $55, $56),\n ($57, $58, $59, $60, $61, $62, $63, $64),\n ($65, $66, $67, $68, $69, $70, $71, $72),\n ($73, $74, $75, $76, $77, $78, $79, $80)", "error": "pq: permission denied for table products (42501)"}otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.(*postgreSQLScraper).collectTopQueryotel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/scraper.go:509otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.(*postgreSQLScraper).scrapeTopQueryotel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/scraper.go:304otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.createLogsReceiver.func3otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/factory.go:150otel-collector | go.opentelemetry.io/collector/scraper.ScrapeLogsFunc.ScrapeLogsotel-collector | go.opentelemetry.io/collector/scraper@v0.160.0/logs.go:25otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper.wrapObsLogs.func1otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/obs_logs.go:49otel-collector | go.opentelemetry.io/collector/scraper.ScrapeLogsFunc.ScrapeLogsotel-collector | go.opentelemetry.io/collector/scraper@v0.160.0/logs.go:25otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper.scrapeLogsotel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/controller.go:145otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper.NewLogsController.func1otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/controller.go:109otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper/internal/controller.(*Controller[...]).startScraping.func1otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/internal/controller/controller.go:122otel-collector | sync.(*WaitGroup).Go.func1otel-collector | sync/waitgroup.go:258