Enterprise-Grade OSS PostgreSQL Distribution with HA, PITR, IaC, Monitor, 12 kernel forks and 500+ PG extensions. Best-of-breed products integrated as a platform. Self-host Postgres like a Pro!
This report presents the forensic synthetic code analysis of pgsty/pigsty, a Shell project with 5,221 GitHub stars. SynthScan v2.0 examined 165,128 lines of code across 511 source files, recording 877 pattern matches distributed across 13 syntactic categories. The overall adjusted score of 13.3 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).
This chart maps the temporal evolution of the adjusted synthetic code score across successive scan runs. An upward trajectory indicates ongoing incorporation of AI-generated code or expanding LLM-assisted scaffolding; a stable or declining trajectory may reflect active human refactoring, code removal, or the adoption of stricter authorship policies. The dashed secondary line (right axis) independently tracks total raw pattern hit count, which can diverge from the normalised score when codebase size changes significantly between scans.
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 877 distinct pattern matches across 13 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⚡ | slim.yml | 26 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | slim.yml | 28 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | slim.yml | 37 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | slim.yml | 39 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | slim.yml | 47 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | slim.yml | 49 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | slim.yml | 59 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | slim.yml | 61 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | slim.yml | 69 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | slim.yml | 71 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | minio.yml | 22 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | minio.yml | 24 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | minio.yml | 31 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | minio.yml | 33 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM | minio.yml | 49 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM | vibe.yml | 40 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM | vibe.yml | 42 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM | vibe.yml | 61 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM | vibe.yml | 63 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM | vibe.yml | 85 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | node.yml | 24 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | node.yml | 26 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM | node.yml | 49 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM | node.yml | 51 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM | node.yml | 64 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM | node.yml | 66 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM | node.yml | 114 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM | redis.yml | 15 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM | redis.yml | 17 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | infra-rm.yml | 15 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | infra-rm.yml | 17 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | infra-rm.yml | 25 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM | infra-rm.yml | 49 | #--------------------------------------------- | COMMENT |
| MEDIUM | infra-rm.yml | 51 | #--------------------------------------------- | COMMENT |
| MEDIUM | infra-rm.yml | 99 | #--------------------------------------------- | COMMENT |
| MEDIUM | infra-rm.yml | 101 | #--------------------------------------------- | COMMENT |
| MEDIUM | infra-rm.yml | 117 | #--------------------------------------------- | COMMENT |
| MEDIUM | infra-rm.yml | 119 | #--------------------------------------------- | COMMENT |
| MEDIUM | infra-rm.yml | 150 | #--------------------------------------------- | COMMENT |
| MEDIUM | infra-rm.yml | 152 | #--------------------------------------------- | COMMENT |
| MEDIUM⚡ | infra-rm.yml | 165 | #--------------------------------------------- | COMMENT |
| MEDIUM⚡ | infra-rm.yml | 167 | #--------------------------------------------- | COMMENT |
| MEDIUM⚡ | infra-rm.yml | 177 | #--------------------------------------------- | COMMENT |
| MEDIUM⚡ | infra-rm.yml | 179 | #--------------------------------------------- | COMMENT |
| MEDIUM⚡ | deploy.yml | 38 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | deploy.yml | 40 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | deploy.yml | 50 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | deploy.yml | 52 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | deploy.yml | 61 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | deploy.yml | 63 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | deploy.yml | 72 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | deploy.yml | 74 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | deploy.yml | 85 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | deploy.yml | 87 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | deploy.yml | 96 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | deploy.yml | 98 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | deploy.yml | 107 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | deploy.yml | 109 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | deploy.yml | 118 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | deploy.yml | 120 | #--------------------------------------------------------------- | COMMENT |
| 416 more matches not shown… | ||||
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | pgsql-pitr.yml | 1 | #!/usr/bin/env ansible-playbook | COMMENT |
| LOW | pgsql-pitr.yml | 21 | COMMENT | |
| LOW | pgsql-pitr.yml | 41 | # link_map: {} # Tablespace link mappings | COMMENT |
| LOW | pgsql-pitr.yml | 61 | # ./pgsql-pitr.yml -l pg-test -e '{"pg_pitr": {"cluster": "pg-meta", "name": "some_restore_point"}}' | COMMENT |
| LOW | pgsql-pitr.yml | 81 | # - start : # start patroni and postgres service | COMMENT |
| LOW | pigsty.yml | 1 | --- | COMMENT |
| LOW | pigsty.yml | 81 | etcd: | COMMENT |
| LOW | pigsty.yml | 161 | #----------------------------------------------# | COMMENT |
| LOW | pigsty.yml | 181 | # storage_port: 9000 # minio port, 9000 by default | COMMENT |
| LOW | redis-rm.yml | 1 | #!/usr/bin/env ansible-playbook | COMMENT |
| LOW | redis-rm.yml | 21 | vars: | COMMENT |
| LOW | redis-rm.yml | 41 | # | COMMENT |
| LOW | redis-rm.yml | 61 | # redis : stop and disable redis cluster/node/instance | COMMENT |
| LOW | slim.yml | 1 | #!/usr/bin/env ansible-playbook | COMMENT |
| LOW | pgsql.yml | 1 | #!/usr/bin/env ansible-playbook | COMMENT |
| LOW | pgsql.yml | 21 | - { role: pg_monitor ,tags: monitor } # init postgres monitoring | COMMENT |
| LOW | pgsql.yml | 41 | # | COMMENT |
| LOW | pgsql.yml | 61 | # - pg_pre : pre-install task | COMMENT |
| LOW | pgsql.yml | 81 | # - pg_primary : launch patroni/postgres primary | COMMENT |
| LOW | pgsql.yml | 101 | # - pgbackrest_init : init pgbackrest repo | COMMENT |
| LOW | pgsql.yml | 121 | # - pg_service_config : generate local haproxy config for pg services | COMMENT |
| LOW | minio.yml | 1 | #!/usr/bin/env ansible-playbook | COMMENT |
| LOW | minio.yml | 21 | COMMENT | |
| LOW | minio.yml | 41 | # - minio_cert : minio ssl cert | COMMENT |
| LOW | juice.yml | 1 | #!/usr/bin/env ansible-playbook | COMMENT |
| LOW | juice.yml | 21 | #--------------------------------------------------------------# | COMMENT |
| LOW | juice.yml | 41 | #--------------------------------------------------------------# | COMMENT |
| LOW | juice.yml | 61 | # juice_dir : create mountpoint | COMMENT |
| LOW | pgsql-user.yml | 1 | #!/usr/bin/env ansible-playbook | COMMENT |
| LOW | pgsql-user.yml | 21 | # `all.children.<pg_cluster>.vars.pg_users[i]` | COMMENT |
| LOW | pgsql-user.yml | 41 | #--------------------------------------------------------------# | COMMENT |
| LOW | pgsql-user.yml | 61 | # parameters: {} # optional, role level parameters with `ALTER ROLE SET` | COMMENT |
| LOW | vibe.yml | 1 | #!/usr/bin/env ansible-playbook | COMMENT |
| LOW | vibe.yml | 21 | #code_data: /data/code # code-server user data directory | COMMENT |
| LOW | vibe.yml | 41 | # Usage | COMMENT |
| LOW | vibe.yml | 61 | #--------------------------------------------------------------- | COMMENT |
| LOW | vibe.yml | 81 | # - claude_install : install claude-code package | COMMENT |
| LOW | pgsql-db.yml | 1 | #!/usr/bin/env ansible-playbook | COMMENT |
| LOW | pgsql-db.yml | 21 | # | COMMENT |
| LOW | pgsql-db.yml | 41 | # vars: | COMMENT |
| LOW | pgsql-db.yml | 61 | # icu_rules: '' # optional, icu rules for icu locale provider (PG16+) | COMMENT |
| LOW | node.yml | 1 | #!/usr/bin/env ansible-playbook | COMMENT |
| LOW | node.yml | 21 | - { role: node_monitor , tags: monitor } # init node monitor | COMMENT |
| LOW | node.yml | 41 | #--------------------------------------------------------------# | COMMENT |
| LOW | node.yml | 61 | # 1. node identity can be specified by nodename or node_cluster explicitly (override all) | COMMENT |
| LOW | node.yml | 81 | # node_alias : write /etc/profile.d/node.alias.sh | COMMENT |
| LOW | node.yml | 101 | # - node_exporter | COMMENT |
| LOW | pgsql-rm.yml | 1 | #!/usr/bin/env ansible-playbook | COMMENT |
| LOW | pgsql-rm.yml | 21 | #pg_rm_backup: true # remove pgbackrest backup during primary remove? true by default | COMMENT |
| LOW | pgsql-rm.yml | 41 | #--------------------------------------------------------------# | COMMENT |
| LOW | pgsql-rm.yml | 61 | # - dns : remove pg dns records | COMMENT |
| LOW | redis.yml | 1 | #!/usr/bin/env ansible-playbook | COMMENT |
| LOW | redis.yml | 21 | # ./redis.yml -l <cluster> # create redis cluster | COMMENT |
| LOW | redis.yml | 41 | # Tasks | COMMENT |
| LOW | etcd-rm.yml | 1 | #!/usr/bin/env ansible-playbook | COMMENT |
| LOW | etcd-rm.yml | 21 | #etcd_rm_pkg: false # uninstall etcd packages during remove? false by default | COMMENT |
| LOW | etcd-rm.yml | 41 | # Utils | COMMENT |
| LOW | infra-rm.yml | 1 | #!/usr/bin/env ansible-playbook | COMMENT |
| LOW | deploy.yml | 1 | #!/usr/bin/env ansible-playbook | COMMENT |
| LOW | deploy.yml | 21 | # - node-init : init node, haproxy & docker | COMMENT |
| 268 more matches not shown… | ||||
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM | roles/pg_remove/README.md | 43 | ├── main.yml # Entry point: orchestrates removal | CODE |
| MEDIUM | roles/node_id/vars/el8.x86_64.yml | 368 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/d13.aarch64.yml | 366 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/el8.aarch64.yml | 367 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/u24.aarch64.yml | 366 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/u26.x86_64.yml | 366 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/el7.x86_64.yml | 253 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/d12.x86_64.yml | 366 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/u22.aarch64.yml | 366 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/u24.x86_64.yml | 366 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/el9.aarch64.yml | 367 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/d12.aarch64.yml | 366 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/el9.x86_64.yml | 368 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/u22.x86_64.yml | 366 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/el10.x86_64.yml | 368 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/d13.x86_64.yml | 366 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/u26.aarch64.yml | 366 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/el10.aarch64.yml | 367 | # RAG: extension | COMMENT |
| MEDIUM | roles/pgsql/README.md | 44 | │ ├── main.yml # Entry point: orchestrates all subtasks | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM | pigsty.yml | 165 | # you can also use external object storage as backup repo | COMMENT |
| LOW⚡ | node.yml | 27 | # 1. make sure you have nopass ssh & sudo access to target node | COMMENT |
| LOW⚡ | node.yml | 28 | # 2. make sure you have defined these nodes in your inventory | COMMENT |
| MEDIUM | pgsql-monitor.yml | 55 | # pg_exporter_config: pg_exporter.yml # pg_exporter configuration file name, you can use other filename under fil | COMMENT |
| MEDIUM⚡ | docker.yml | 40 | # you can add registry mirror to `docker_registry_mirrors` to accelerate | COMMENT |
| MEDIUM | conf/slim.yml | 37 | #10.10.10.11: { pg_seq: 2, pg_role: replica } # you can add more! | COMMENT |
| MEDIUM | conf/fat.yml | 252 | # you can also use external object storage as backup repo | COMMENT |
| MEDIUM | conf/fat.yml | 278 | s3: # you can use cloud object storage as backup repo | CODE |
| MEDIUM | conf/rich.yml | 302 | # you can also use external object storage as backup repo | COMMENT |
| MEDIUM | conf/rich.yml | 328 | s3: # you can use cloud object storage as backup repo | CODE |
| MEDIUM | conf/supabase.yml | 302 | s3: # you can use cloud object storage as backup repo | CODE |
| MEDIUM | conf/meta.yml | 165 | # you can also use external object storage as backup repo | COMMENT |
| MEDIUM⚡ | conf/infra.yml | 25 | #10.10.10.11: { infra_seq: 2 } # you can add more nodes if you want | COMMENT |
| LOW⚡ | conf/infra.yml | 26 | #10.10.10.12: { infra_seq: 3 } # don't forget to assign unique infra_seq for each node | COMMENT |
| LOW⚡ | conf/infra.yml | 26 | #10.10.10.12: { infra_seq: 3 } # don't forget to assign unique infra_seq for each node | COMMENT |
| LOW | conf/infra.yml | 45 | # DON't FORGET TO CHANGE DEFAULT PASSWORDS! | COMMENT |
| MEDIUM | conf/app/supa.yml | 302 | s3: # you can use cloud object storage as backup repo | CODE |
| MEDIUM | conf/ha/safe.yml | 104 | cipher_pass: 'pgBR.${pg_cluster}' # <-------- CHANGE THIS, you can use cluster name as part of password | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | pigsty.yml | 17 | # Usage: | COMMENT |
| LOW | cert.yml | 16 | # Usage: | COMMENT |
| LOW | terraform/spec/qcloud.tf | 18 | # Usage: | COMMENT |
| LOW | bin/psql.py | 18 | # Usage: | COMMENT |
| LOW | conf/mssql.yml | 16 | # Usage: | COMMENT |
| LOW | conf/oriole.yml | 16 | # Usage: | COMMENT |
| LOW | conf/polar.yml | 16 | # Usage: | COMMENT |
| LOW | conf/slim.yml | 15 | # Usage: | COMMENT |
| LOW | conf/pgsql.yml | 16 | # Usage: | COMMENT |
| LOW | conf/vibe.yml | 16 | # Usage: | COMMENT |
| LOW | conf/fat.yml | 14 | # Usage: | COMMENT |
| LOW | conf/mysql.yml | 16 | # Usage: | COMMENT |
| LOW | conf/pgtde.yml | 16 | # Usage: | COMMENT |
| LOW | conf/rich.yml | 20 | # Usage: | COMMENT |
| LOW | conf/supabase.yml | 14 | # Usage: | COMMENT |
| LOW | conf/ivory.yml | 17 | # Usage: | COMMENT |
| LOW | conf/mongo.yml | 17 | # Usage: | COMMENT |
| LOW | conf/meta.yml | 17 | # Usage: | COMMENT |
| LOW | conf/pgedge.yml | 16 | # Usage: | COMMENT |
| LOW | conf/agens.yml | 16 | # Usage: | COMMENT |
| LOW | conf/pg19.yml | 15 | # Usage: | COMMENT |
| LOW⚡ | conf/infra.yml | 15 | # Usage: | COMMENT |
| LOW | conf/docker.yml | 15 | # Usage: | COMMENT |
| LOW | conf/app/supa.yml | 14 | # Usage: | COMMENT |
| LOW | conf/ha/citus.yml | 25 | # Usage: | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| HIGH | terraform/README.md | 235 | export VULTR_API_KEY="<your_api_key>" | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | bin/parse_nginx.py | 18 | CODE | |
| LOW | bin/parse_nginx.py | 62 | CODE | |
| LOW | bin/psql.py | 53 | CODE | |
| LOW | bin/psql.py | 75 | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | terraform/spec/qcloud.tf | 178 | # WARNING: This security group allows all inbound/outbound traffic. | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | app/dify/nginx/docker-entrypoint.sh | 6 | # Check if the certificate and key files for the specified domain exist | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | roles/pg_pitr/tasks/stop.yml | 20 | # if postmaster.pid file not exists, just return | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | bin/psql.py | 39 | except Exception: | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | bin/psql.py | 12 | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | files/grafana/grafana.py | 147 | def get_datasource_id_by_name(name): | CODE |