Vitess for Postgres
This report summarizes scanner evidence for multigres/multigres, a Go project with 2,668 GitHub stars. SynthScan examined 775,692 lines of code across 2086 source files, recording 3404 pattern matches distributed across 13 syntactic categories. The legacy adjusted pattern signal is 4.9 (Low 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? 3350 finding(s).
Are imports declared and package/API names verified? 11 finding(s).
Are wrappers, guards, and repeated structures necessary? 47 finding(s).
Which changes need focused human review? 3404 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 3404 distinct pattern matches across 13 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 |
|---|---|---|---|---|
| LOW | codecov.yml | 21 | # so coverage-collecting CI never executes any of it — every new line | COMMENT |
| LOW | .golangci.yml | 1 | # Copyright 2025 Supabase, Inc. | COMMENT |
| LOW | .golangci.yml | 181 | desc: "Please use math/rand/v2" | COMMENT |
| LOW | .golangci.yml | 221 | # Check for locks erroneously passed by value. | COMMENT |
| LOW | .golangci.yml | 241 | # Check for mistakes using HTTP responses. | COMMENT |
| LOW | docker-compose.yml | 1 | # All-in-one Multigres cluster for local development and CI compatibility | COMMENT |
| LOW | docker-compose.yml | 21 | # bundles the required extensions + pgBackRest and set | COMMENT |
| LOW | docker-compose.yml | 41 | # AtLeastN(2) durability policy, so a single pooler can never elect a | COMMENT |
| LOW | demo/k8s/port-forward-infra.sh | 1 | #!/usr/bin/env bash | COMMENT |
| LOW | demo/k8s/update-grafana-dashboard.sh | 1 | #!/usr/bin/env bash | COMMENT |
| LOW | demo/k8s/backup-restore.sh | 1 | #!/bin/bash | COMMENT |
| LOW | demo/k8s/backup-restore.sh | 21 | # - kubectl configured to access the cluster | COMMENT |
| LOW | demo/k8s/k8s-multipooler-statefulset.yaml | 1 | # We're trying to see if Statefullsets can be made to work. | COMMENT |
| LOW | demo/k8s/launch-multigres-cluster.sh | 1 | #!/usr/bin/env zsh | COMMENT |
| LOW | demo/k8s/launch-infra.sh | 1 | #!/usr/bin/env zsh | COMMENT |
| LOW | demo/k8s/teardown.sh | 1 | #!/usr/bin/env zsh | COMMENT |
| LOW | demo/k8s/start-qs.sh | 1 | #!/bin/bash | COMMENT |
| LOW | demo/k8s/failover-test.go | 1 | // Copyright 2025 Supabase, Inc. | COMMENT |
| LOW | demo/k8s/port-forward-multigres-cluster.sh | 1 | #!/usr/bin/env bash | COMMENT |
| LOW | demo/k8s/k8s-postgres-password-secret.yaml | 1 | # Example Secret holding the PostgreSQL superuser password. Each multipooler | COMMENT |
| LOW | demo/observability/sampling-config.yaml | 1 | # OpenTelemetry Sampling Configuration for Multigres kind_demo | COMMENT |
| LOW | demo/local/failover-test.go | 1 | // Copyright 2025 Supabase, Inc. | COMMENT |
| LOW | tools/setup_s3_cluster.sh | 1 | #!/bin/bash | COMMENT |
| LOW | tools/download_tool.sh | 1 | #!/bin/bash | COMMENT |
| LOW | tools/safe_download.sh | 1 | #!/bin/bash | COMMENT |
| LOW | tools/naming_linter.sh | 1 | #!/bin/bash | COMMENT |
| LOW | tools/naming_linter.sh | 21 | # "MultiGateway", "MultiAdmin", etc. (and their leading-lowercase variants | COMMENT |
| LOW | tools/setup_build_tools.sh | 1 | #!/bin/bash | COMMENT |
| LOW | tools/setup_build_tools.sh | 481 | # symlink the resulting binary into $MTROOT/bin/pgproto. | COMMENT |
| LOW | tools/tool_checksums.sh | 1 | #!/bin/bash | COMMENT |
| LOW | tools/run_super_linter.sh | 1 | #!/bin/bash | COMMENT |
| LOW | tools/openapi/lint/main.go | 1 | // Copyright 2026 Supabase, Inc. | COMMENT |
| LOW | tools/openapi/lint/main_test.go | 1 | // Copyright 2026 Supabase, Inc. | COMMENT |
| LOW | tools/openapi/normalize/main.go | 1 | // Copyright 2026 Supabase, Inc. | COMMENT |
| LOW | tools/openapi/normalize/main_test.go | 1 | // Copyright 2026 Supabase, Inc. | COMMENT |
| LOW | docker/pgregress-generate.sh | 1 | #!/usr/bin/env bash | COMMENT |
| LOW | docker/pgregress-generate.sh | 21 | # | COMMENT |
| LOW | docker/cluster-entrypoint.sh | 1 | #!/usr/bin/env bash | COMMENT |
| LOW | docker/cluster-entrypoint.sh | 21 | set -euo pipefail | COMMENT |
| LOW | docker/cluster-entrypoint.sh | 41 | COMMENT | |
| LOW | docker/cluster-entrypoint.sh | 61 | # Connections held back from the pooler when MULTIGRES_PG_MAX_CONNECTIONS is set. | COMMENT |
| LOW | go/cmd/minigres/plugin_topo.go | 1 | // Copyright 2026 Supabase, Inc. | COMMENT |
| LOW | go/cmd/minigres/main.go | 1 | // Copyright 2026 Supabase, Inc. | COMMENT |
| LOW | go/cmd/minigres/main_test.go | 1 | // Copyright 2026 Supabase, Inc. | COMMENT |
| LOW | go/cmd/multigateway/plugin_topo.go | 1 | // Copyright 2025 Supabase, Inc. | COMMENT |
| LOW | go/cmd/multigateway/main.go | 1 | // Copyright 2025 Supabase, Inc. | COMMENT |
| LOW | go/cmd/multigateway/main_test.go | 1 | // Copyright 2025 Supabase, Inc. | COMMENT |
| LOW | go/cmd/multiadmin/plugin_topo.go | 1 | // Copyright 2025 Supabase, Inc. | COMMENT |
| LOW | go/cmd/multiadmin/main.go | 1 | // Copyright 2025 Supabase, Inc. | COMMENT |
| LOW | go/cmd/multiadmin/main_test.go | 1 | // Copyright 2025 Supabase, Inc. | COMMENT |
| LOW | go/cmd/pgctld/main.go | 1 | // Copyright 2025 Supabase, Inc. | COMMENT |
| LOW | go/cmd/pgctld/command/reload.go | 1 | // Copyright 2025 Supabase, Inc. | COMMENT |
| LOW | go/cmd/pgctld/command/start_test.go | 1 | // Copyright 2025 Supabase, Inc. | COMMENT |
| LOW | go/cmd/pgctld/command/flags_test.go | 1 | // Copyright 2026 Supabase, Inc. | COMMENT |
| LOW | go/cmd/pgctld/command/version.go | 1 | // Copyright 2025 Supabase, Inc. | COMMENT |
| LOW | go/cmd/pgctld/command/server.go | 1 | // Copyright 2025 Supabase, Inc. | COMMENT |
| LOW | go/cmd/pgctld/command/server.go | 601 | // that is up — or still starting after a Start whose success was misreported | COMMENT |
| LOW | go/cmd/pgctld/command/metrics.go | 1 | // Copyright 2026 Supabase, Inc. | COMMENT |
| LOW | go/cmd/pgctld/command/pg_instance_test.go | 1 | // Copyright 2026 Supabase, Inc. | COMMENT |
| LOW | go/cmd/pgctld/command/init_secrets_test.go | 1 | // Copyright 2026 Supabase, Inc. | COMMENT |
| 2982 more matches not shown… | ||||
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW⚡ | go/cmd/pgctld/command/server_test.go | 824 | // Step 1: Simulate a running postgres by installing a postmaster.pid that | COMMENT |
| LOW⚡ | go/cmd/pgctld/command/server_test.go | 829 | // Step 2: Stop postgres. This is the first part of the stop→rewind→start sequence. | COMMENT |
| LOW⚡ | go/cmd/pgctld/command/server_test.go | 834 | // Step 3: Run pg_rewind (dry-run). The service must accept this call after a stop; | COMMENT |
| LOW⚡ | go/cmd/pgctld/command/server_test.go | 844 | // Step 4: Start postgres again as standby. This is the critical step: the service | COMMENT |
| LOW | go/test/s3mock/test-pgbackrest.sh | 79 | # Step 1: Build and start S3 mock server | COMMENT |
| LOW | go/test/s3mock/test-pgbackrest.sh | 107 | # Step 2: Initialize PostgreSQL cluster | COMMENT |
| LOW | go/test/s3mock/test-pgbackrest.sh | 141 | # Step 3: Configure pgBackRest | COMMENT |
| LOW | go/test/s3mock/test-pgbackrest.sh | 174 | # Step 4: Create pgBackRest stanza | COMMENT |
| LOW | go/test/s3mock/test-pgbackrest.sh | 190 | # Step 5: Create full backup | COMMENT |
| LOW⚡ | go/test/s3mock/test-pgbackrest.sh | 220 | # Step 6: Extract backup label from info output | COMMENT |
| LOW⚡ | go/test/s3mock/test-pgbackrest.sh | 230 | # Step 7: Verify backup integrity | COMMENT |
| LOW⚡ | go/test/s3mock/test-pgbackrest.sh | 239 | # Step 8: Test restore | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 82 | // Step 2: Initialize data directory | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 86 | // Step 3: Start PostgreSQL | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 91 | // Step 4: Check status - should be running, with the adoptable config | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 107 | // Step 5: Get version | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 112 | // Step 6: Reload config | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 117 | // Step 7: Restart | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 122 | // Step 8: Check status again | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 127 | // Step 9: Stop PostgreSQL | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 132 | // Step 10: Final status check | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 379 | // Step 1: Check initial status - should be NOT_INITIALIZED | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 385 | // Step 2: Try to start without initialization - should fail with proper error | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 391 | // Step 3: Try to stop without initialization - should return appropriate message | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 401 | // Step 4: Try restart without initialization - should fail | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 406 | // Step 5: Try reload config without initialization - should fail | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 411 | // Step 6: Initialize should work | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 416 | // Step 7: Status should now show STOPPED | COMMENT |
| LOW | go/test/endtoend/pgctld/pgctld_grpc_test.go | 70 | // Step 1: Check initial status. Config-level fields (pooler dir, host) | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 106 | // Step 2: Check status - should show stopped after init | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 116 | // Step 3: Test help commands work | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 122 | // Step 4: Test that real PostgreSQL binaries are detected | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 129 | // Step 5: Test initialization works with real PostgreSQL | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 1197 | // Step 1: Initialize the database first | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 1206 | // Step 2: Check status - should be stopped after init | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 1216 | // Step 3: Start PostgreSQL | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 1222 | // Step 4: Check status - should be running | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 1229 | // Step 5: Reload configuration | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 1235 | // Step 6: Restart PostgreSQL | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 1241 | // Step 7: Check status again - should still be running | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 1248 | // Step 8: Stop PostgreSQL | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 1254 | // Step 9: Final status check - should be stopped | COMMENT |
| LOW | go/test/endtoend/pgctld/pgctld_test.go | 85 | // Step 1: Initialize the database first | COMMENT |
| LOW | …/endtoend/localprovisioner/refresh_credentials_test.go | 101 | // Step 1: Initialize cluster with S3 + UseEnvCredentials | COMMENT |
| LOW | …/endtoend/localprovisioner/refresh_credentials_test.go | 123 | // Step 2: Verify initial credentials file exists | COMMENT |
| LOW | …/endtoend/localprovisioner/refresh_credentials_test.go | 150 | // Step 3: Change AWS credentials in environment | COMMENT |
| LOW | …/endtoend/localprovisioner/refresh_credentials_test.go | 162 | // Step 4: Run refresh-credentials command | COMMENT |
| LOW | …/endtoend/localprovisioner/refresh_credentials_test.go | 178 | // Step 5: Verify credentials file updated with new values | COMMENT |
| LOW | …/endtoend/localprovisioner/refresh_credentials_test.go | 202 | // Step 6: Verify file permissions preserved (0600) | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 98 | // Step 1: Kill postgres on primary to trigger failover | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 102 | // Step 2: Wait for new primary election | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 108 | // Step 3: Write data to new primary to ensure timeline has diverged | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 112 | // Step 4: Re-enable postgres auto-restarts on the old primary. The new | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 120 | // Step 5: Wait for multiorch to detect and repair divergence. Once postgres | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 127 | // Step 6: Verify old primary is now replicating from new primary | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 131 | // Step 7: Verify replication is actually working by writing data and checking it replicates | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 135 | // Step 8: Verify the old primary was demoted via SetPrimary. | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 140 | // Step 9: Verify consensus.recruit event was emitted during failover. | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 196 | // Step 1: Gracefully shutdown postgres on primary to trigger failover. | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 204 | // Step 2: Wait for new primary election | COMMENT |
| 63 more matches not shown… | ||||
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW⚡ | go/cmd/pgctld/command/server_test.go | 824 | // Step 1: Simulate a running postgres by installing a postmaster.pid that | COMMENT |
| LOW⚡ | go/cmd/pgctld/command/server_test.go | 829 | // Step 2: Stop postgres. This is the first part of the stop→rewind→start sequence. | COMMENT |
| LOW⚡ | go/cmd/pgctld/command/server_test.go | 834 | // Step 3: Run pg_rewind (dry-run). The service must accept this call after a stop; | COMMENT |
| LOW⚡ | go/cmd/pgctld/command/server_test.go | 844 | // Step 4: Start postgres again as standby. This is the critical step: the service | COMMENT |
| LOW | go/test/s3mock/test-pgbackrest.sh | 79 | # Step 1: Build and start S3 mock server | COMMENT |
| LOW | go/test/s3mock/test-pgbackrest.sh | 107 | # Step 2: Initialize PostgreSQL cluster | COMMENT |
| LOW | go/test/s3mock/test-pgbackrest.sh | 141 | # Step 3: Configure pgBackRest | COMMENT |
| LOW | go/test/s3mock/test-pgbackrest.sh | 174 | # Step 4: Create pgBackRest stanza | COMMENT |
| LOW | go/test/s3mock/test-pgbackrest.sh | 190 | # Step 5: Create full backup | COMMENT |
| LOW⚡ | go/test/s3mock/test-pgbackrest.sh | 220 | # Step 6: Extract backup label from info output | COMMENT |
| LOW⚡ | go/test/s3mock/test-pgbackrest.sh | 230 | # Step 7: Verify backup integrity | COMMENT |
| LOW⚡ | go/test/s3mock/test-pgbackrest.sh | 239 | # Step 8: Test restore | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 82 | // Step 2: Initialize data directory | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 86 | // Step 3: Start PostgreSQL | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 91 | // Step 4: Check status - should be running, with the adoptable config | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 107 | // Step 5: Get version | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 112 | // Step 6: Reload config | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 117 | // Step 7: Restart | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 122 | // Step 8: Check status again | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 127 | // Step 9: Stop PostgreSQL | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 132 | // Step 10: Final status check | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 379 | // Step 1: Check initial status - should be NOT_INITIALIZED | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 385 | // Step 2: Try to start without initialization - should fail with proper error | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 391 | // Step 3: Try to stop without initialization - should return appropriate message | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 401 | // Step 4: Try restart without initialization - should fail | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 406 | // Step 5: Try reload config without initialization - should fail | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 411 | // Step 6: Initialize should work | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_grpc_test.go | 416 | // Step 7: Status should now show STOPPED | COMMENT |
| LOW | go/test/endtoend/pgctld/pgctld_grpc_test.go | 70 | // Step 1: Check initial status. Config-level fields (pooler dir, host) | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 106 | // Step 2: Check status - should show stopped after init | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 116 | // Step 3: Test help commands work | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 122 | // Step 4: Test that real PostgreSQL binaries are detected | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 129 | // Step 5: Test initialization works with real PostgreSQL | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 1197 | // Step 1: Initialize the database first | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 1206 | // Step 2: Check status - should be stopped after init | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 1216 | // Step 3: Start PostgreSQL | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 1222 | // Step 4: Check status - should be running | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 1229 | // Step 5: Reload configuration | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 1235 | // Step 6: Restart PostgreSQL | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 1241 | // Step 7: Check status again - should still be running | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 1248 | // Step 8: Stop PostgreSQL | COMMENT |
| LOW⚡ | go/test/endtoend/pgctld/pgctld_test.go | 1254 | // Step 9: Final status check - should be stopped | COMMENT |
| LOW | go/test/endtoend/pgctld/pgctld_test.go | 85 | // Step 1: Initialize the database first | COMMENT |
| LOW | …/endtoend/localprovisioner/refresh_credentials_test.go | 101 | // Step 1: Initialize cluster with S3 + UseEnvCredentials | COMMENT |
| LOW | …/endtoend/localprovisioner/refresh_credentials_test.go | 123 | // Step 2: Verify initial credentials file exists | COMMENT |
| LOW | …/endtoend/localprovisioner/refresh_credentials_test.go | 150 | // Step 3: Change AWS credentials in environment | COMMENT |
| LOW | …/endtoend/localprovisioner/refresh_credentials_test.go | 162 | // Step 4: Run refresh-credentials command | COMMENT |
| LOW | …/endtoend/localprovisioner/refresh_credentials_test.go | 178 | // Step 5: Verify credentials file updated with new values | COMMENT |
| LOW | …/endtoend/localprovisioner/refresh_credentials_test.go | 202 | // Step 6: Verify file permissions preserved (0600) | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 98 | // Step 1: Kill postgres on primary to trigger failover | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 102 | // Step 2: Wait for new primary election | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 108 | // Step 3: Write data to new primary to ensure timeline has diverged | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 112 | // Step 4: Re-enable postgres auto-restarts on the old primary. The new | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 120 | // Step 5: Wait for multiorch to detect and repair divergence. Once postgres | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 127 | // Step 6: Verify old primary is now replicating from new primary | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 131 | // Step 7: Verify replication is actually working by writing data and checking it replicates | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 135 | // Step 8: Verify the old primary was demoted via SetPrimary. | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 140 | // Step 9: Verify consensus.recruit event was emitted during failover. | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 196 | // Step 1: Gracefully shutdown postgres on primary to trigger failover. | COMMENT |
| LOW⚡ | go/test/endtoend/multiorch/demote_stale_primary_test.go | 204 | // Step 2: Wait for new primary election | COMMENT |
| 51 more matches not shown… | ||||
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM | demo/k8s/k8s-multipooler-statefulset.yaml | 11 | # =================================================== | COMMENT |
| MEDIUM⚡ | …t/endtoend/queryserving/postgresttests/io_selection.go | 52 | // ── Role settings hoisted per request ─────────────────────────────────── | COMMENT |
| MEDIUM⚡ | …t/endtoend/queryserving/postgresttests/io_selection.go | 58 | // ── Function / hoisted-transaction settings ───────────────────────────── | COMMENT |
| MEDIUM⚡ | …t/endtoend/queryserving/postgresttests/io_selection.go | 66 | // ── Superuser-granted role settings (GRANT SET ON PARAMETER) ───────────── | COMMENT |
| MEDIUM⚡ | …t/endtoend/queryserving/postgresttests/io_selection.go | 70 | // ── Prepared statements through the pooler ────────────────────────────── | COMMENT |
| MEDIUM⚡ | …t/endtoend/queryserving/postgresttests/io_selection.go | 73 | // ── LISTEN/NOTIFY-triggered config & schema reload ────────────────────── | COMMENT |
| MEDIUM | go/common/consensus/proposals_test.go | 240 | // ── outgoing cohort mode ────────────────────────────────────────────────── | COMMENT |
| MEDIUM | go/common/consensus/proposals_test.go | 1039 | // ── incoming cohort mode (bootstrap) ───────────────────────────────────── | COMMENT |
| MEDIUM | go/common/sqltypes/arrays_test.go | 25 | // ── Happy path ─────────────────────────────────────────────────────────── | COMMENT |
| MEDIUM | go/common/sqltypes/arrays_test.go | 96 | // ── Backslash escaping outside of quotes ───────────────────────────────── | COMMENT |
| MEDIUM | go/common/sqltypes/arrays_test.go | 118 | // ── NULL handling ───────────────────────────────────────────────────────── | COMMENT |
| MEDIUM | go/common/sqltypes/arrays_test.go | 138 | // ── Unicode ─────────────────────────────────────────────────────────────── | COMMENT |
| MEDIUM | go/common/sqltypes/arrays_test.go | 146 | // ── Structural errors ───────────────────────────────────────────────────── | COMMENT |
| MEDIUM | go/common/sqltypes/sqltypes.go | 70 | // ───────────────────────────────────────────────────────── | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 48 | // ┌──────────────────────────────────────────────────────────────────┐ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 50 | // ├──────────────────────────────────────────────────────────────────┤ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 52 | // │ ┌─────────────────┐ ┌─────────────────┐ ┌─────────────────┐ │ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 55 | // │ └────────┬────────┘ └────────┬────────┘ └────────┬────────┘ │ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 57 | // │ └────────────────────┼────────────────────┘ │ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 60 | // └──────────────────────────────────────────────────────────────────┘ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 86 | // ┌──────────────────────┐ ManagerHealthStream ┌──────────────────────┐ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 87 | // │ Multipooler │ ──── snapshot ────────> │ HealthStream │ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 89 | // │ 5s poll ticker) │ └──────────┬───────────┘ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 90 | // └──────────────────────┘ │ applySnapshot | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 92 | // ┌──────────────────────┐ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 94 | // └──────────────────────┘ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 103 | // ┌──────────────────────┐ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 104 | // │ Pooler Store │──────────┐ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 106 | // └──────────────────────┘ │ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 108 | // ┌──────────────────────┐ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 111 | // └──────────┬───────────┘ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 114 | // ┌──────────────────────┐ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 117 | // └──────────┬───────────┘ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 120 | // ┌──────────────────────┐ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 123 | // └──────────┬───────────┘ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 126 | // ┌──────────────────────┐ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 129 | // └──────────┬───────────┘ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 132 | // ┌──────────────────────┐ | COMMENT |
| MEDIUM⚡ | go/services/multiorch/recovery/engine.go | 135 | // └──────────────────────┘ | COMMENT |
| MEDIUM⚡ | …multipooler/internal/connpoolmanager/demand_tracker.go | 60 | // ┌─────────────────────────────────────────────────────────────┐ | COMMENT |
| MEDIUM⚡ | …multipooler/internal/connpoolmanager/demand_tracker.go | 62 | // ├───────────────────┬───────────────────┬─────────────────────┤ | COMMENT |
| MEDIUM⚡ | …multipooler/internal/connpoolmanager/demand_tracker.go | 66 | // └───────────────────┴───────────────────┴─────────────────────┘ | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM | codecov.yml | 19 | # PostgreSQL regression / isolation harness lives behind opt-in env | COMMENT |
| MEDIUM⚡ | codecov.yml | 37 | # Shared harness helpers (patch verify/generate, corpus discovery, the | COMMENT |
| MEDIUM⚡ | codecov.yml | 44 | # Row-path micro-benchmarks and the pgbench / large-result benchmark harness | COMMENT |
| MEDIUM⚡ | codecov.yml | 46 | # not the coverage-collecting CI, so their non-test lines (harness helpers) | COMMENT |
| MEDIUM | tools/safe_download.sh | 16 | # safe_download - A robust wrapper around curl for downloading files | COMMENT |
| MEDIUM | tools/setup_build_tools.sh | 573 | # Install sqllogictest-rs CLI (used by the differential SLT harness). | COMMENT |
| MEDIUM | tools/setup_build_tools.sh | 576 | # Build pgproto from source (used by the wire-protocol conformance harness). | COMMENT |
| MEDIUM | go/tools/telemetry/sampler.go | 204 | // to make matching more robust and explicit. For example: | COMMENT |
| MEDIUM | go/test/endtoend/metrics/metrics_test.go | 336 | // but captured as deltas so the test is robust to any residue). | COMMENT |
| MEDIUM | go/test/endtoend/pgregresstest/extensions.go | 103 | {"pg_jsonschema", KindExternal, StatusCovered, "Rust/pgrx JSON Schema validator; ships no SQL suite (upstream tests are | CODE |
| MEDIUM | …st/endtoend/subscriptionwire/subscription_wire_test.go | 101 | // poll to be robust against any lag, then read its recorded state. | COMMENT |
| MEDIUM | go/common/servenv/servenv_unix.go | 258 | // #nosec G703 -- testDataDir comes from MULTIGRES_TESTDATA_DIR (test harness env), not external input. | COMMENT |
| MEDIUM | go/common/pgprotocol/server/conn.go | 151 | // keeps the check robust if c.conn is ever wrapped in instrumentation. | COMMENT |
| MEDIUM | go/common/parser/plpgsql/read_construct.go | 43 | // token's start .. terminator's start), which is robust to how the lexer groups | COMMENT |
| MEDIUM | go/services/multipooler/internal/executor/executor.go | 869 | // this is robust against pg_try_advisory_lock calls that failed, keys locked | COMMENT |
| MEDIUM | scripts/go_test_coverage.sh | 16 | # Development helper script for collecting comprehensive coverage data. | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM⚡ | codecov.yml | 38 | # differential report core, schema-reset and run-loop scaffolding). The | COMMENT |
| MEDIUM | demo/observability/sampling-config.yaml | 12 | # Operations: orchestration, failover, replication management | COMMENT |
| MEDIUM | demo/observability/sampling-config.yaml | 37 | # MultipoolerManager: orchestration and replication management | COMMENT |
| MEDIUM | …rvices/multigateway/engine/apply_session_state_test.go | 1015 | // TestPinnedRouteTracksLiteralWhenNotReported pins the two guardrails on the | COMMENT |
| MEDIUM | go/services/multipooler/internal/manager/rpc_manager.go | 81 | // Check REPLICA guardrails (recovery mode) | COMMENT |
| MEDIUM | go/services/multipooler/internal/manager/rpc_manager.go | 238 | // Check REPLICA guardrails (recovery mode) | COMMENT |
| MEDIUM | go/services/multipooler/internal/manager/rpc_manager.go | 268 | // Check REPLICA guardrails (recovery mode) | COMMENT |
| MEDIUM | go/services/multipooler/internal/manager/rpc_manager.go | 301 | // Check REPLICA guardrails (recovery mode) | COMMENT |
| MEDIUM | go/services/multipooler/internal/manager/rpc_manager.go | 376 | // Acting as primary - get primary status (skip guardrails since we already checked recovery mode) | COMMENT |
| MEDIUM | go/services/multipooler/internal/manager/rpc_manager.go | 386 | // Acting as standby - get replication status (skip guardrails since we already checked recovery mode) | COMMENT |
| MEDIUM | go/services/multipooler/internal/manager/rpc_manager.go | 442 | // Check PRIMARY guardrails (non-recovery mode) | COMMENT |
| MEDIUM | go/services/multipooler/internal/manager/rpc_manager.go | 676 | // Check PRIMARY guardrails (non-recovery mode) | COMMENT |
| MEDIUM | go/services/multipooler/internal/manager/rpc_manager.go | 695 | // Check PRIMARY guardrails (non-recovery mode) | COMMENT |
| MEDIUM | go/services/multipooler/internal/manager/rpc_manager.go | 717 | // Check REPLICA guardrails (recovery mode) | COMMENT |
| MEDIUM | config/multiorch.yaml | 2 | # Cluster orchestration service configuration | COMMENT |
| MEDIUM | docs/query_serving/testing_strategy.md | 318 | ### `multigres.unsafe_connection` for a handful of scaffolding files | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | demo/local/run-with-otel.sh | 9 | # Check if observability stack is running | COMMENT |
| LOW | demo/local/run-observability.sh | 13 | # Check if docker is running | COMMENT |
| LOW | demo/local/run-observability.sh | 19 | # Check if container is already running | COMMENT |
| LOW | tools/setup_s3_cluster.sh | 131 | # Check if cluster already exists | COMMENT |
| LOW | tools/setup_build_tools.sh | 77 | # Check if already installed with correct version | COMMENT |
| LOW | tools/setup_build_tools.sh | 305 | # Check if PostgreSQL repo is already configured | COMMENT |
| LOW | go/test/endtoend/run_in_test.sh | 78 | # Check if testdata directory was deleted | COMMENT |
| LOW | go/test/endtoend/run_in_test.sh | 85 | # Check if monitored process died | COMMENT |
| LOW | go/test/endtoend/run_command_if_parent_dies.sh | 43 | # Check if testdata directory was deleted | COMMENT |
| LOW | …mon/parser/testdata/postgres/convert_postgres_tests.py | 80 | # Check if we're starting a function body or DO block | COMMENT |
| LOW | …mon/parser/testdata/postgres/convert_postgres_tests.py | 127 | # Check if we're ending a function body or DO block | COMMENT |
| LOW | …mon/parser/testdata/postgres/convert_postgres_tests.py | 154 | # Check if statement ends after the definition | COMMENT |
| LOW | …mon/parser/testdata/postgres/convert_postgres_tests.py | 188 | # Check if statement ends after the definition | COMMENT |
| LOW | …mon/parser/testdata/postgres/convert_postgres_tests.py | 200 | # Check if statement ends with semicolon (but ONLY when not inside function body) | COMMENT |
| LOW | …mon/parser/testdata/postgres/convert_postgres_tests.py | 341 | # Check if the statement contains psql variables (colon syntax) | COMMENT |
| LOW | …mon/parser/testdata/postgres/convert_postgres_tests.py | 407 | # Check if this looks like a time pattern | COMMENT |
| LOW | scripts/go_test_coverage.sh | 54 | # Check if coverage binaries exist | COMMENT |
| LOW | scripts/go_test_coverage.sh | 130 | # Check if we have coverage data to merge | COMMENT |
| LOW | scripts/portpool.sh | 21 | # scripts/portpool.sh status # Check if the server is running | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | demo/k8s/backup-restore.sh | 27 | # Usage: | COMMENT |
| LOW | docker/pgregress-generate.sh | 22 | # Usage: | COMMENT |
| LOW | go/tools/retry/retry.go | 25 | // Example usage: | COMMENT |
| LOW | go/tools/retry/retry.go | 193 | // Example usage: | COMMENT |
| LOW | go/tools/timer/periodic_runner.go | 46 | // Example usage: | COMMENT |
| LOW | go/tools/viperutil/registry.go | 48 | // Example usage: | COMMENT |
| LOW | go/tools/viperutil/viper.go | 142 | // Example usage: | COMMENT |
| LOW | go/provisioner/provisioner.go | 26 | // Example usage: | COMMENT |
| LOW | go/common/parser/ast/rewriter_api.go | 33 | // Example usage: | COMMENT |
| LOW | go/common/parser/ast/plpgsqlast/rewriter_api.go | 37 | // Example usage: | COMMENT |
| LOW | scripts/portpool.sh | 18 | # Usage: | COMMENT |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | go/common/pgprotocol/server/query_test.go | 269 | []byte("John Doe"), | CODE |
| LOW | go/common/pgprotocol/client/query.go | 69 | // - SELECT * FROM users WHERE email = 'user@example.com' | COMMENT |
| LOW | go/common/parser/testdata/misc_cases.json | 664 | "query": "CALL update_user(123, 'John Doe')" | CODE |
| LOW | go/common/parser/testdata/misc_cases.json | 729 | "query": "EXECUTE multi_param_plan (123, 'John Doe', TRUE)", | CODE |
| LOW | go/common/parser/testdata/misc_cases.json | 730 | "expected": "EXECUTE multi_param_plan ( 123, 'John Doe', TRUE )" | CODE |
| LOW⚡ | go/common/parser/testdata/postgres/tsearch.json | 560 | "query": "SELECT ts_headline('english', 'Lorem ipsum urna. Nullam nullam ullamcorper urna.', to_tsquery('english',' | CODE |
| LOW⚡ | go/common/parser/testdata/postgres/tsearch.json | 561 | "expected": "SELECT ts_headline('english', 'Lorem ipsum urna. Nullam nullam ullamcorper urna.', to_tsquery('english | CODE |
| LOW⚡ | go/common/parser/testdata/postgres/tsearch.json | 565 | "query": "SELECT ts_headline('english', 'Lorem ipsum urna. Nullam nullam ullamcorper urna.', phraseto_tsquery('engl | CODE |
| LOW⚡ | go/common/parser/testdata/postgres/tsearch.json | 566 | "expected": "SELECT ts_headline('english', 'Lorem ipsum urna. Nullam nullam ullamcorper urna.', phraseto_tsquery('e | CODE |
| LOW | go/common/parser/testdata/postgres/tsearch.json | 589 | "query": "SELECT ts_headline('english', 'Lorem ipsum urna. Nullam nullam ullamcorper urna.', to_tsquery('english',' | CODE |
| LOW | go/common/parser/testdata/postgres/tsearch.json | 590 | "expected": "SELECT ts_headline('english', 'Lorem ipsum urna. Nullam nullam ullamcorper urna.', to_tsquery('english | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| MEDIUM | demo/local/run-observability.sh | 53 | # Create a temporary directory for dashboard provisioning config | COMMENT |
| MEDIUM | tools/tool_checksums.sh | 17 | # This file contains verified checksums for binary downloads used in the project. | COMMENT |
| MEDIUM | go/cmd/multigres/command/root.go | 60 | multigres cluster init # Create a local cluster configuration | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | …mon/parser/testdata/postgres/convert_postgres_tests.py | 44 | CODE | |
| LOW | …mon/parser/testdata/postgres/convert_postgres_tests.py | 244 | CODE | |
| LOW | …mon/parser/testdata/postgres/convert_postgres_tests.py | 292 | CODE | |
| LOW | …mon/parser/testdata/postgres/convert_postgres_tests.py | 328 | CODE | |
| LOW | …mon/parser/testdata/postgres/convert_postgres_tests.py | 361 | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | …mon/parser/testdata/postgres/convert_postgres_tests.py | 292 | def extract_content_after_metacommand(line: str) -> str: | CODE |
| LOW | …mon/parser/testdata/postgres/convert_postgres_tests.py | 328 | def handle_parameterized_queries(stmt: str) -> Optional[str]: | CODE |
| LOW | web/multiadmin/components/topology-graph.tsx | 95 | function calculateLagFromTimestamp(timestamp: string): string { | CODE |
| LOW | web/multiadmin/components/ui/chart.tsx | 308 | function getPayloadConfigFromPayload( | CODE |
| Severity | File | Line | Snippet | Context |
|---|---|---|---|---|
| LOW | …mon/parser/testdata/postgres/convert_postgres_tests.py | 618 | except Exception as e: # pylint: disable=broad-exception-caught | CODE |