skip to main content
paste
bin
.ca
type · paste · share
⌘
K
Family
The bin family
pastebin.ca
hub
Share text and code with expiry and privacy controls.
imagebin.ca
Upload and share images with direct links.
filebin.ca
Drop a file and get a shareable link.
notebin.ca
Write Markdown notes with durable links.
turl.ca
Short, reputation-checked links.
attn.ca
Notifications and alerts for your services.
voicebin.ca
Record and share short voice clips.
dnsbin.ca
Inspect DNS and debug records.
Docs
Sign in
?
← back to paste
›
Edit / fork
Untitled paste
#7SYT8UR5Lh
public / public
new version
anonymous
created 15 hours ago
Expires in 6 days
10.3 KB
syntax:
text
Your changes create a new paste linked to this one — the original is untouched.
new version
Your changes create a new paste linked to this one — the original is untouched.
Title (optional)
Filename
Syntax
text
text
bash
c
cpp
css
diff
dockerfile
go
html
ini
java
javascript
json
kotlin
lua
makefile
markdown
nginx
php
python
ruby
rust
shellscript
sql
swift
toml
typescript
xml
yaml
Visibility
Public feed
Access
public
Expires
7 days
10 min
1 hour
1 day
7 days
30 days
90 days
custom…
Custom expiry
Change note
(optional)
This paste will be listed on the public feed. Change Visibility if you only want people with the link to see it.
Create new version
Cancel
Paste or type…
otel-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).collectTopQuery otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/scraper.go:509 otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.(*postgreSQLScraper).scrapeTopQuery otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/scraper.go:304 otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.createLogsReceiver.func3 otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/factory.go:150 otel-collector | go.opentelemetry.io/collector/scraper.ScrapeLogsFunc.ScrapeLogs otel-collector | go.opentelemetry.io/collector/scraper@v0.160.0/logs.go:25 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper.wrapObsLogs.func1 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/obs_logs.go:49 otel-collector | go.opentelemetry.io/collector/scraper.ScrapeLogsFunc.ScrapeLogs otel-collector | go.opentelemetry.io/collector/scraper@v0.160.0/logs.go:25 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper.scrapeLogs otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/controller.go:145 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper.NewLogsController.func1 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/controller.go:109 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper/internal/controller.(*Controller[...]).startScraping.func1 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/internal/controller/controller.go:122 otel-collector | sync.(*WaitGroup).Go.func1 otel-collector | sync/waitgroup.go:258 otel-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).explainQuery otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/client.go:221 otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.(*postgreSQLScraper).collectTopQuery otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/scraper.go:507 otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.(*postgreSQLScraper).scrapeTopQuery otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/scraper.go:304 otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.createLogsReceiver.func3 otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/factory.go:150 otel-collector | go.opentelemetry.io/collector/scraper.ScrapeLogsFunc.ScrapeLogs otel-collector | go.opentelemetry.io/collector/scraper@v0.160.0/logs.go:25 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper.wrapObsLogs.func1 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/obs_logs.go:49 otel-collector | go.opentelemetry.io/collector/scraper.ScrapeLogsFunc.ScrapeLogs otel-collector | go.opentelemetry.io/collector/scraper@v0.160.0/logs.go:25 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper.scrapeLogs otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/controller.go:145 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper.NewLogsController.func1 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/controller.go:109 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper/internal/controller.(*Controller[...]).startScraping.func1 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/internal/controller/controller.go:122 otel-collector | sync.(*WaitGroup).Go.func1 otel-collector | sync/waitgroup.go:258 otel-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).collectTopQuery otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/scraper.go:509 otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.(*postgreSQLScraper).scrapeTopQuery otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/scraper.go:304 otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver.createLogsReceiver.func3 otel-collector | github.com/open-telemetry/opentelemetry-collector-contrib/receiver/postgresqlreceiver@v0.160.0/factory.go:150 otel-collector | go.opentelemetry.io/collector/scraper.ScrapeLogsFunc.ScrapeLogs otel-collector | go.opentelemetry.io/collector/scraper@v0.160.0/logs.go:25 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper.wrapObsLogs.func1 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/obs_logs.go:49 otel-collector | go.opentelemetry.io/collector/scraper.ScrapeLogsFunc.ScrapeLogs otel-collector | go.opentelemetry.io/collector/scraper@v0.160.0/logs.go:25 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper.scrapeLogs otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/controller.go:145 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper.NewLogsController.func1 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/controller.go:109 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper/internal/controller.(*Controller[...]).startScraping.func1 otel-collector | go.opentelemetry.io/collector/scraper/scraperhelper@v0.160.0/internal/controller/controller.go:122 otel-collector | sync.(*WaitGroup).Go.func1 otel-collector | sync/waitgroup.go:258