Database governance built for humans and agents — controlling changes and access across every major database.
Go cicddata-governancedata-maskingdata-securitydatabase-accessdatabase-governancedevopsdevsecopsflywaygitopsliquibasemongodbmysqloraclepostgresqlschema-migrationssecuritysql-clientsqlservertidb
distribution: local
vectorized: true
• root
│
├── • update
│ │ table: t
│ │ set: v
│ │ auto commit
│ │
│ └── • render
│ │
│ └── • index join
│ │ estimated row count: 100
│ │ table: t@t_pkey
│ │ locking strength: for update
│ │
│ └── • scan
│ estimated row count: 100 (10% of the table; stats collected 40 seconds ago)
│ table: t@idx_c
│ spans: [ - /9]
│ locking strength: for update
│
└── • subquery
│ id: @S1
│ original sql: (SELECT v FROM s JOIN t ON t.id = s.id LIMIT 1)
│ exec mode: one row
│
└── • limit
│ count: 1
│
└── • lookup join
│ estimated row count: 100
│ table: s@s_pkey
│ equality: (id) = (id)
│ equality cols are key
│
└── • scan
estimated row count: 100 - 1,000 (100% of the table; stats collected 40 seconds ago)
table: t@t_pkey
spans: FULL SCAN (SOFT LIMIT)
index recommendations: 1
1. type: index replacement
SQL commands: CREATE INDEX ON capture.public.t (c) STORING (d, grp, v) /* After successfully creating the replacement index, manually run: `ALTER INDEX capture.public.t@idx_c NOT VISIBLE` and then, after verifying workload performance, manually run: `DROP INDEX capture.public.t@idx_c` */;