A lightweight message queue. Like AWS SQS and RSMQ but on Postgres.
This report presents the forensic synthetic code analysis of pgmq/pgmq, a PLpgSQL project with 5,025 GitHub stars. SynthScan v2.0 examined 27,085 lines of code across 163 source files, recording 150 pattern matches distributed across 9 syntactic categories. The overall adjusted score of 7.5 places this repository in the Low AI signal band.
The scanner applied 160+ deterministic lexical heuristics, multi-line block detectors, abstract syntax tree depth profilers, and a cross-file Jaccard similarity matrix to construct a statistically normalised synthetic code estimate. All matches are individually weighted by severity coefficient and contextual multiplier before summation, and the resulting headline score is temporally discounted to account for the repository's development history relative to the commercial emergence of large language model coding tooling (November 2022 onward).
Longitudinal tracking requires multiple scan runs. Once this repository is re-scanned after new commits land, this chart will visualise how the synthetic code signal evolves over time — enabling you to detect whether AI authorship is growing, stabilising, or being actively corrected by human engineers.
Classifies detected patterns by their diagnostic confidence and structural impact. CRITICAL patterns (coefficient 10) represent definitive synthetic signatures — hallucinated imports, explicit LLM attribution metadata — virtually never produced by human authors. HIGH (5) indicates strong structural tells such as cross-file repetition or cross-linguistic idioms. MEDIUM (2) covers recognisable conversational padding and AI-specific vocabulary. LOW (1) captures subtle indicators like tautological comments and generic boilerplate that require density to carry independent signal.
This horizontal bar chart decomposes the repository's raw synthetic code score by top-level directory, allowing you to pinpoint precisely which modules or components carry the highest AI authorship density. Directories with disproportionately high scores relative to their size warrant targeted manual review: concentrated AI signatures often trace back to mass-generated configuration layers, auto-ported test suites, LLM-scaffolded boilerplate classes, or entire subsystems authored under heavy copilot assistance. Use this view to prioritise your human code-review effort.
The scanner identified 150 distinct pattern matches across 9 syntactic categories. Each entry below represents a discrete location in the source code where the engine recorded a statistically significant AI authorship indicator. Expand any category row to inspect the individual file paths, line numbers, code snippets, and the lexical context (CODE, COMMENT, or STRING) in which each match was detected.
Reading the findings table: The Severity column indicates the diagnostic confidence level (CRITICAL / HIGH / MEDIUM / LOW). The Context column identifies whether the match occurred inside executable code, an inline comment, or a string literal — comment-context matches receive a ×1.5 weight because LLMs systematically over-annotate. The ⚡ bolt icon marks clustered matches: three or more patterns within a 10-line window, each receiving an additional ×1.5 density multiplier as dense clusters constitute far stronger evidence of synthetic authorship than isolated hits.
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM | pgmq-extension/client-tests/upgrade_test.py | 49 | # --------------------------------------------------------------------------- | COMMENT |
| MEDIUM | pgmq-extension/client-tests/upgrade_test.py | 51 | # --------------------------------------------------------------------------- | COMMENT |
| MEDIUM | pgmq-extension/client-tests/upgrade_test.py | 64 | # --------------------------------------------------------------------------- | COMMENT |
| MEDIUM | pgmq-extension/client-tests/upgrade_test.py | 66 | # --------------------------------------------------------------------------- | COMMENT |
| MEDIUM | pgmq-extension/client-tests/upgrade_test.py | 206 | # --------------------------------------------------------------------------- | COMMENT |
| MEDIUM | pgmq-extension/client-tests/upgrade_test.py | 208 | # --------------------------------------------------------------------------- | COMMENT |
| MEDIUM | pgmq-extension/client-tests/upgrade_test.py | 332 | # --------------------------------------------------------------------------- | COMMENT |
| MEDIUM | pgmq-extension/client-tests/upgrade_test.py | 334 | # --------------------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | pgmq-extension/client-tests/topics_test.py | 157 | # ============================================================================= | COMMENT |
| MEDIUM⚡ | pgmq-extension/client-tests/topics_test.py | 159 | # ============================================================================= | COMMENT |
| MEDIUM⚡ | pgmq-extension/client-tests/topics_test.py | 273 | # ============================================================================= | COMMENT |
| MEDIUM⚡ | pgmq-extension/client-tests/topics_test.py | 275 | # ============================================================================= | COMMENT |
| MEDIUM⚡ | pgmq-extension/client-tests/topics_test.py | 439 | # ============================================================================= | COMMENT |
| MEDIUM⚡ | pgmq-extension/client-tests/topics_test.py | 441 | # ============================================================================= | COMMENT |
| MEDIUM⚡ | pgmq-extension/client-tests/topics_test.py | 830 | # ============================================================================= | COMMENT |
| MEDIUM⚡ | pgmq-extension/client-tests/topics_test.py | 832 | # ============================================================================= | COMMENT |
| MEDIUM | pgmq-extension/client-tests/topics_test.py | 620 | # ============================================================================= | COMMENT |
| MEDIUM | pgmq-extension/client-tests/topics_test.py | 622 | # ============================================================================= | COMMENT |
| MEDIUM | pgmq-extension/client-tests/topics_test.py | 1079 | # ============================================================================= | COMMENT |
| MEDIUM | pgmq-extension/client-tests/topics_test.py | 1081 | # ============================================================================= | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | pgmq-extension/client-tests/extended_notify_test.py | 203 | def test_enable_disable_notifications(db_connection: psycopg.Connection): | CODE |
| LOW | pgmq-extension/client-tests/extended_notify_test.py | 243 | def test_enable_notify_variations(db_connection: psycopg.Connection): | CODE |
| LOW | pgmq-extension/client-tests/extended_notify_test.py | 283 | def test_throttling_mechanism(db_connection: psycopg.Connection): | CODE |
| LOW | pgmq-extension/client-tests/extended_notify_test.py | 329 | def test_no_throttling_when_zero(db_connection: psycopg.Connection): | CODE |
| LOW | pgmq-extension/client-tests/extended_notify_test.py | 359 | def test_throttling_with_different_intervals(db_connection: psycopg.Connection): | CODE |
| LOW | pgmq-extension/client-tests/extended_notify_test.py | 400 | def test_idempotent_enable_disable(db_connection: psycopg.Connection): | CODE |
| LOW | pgmq-extension/client-tests/extended_notify_test.py | 434 | def test_negative_throttle_validation(db_connection: psycopg.Connection): | CODE |
| LOW | pgmq-extension/client-tests/extended_notify_test.py | 454 | def test_drop_queue_cleans_throttle_table(db_connection: psycopg.Connection): | CODE |
| LOW | pgmq-extension/client-tests/upgrade_test.py | 367 | def test_message_content_intact(self, db_connection): | CODE |
| LOW | pgmq-extension/client-tests/upgrade_test.py | 397 | def test_unlogged_queue_survives(self, db_connection): | CODE |
| LOW | pgmq-extension/client-tests/upgrade_test.py | 511 | def test_create_new_queue_post_upgrade(self, db_connection): | CODE |
| LOW | pgmq-extension/client-tests/upgrade_test.py | 537 | def test_drop_pre_upgrade_queue(self, db_connection): | CODE |
| LOW | pgmq-extension/client-tests/upgrade_test.py | 559 | def test_partitioned_queue_exists(self, db_connection): | CODE |
| LOW | pgmq-extension/client-tests/upgrade_test.py | 565 | def test_partitioned_messages_survive(self, db_connection): | CODE |
| LOW | pgmq-extension/client-tests/upgrade_test.py | 576 | def test_partitioned_send_and_read(self, db_connection): | CODE |
| LOW | pgmq-extension/client-tests/upgrade_test.py | 614 | def test_drop_partitioned_queue(self, db_connection): | CODE |
| LOW | pgmq-extension/client-tests/basic_notify_test.py | 39 | def test_pgmq_basic_notification(db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 165 | def test_valid_simple_routing_key(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 173 | def test_valid_routing_key_with_hyphens(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 181 | def test_valid_routing_key_with_underscores(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 191 | def test_valid_single_segment_routing_key(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 199 | def test_invalid_empty_routing_key(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 207 | def test_invalid_null_routing_key(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 215 | def test_invalid_routing_key_starts_with_dot(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 223 | def test_invalid_routing_key_ends_with_dot(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 231 | def test_invalid_routing_key_consecutive_dots(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 239 | def test_invalid_routing_key_with_wildcards(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 247 | def test_invalid_routing_key_with_special_chars(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 255 | def test_invalid_routing_key_with_space(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 263 | def test_invalid_routing_key_too_long(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 281 | def test_valid_pattern_with_star(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 289 | def test_valid_pattern_with_hash(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 297 | def test_valid_pattern_star_at_start(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 305 | def test_valid_pattern_hash_at_start(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 313 | def test_valid_pattern_mixed_wildcards(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 321 | def test_valid_pattern_exact_match(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 329 | def test_valid_pattern_only_hash(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 337 | def test_valid_pattern_only_star(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 345 | def test_invalid_empty_pattern(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 353 | def test_invalid_null_pattern(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 361 | def test_invalid_pattern_starts_with_dot(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 369 | def test_invalid_pattern_ends_with_dot(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 377 | def test_invalid_pattern_consecutive_dots(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 385 | def test_invalid_pattern_consecutive_stars(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 393 | def test_invalid_pattern_consecutive_hashes(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 401 | def test_invalid_pattern_adjacent_wildcards_star_hash( | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 411 | def test_invalid_pattern_adjacent_wildcards_hash_star( | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 421 | def test_invalid_pattern_special_chars(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 429 | def test_invalid_pattern_too_long(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 447 | def test_bind_topic_creates_binding(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 838 | def test_send_topic_single_queue(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 974 | def test_send_topic_invalid_routing_key(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 982 | def test_send_topic_null_message(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 991 | def test_send_topic_negative_delay(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 1095 | def test_pattern_rejects_parentheses(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 1102 | def test_pattern_rejects_square_brackets(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 1109 | def test_pattern_rejects_dollar(self, db_connection: psycopg.Connection): | CODE |
| LOW⚡ | pgmq-extension/client-tests/topics_test.py | 1118 | def test_routing_key_rejects_regex_metacharacters( | CODE |
| LOW | pgmq-extension/client-tests/topics_test.py | 464 | def test_bind_topic_idempotent(self, db_connection: psycopg.Connection): | CODE |
| LOW | pgmq-extension/client-tests/topics_test.py | 484 | def test_bind_topic_multiple_patterns(self, db_connection: psycopg.Connection): | CODE |
| 23 more matches not shown… | ||||
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | pgmq-rs/pgmq_test_macro/src/lib.rs | 1 | //! Private macro(s) used by the `pgmq` crate in tests. | COMMENT |
| LOW | pgmq-rs/src/lib.rs | 1 | //! # Postgres Message Queue (PGMQ) | COMMENT |
| LOW | pgmq-rs/src/lib.rs | 21 | //! | COMMENT |
| LOW | pgmq-rs/src/lib.rs | 41 | //! | COMMENT |
| LOW | pgmq-rs/src/lib.rs | 61 | //! requests to GitHub, but allows installing (or upgrading to) any version available in the repo. | COMMENT |
| LOW | pgmq-rs/src/lib.rs | 81 | //! ```shell | COMMENT |
| LOW | pgmq-rs/src/lib.rs | 101 | //! // Replace the version | COMMENT |
| LOW | pgmq-rs/src/lib.rs | 121 | //! | COMMENT |
| LOW | pgmq-rs/src/lib.rs | 141 | //! | COMMENT |
| LOW | pgmq-rs/src/lib.rs | 161 | //! #[cfg(feature = "install-sql-github")] | COMMENT |
| LOW | pgmq-rs/src/lib.rs | 181 | //! | COMMENT |
| LOW | pgmq-rs/src/lib.rs | 201 | //! | COMMENT |
| LOW | pgmq-rs/src/lib.rs | 221 | //! async fn main() -> Result<(), PgmqError> { | COMMENT |
| LOW | pgmq-rs/src/lib.rs | 241 | //! }; | COMMENT |
| LOW | pgmq-rs/src/errors.rs | 21 | COMMENT | |
| LOW | pgmq-rs/src/types/mod.rs | 21 | #[cfg_attr(feature = "sqlx", derive(sqlx::FromRow))] | COMMENT |
| LOW | pgmq-rs/src/types/mod.rs | 41 | /// The number of times the message has been read. Increments on read. | COMMENT |
| LOW | pgmq-rs/src/types/queue_name.rs | 141 | #[case("-")] | COMMENT |
| LOW | pgmq-rs/src/types/visibility_timeout_offset.rs | 1 | use std::ops::Deref; | COMMENT |
| LOW | pgmq-rs/src/types/visibility_timeout_offset.rs | 21 | /// assert_eq!(10i32, *VisibilityTimeoutOffset::from(10i32)); | COMMENT |
| LOW | pgmq-rs/src/types/visibility_timeout_offset.rs | 41 | /// | COMMENT |
| LOW | pgmq-rs/src/types/visibility_timeout_offset.rs | 61 | /// ``` | COMMENT |
| LOW | pgmq-rs/src/bin/pgmq-cli.rs | 21 | #[derive(Debug, Parser)] | COMMENT |
| LOW | pgmq-rs/src/pg_ext/mod.rs | 1401 | /// Provide a non-zero throttle interval to specify how often a notification can be sent. | COMMENT |
| LOW | pgmq-rs/src/pg_ext/mod.rs | 1581 | .await?; | COMMENT |
| LOW | pgmq-rs/src/private/mod.rs | 1 | /// Private marker trait that can be used to mark another trait as "sealed", which prevents external | COMMENT |
| LOW | pgmq-rs/src/queue/diesel/mod.rs | 1 | #[cfg(feature = "diesel-async")] | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| HIGH | pgmq-extension/client-tests/extended_notify_test.py | 0 | create database connection using database_url environment variable. | STRING |
| HIGH | pgmq-extension/client-tests/basic_notify_test.py | 0 | create database connection using database_url environment variable. | STRING |
| HIGH | pgmq-extension/client-tests/topics_test.py | 0 | create database connection using database_url environment variable. | STRING |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | .claude/commands/pgmq/update-docs.md | 18 | ## Step 1: Analyze the Source Code | COMMENT |
| LOW | .claude/commands/pgmq/update-docs.md | 34 | ## Step 2: Read All Documentation Files | COMMENT |
| LOW | .claude/commands/pgmq/update-docs.md | 46 | ## Step 3: Deep Analysis and Comparison | COMMENT |
| LOW | .claude/commands/pgmq/update-docs.md | 64 | ## Step 4: Create Comprehensive Issue List | COMMENT |
| LOW | .claude/commands/pgmq/update-docs.md | 99 | ## Step 5: Organize Work into Phases | COMMENT |
| LOW | .claude/commands/pgmq/update-docs.md | 111 | ## Step 6: Execute Fixes Methodically | COMMENT |
| LOW | .claude/commands/pgmq/update-docs.md | 152 | ## Step 7: Verify Each Edit Ultra-Carefully | COMMENT |
| LOW | .claude/commands/pgmq/update-docs.md | 173 | ## Step 8: Create Detailed Commits | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM | pgmq-rs/src/lib.rs | 63 | //! #### Create the DB | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | pgmq-extension/client-tests/test.py | 17 | CODE | |
| LOW | pgmq-extension/client-tests/test.py | 19 | CODE | |
| LOW | pgmq-extension/client-tests/test.py | 21 | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | pgmq-extension/sql/pgmq--0.11.1--0.11.2.sql | 1 | -- pgmq_meta wasn't necessarily existent in this version, so we need to check if | CODE |
| LOW | pgmq-extension/sql/pgmq--0.14.3--0.15.0.sql | 1 | -- pgmq_meta wasn't necessarily existent in this version, so we need to check if | CODE |
| LOW | pgmq-extension/sql/pgmq--0.13.0--0.13.1.sql | 1 | -- pgmq_meta wasn't necessarily existent in this version, so we need to check if | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | docs/topics.md | 492 | '{"to": "user@example.com", "subject": "Reminder"}', | CODE |
| LOW | docs/topics.md | 493 | '{"to": "admin@example.com", "subject": "Daily report"}' | CODE |