profiling-optimization
Warn
Audited by Socket on Sep 16, 2026
1 alert found:
AnomalyAnomalyreferences/database-query-profiling.md
LOWAnomalyLOW
references/database-query-profiling.md
The code is a legitimate PostgreSQL query profiler, not apparent malware. Its main risks are unsafe acceptance of raw SQL and the fact that EXPLAIN ANALYZE executes the query before executing it again. Restrict profiling to trusted, read-only queries or use transaction/rollback safeguards and validate query intent. Reset session settings when using pooled connections. Parameter binding is appropriate for values but cannot secure an untrusted SQL query string.
Confidence: 98%Severity: 68%
Audit Metadata