Enterprise-Grade OSS PostgreSQL Distribution with HA, PITR, IaC, Monitor, 12 kernel forks and 575 PG extensions. Best-of-breed products integrated as a platform. Self-host Postgres like a Pro!
This report summarizes scanner evidence for pgsty/pigsty, a Shell project with 5,793 GitHub stars. SynthScan examined 190,296 lines of code across 573 source files, recording 910 pattern matches distributed across 16 syntactic categories. The legacy adjusted pattern signal is 11.8 (Moderate pattern signal); it is not an authorship estimate.
Use the findings to ask whether maintainers can explain intent, verify dependencies, simplify unnecessary scaffolding, and focus review effort. Risk Payload v1 adds ownership, supply-chain, over-engineering, and review-effort vectors when available. These are prompts for human verification, not probabilities, security findings, or measured maintenance costs.
Use each vector to guide manual verification of the underlying findings.
Can maintainers explain intent, assumptions, and trade-offs? 424 finding(s).
Are imports declared and package/API names verified? 3 finding(s).
Are wrappers, guards, and repeated structures necessary? 485 finding(s).
Which changes need focused human review? 910 finding(s).
This chart tracks the legacy adjusted pattern score across scan runs. Changes can reflect source changes, scan coverage, or detector/scoring versions; they do not measure AI adoption or prove that a team refactored code. Compare runs only when their scoring versions are compatible. The dashed line tracks the raw pattern-hit count.
Groups findings by configured severity weight. Severity is not a confidence estimate, security rating, or proof that a package is missing. Verify imports against the project's manifests and inspect each finding in its local design context.
This horizontal bar chart shows where configured pattern scores accumulate across directories. Treat the bars as locations to inspect, not as evidence of authorship or code quality. Use the file-level findings to decide whether a directory needs a focused ownership, dependency, complexity, or review check.
The scanner identified 910 distinct pattern matches across 16 syntactic categories. Each entry below represents a discrete location in the source code where the engine recorded a detector match to inspect in context. 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 configured finding weight (CRITICAL / HIGH / MEDIUM / LOW). The Context column identifies whether the match occurred inside executable code, an inline comment, or a string literal — legacy comment-context matches receive a ×1.5 score weight. The ⚡ bolt icon marks clustered matches: three or more patterns within a 10-line window, each receiving an additional ×1.5 density multiplier under the legacy scoring model.
| 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 | 23 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | minio.yml | 25 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | minio.yml | 32 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM⚡ | minio.yml | 34 | #--------------------------------------------------------------- | COMMENT |
| MEDIUM | minio.yml | 50 | #--------------------------------------------------------------- | 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 | 152 | #--------------------------------------------- | COMMENT |
| MEDIUM | infra-rm.yml | 154 | #--------------------------------------------- | COMMENT |
| MEDIUM⚡ | infra-rm.yml | 167 | #--------------------------------------------- | COMMENT |
| MEDIUM⚡ | infra-rm.yml | 169 | #--------------------------------------------- | COMMENT |
| MEDIUM⚡ | infra-rm.yml | 179 | #--------------------------------------------- | COMMENT |
| MEDIUM⚡ | infra-rm.yml | 181 | #--------------------------------------------- | 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 |
| 421 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 | kafka.yml | 1 | #!/usr/bin/env ansible-playbook | COMMENT |
| LOW | kafka.yml | 21 | - { role: kafka ,tags: kafka ,when: kafka_cluster is defined } # init & converge kafka cluster | COMMENT |
| LOW | kafka.yml | 41 | # # join the dynamic quorum, one at a time | COMMENT |
| LOW | kafka.yml | 61 | # vars: { kafka_cluster: kf-main } | COMMENT |
| LOW | kafka.yml | 81 | # - kafka_format : format uninitialized storage (dynamic-quorum mode) | COMMENT |
| LOW | redis-rm.yml | 1 | #!/usr/bin/env ansible-playbook | COMMENT |
| LOW | redis-rm.yml | 21 | - { role: redis_remove ,when: redis_cluster is defined } | COMMENT |
| LOW | redis-rm.yml | 41 | # redis-rm.yml -l 10.10.10.13 | COMMENT |
| LOW | redis-rm.yml | 61 | # redis_exporter : stop and disable redis_exporter | 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: pgsql ,tags: pgsql ,when: pg_cluster is defined } # init postgres cluster/instance | COMMENT |
| LOW | pgsql.yml | 41 | # ./pgsql.yml -l pg-test --tags=pg_service | COMMENT |
| LOW | pgsql.yml | 61 | # - pg_dbsu_create : exchange dbsu ssh keys | COMMENT |
| LOW | pgsql.yml | 81 | # - pg_cert_issue : signing pg server certs | COMMENT |
| LOW | pgsql.yml | 101 | # | COMMENT |
| LOW | pgsql.yml | 121 | # - pg_dns : register dns name to infra dnsmasq | COMMENT |
| LOW | minio.yml | 1 | #!/usr/bin/env ansible-playbook | COMMENT |
| LOW | minio.yml | 21 | COMMENT | |
| LOW | minio.yml | 41 | # - minio_conf : minio main config | 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 | kafka-rm.yml | 1 | #!/usr/bin/env ansible-playbook | COMMENT |
| LOW | kafka-rm.yml | 41 | - { role: kafka_remove ,when: kafka_cluster is defined } | COMMENT |
| LOW | kafka-rm.yml | 61 | # under-replicated until a replacement with the same kafka_seq rejoins via | 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_data: true # remove postgres data during remove? true by default | COMMENT |
| LOW | pgsql-rm.yml | 41 | # pgsql-rm.yml -l 10.10.10.13 # remove instance `10.10.10.13` from cluster `pg-test` | COMMENT |
| LOW | pgsql-rm.yml | 61 | # - pgbackrest_exporter : remove pgbackrest_exporter (pgbackrest monitoring) | COMMENT |
| LOW | mysql.yml | 1 | #!/usr/bin/env ansible-playbook | COMMENT |
| 290 more matches not shown… | ||||
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM | roles/pg_remove/README.md | 44 | ├── main.yml # Entry point: orchestrates removal | CODE |
| MEDIUM | roles/kafka/README.md | 62 | │ ├── main.yml # Entry point: orchestrates all subtasks | CODE |
| MEDIUM | roles/node_id/vars/el8.x86_64.yml | 383 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/d13.aarch64.yml | 381 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/el8.aarch64.yml | 383 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/u24.aarch64.yml | 381 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/u26.x86_64.yml | 381 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/el7.x86_64.yml | 260 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/d12.x86_64.yml | 381 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/u22.aarch64.yml | 381 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/u24.x86_64.yml | 381 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/el9.aarch64.yml | 383 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/d12.aarch64.yml | 381 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/el9.x86_64.yml | 383 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/u22.x86_64.yml | 381 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/el10.x86_64.yml | 383 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/d13.x86_64.yml | 381 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/u26.aarch64.yml | 381 | # RAG: extension | COMMENT |
| MEDIUM | roles/node_id/vars/el10.aarch64.yml | 383 | # RAG: extension | COMMENT |
| MEDIUM | roles/pgsql/README.md | 55 | │ ├── 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 | 262 | 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 | |
| LOW | roles/kafka/files/kafka_health.py | 182 | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| HIGH | roles/kafka/files/kafka_provision.py | 40 | except FileNotFoundError: | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM | conf/demo/mysql.yml | 16 | # This file is a template, not the active deployment inventory. Replace every | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | bin/psql.py | 12 | CODE | |
| LOW | files/grafana/mysql/generate.py | 9 | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | terraform/spec/qcloud.tf | 179 | # 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 | files/grafana/grafana.py | 208 | def get_datasource_id_by_name(name): | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | files/grafana/mysql/generate.py | 75 | CODE |