Spike Curtis 353888a5d8 feat: add src_id and dst_id indexes to tailnet_tunnels (#12911) ...

Fixes #12780

Adds indexes to the `tailnet_tunnels` table to speed up `GetTailnetTunnelPeerIDs` and `GetTailnetTunnelPeerBindings` queries, which match on `src_id` and `dst_id`.

(cherry picked from commit a231b5aef5)

2024-04-17 21:01:39 +00:00

..

awsiamrds

feat: add awsiamrds db auth driver (#12566)

2024-03-20 13:14:43 -04:00

db2sdk

chore: remove organization requirement from convertGroup() (#12195)

2024-02-21 15:58:11 -06:00

dbauthz

chore: merge authorization contexts (#12816)

2024-03-29 10:14:27 -05:00

dbfake

fix(support): sanitize manifest (#12711)

2024-03-21 19:55:34 +00:00

dbgen

feat(coderd/database): add dbrollup service to rollup insights (#12665)

2024-03-22 18:42:43 +02:00

dbmem

feat: expose workspace statuses (with details) as a prometheus metric (#12762)

2024-04-02 09:57:36 +02:00

dbmetrics

feat(coderd/database): add template_usage_stats table and rollup query (#12664)

2024-03-22 18:33:34 +02:00

dbmock

feat(coderd/database): add template_usage_stats table and rollup query (#12664)

2024-03-22 18:33:34 +02:00

dbpurge

feat(coderd/database): add dbrollup service to rollup insights (#12665)

2024-03-22 18:42:43 +02:00

dbrollup

test(coderd): enable dbrollup service for insights tests (#12673)

2024-03-22 20:18:20 +02:00

dbtestutil

chore(ci): clean up databases after test finishes in CI (#12702)

2024-03-21 14:53:16 +00:00

dbtime

refactor(coderd/database): split Time and Now into dbtime package (#9482)

2023-09-01 16:50:12 +00:00

gen/dump

chore(ci): clean up databases after test finishes in CI (#12702)

2024-03-21 14:53:16 +00:00

gentest

chore: unit test to enforce authorized queries match args (#11211)

2023-12-15 20:31:07 +00:00

migrations

feat: add src_id and dst_id indexes to tailnet_tunnels (#12911)

2024-04-17 21:01:39 +00:00

provisionerjobs

feat: integrate Acquirer for provisioner jobs (#9717)

2023-09-19 10:25:57 +04:00

pubsub

chore(ci): clean up databases after test finishes in CI (#12702)

2024-03-21 14:53:16 +00:00

queries

feat: expose workspace statuses (with details) as a prometheus metric (#12762)

2024-04-02 09:57:36 +02:00

.gitignore

feat: add audit logging database schema (#1225)

2022-05-02 19:30:46 +00:00

db_test.go

chore(ci): clean up databases after test finishes in CI (#12702)

2024-03-21 14:53:16 +00:00

db.go

feat: add provisioner job hang detector (#7927)

2023-06-25 13:17:00 +00:00

dump.sql

feat: add src_id and dst_id indexes to tailnet_tunnels (#12911)

2024-04-17 21:01:39 +00:00

errors.go

feat(coderd/database): generate foreign key constraints and add database.IsForeignKeyViolation (#9657)

2023-09-13 13:28:46 +01:00

foreign_key_constraint.go

chore: add organization_id column to provisioner daemons (#12356)

2024-03-06 12:04:50 -06:00

generate.sh

chore: avoid dbmock test errors in dbgen (#10923)

2023-11-28 17:04:25 +00:00

lock.go

feat(coderd/database): add dbrollup service to rollup insights (#12665)

2024-03-22 18:42:43 +02:00

modelmethods.go

feat: add oauth2 token exchange (#12196)

2024-02-20 14:58:43 -09:00

modelqueries_internal_test.go

chore: Rewrite rbac rego -> SQL clause (#5138)

2022-11-28 12:12:34 -06:00

modelqueries.go

feat: expose workspace statuses (with details) as a prometheus metric (#12762)

2024-04-02 09:57:36 +02:00

models.go

feat(coderd/database): add template_usage_stats table and rollup query (#12664)

2024-03-22 18:33:34 +02:00

no_slim_slim.go

chore(coderd/database): introduce compile-time guard against import in slim build (#9521)

2023-09-04 19:01:11 +00:00

no_slim.go

chore(coderd/database): introduce compile-time guard against import in slim build (#9521)

2023-09-04 19:01:11 +00:00

querier_test.go

chore: enforce that provisioners can only acquire jobs in their own organization (#12600)

2024-03-18 12:48:13 -05:00

querier.go

feat(coderd/database): use template_usage_stats in *ByTemplate insights queries (#12668)

2024-03-25 17:42:02 +02:00

queries.sql.go

feat: expose workspace statuses (with details) as a prometheus metric (#12762)

2024-04-02 09:57:36 +02:00

sqlc.yaml

feat(coderd/database): add template_usage_stats table and rollup query (#12664)

2024-03-22 18:33:34 +02:00

tx_test.go

chore: mockgen archived, moved to new location (#11415)

2024-01-04 18:35:56 -06:00

tx.go

feat: expose Everyone group through UI (#9117)

2023-08-17 13:25:16 -05:00

types.go

chore(codersdk): move all tailscale imports out of codersdk (#12735)

2024-03-26 12:44:31 -05:00

unique_constraint.go

chore: enforce unique linked_ids (#12815)

2024-04-03 13:17:11 -05:00