跳到主内容
paste
bin
.ca
type · paste · share
⌘
K
系列
bin 系列
pastebin.ca
中心
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.
文档
登录
?
← 返回文本
›
编辑 / 分支
无标题文本
#7SYT8UR5Lh
public / public
新版本
匿名
已创建 16 hours ago
过期于 6 days
10.3 KB
语法:
text
你的更改会创建一个链接到此文本的新文本 — 原始文本不变。
新版本
你的更改会创建一个链接到此文本的新文本 — 原始文本不变。
标题（可选）
文件名
语法
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
可见性
公开动态
访问
public
过期
7 天
10 分钟
1 小时
1 天
7 天
30 天
90 天
自定义…
自定义过期
变更备注
(可选)
此文本会显示在公开动态中。如果只想通过链接分享，请更改可见性。
创建新版本
取消
粘贴或输入…
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