Object pages

Click an object in the explorer to open it. Index, sequence, routine, view and type pages are Pro.

The frame

• Header: schema.name, kind, table link, Copy name, Refresh.
• All properties and DDL, folded, with Copy and Open in console.

Free and Pro

On Free, a Pro page shows the header, Definition (the DDL) and, over a blurred silhouette of the page with nothing of the object drawn in it, a panel such as Index details are part of Pro. It lists Sections in Pro and offers Start 14-day free trial and Already have Pro? Enter your key. Table sub-pages and schema reports are Free, and a probe on them, Estimate bloat on PostgreSQL, Check index pages on MySQL and MariaDB, Measure free space on SQLite, carries the Pro badge.

Each kind

• Index: Usage, Key and sample entries, Queries it can answer, With and without this index, Where the space goes, Overlapping indexes.
• Sequence: How much is left, Latest values, Who takes values from it, Who can use it, Widening the column.
• Function or procedure: How to call it, Who can run it, and as whom, Declared vs. body, How often it runs, Who uses it and what it touches, Body, Try it.
• View: Snapshot freshness for a materialized view, Lineage with what it reads from, returns and is used by, Query shape, Security. A materialized view created or refreshed WITH NO DATA says so.
• Type: Labels in sort order and How often each label is used for an enum, the rules from the default down to the base type for a domain, Fields in order and A sample value for a composite, Bounds for a range, then What uses it. Extensions: installed tiles and Available on this server, not installed.

Views, materialized views and partitions also open as rows in the data grid, from Open rows in the explorer menu. Object tabs come back after a restart; one whose object is gone offers Close tab.

Table pages and schema reports

• Indexes: Matrix or List, a verdict per index.
• Constraints: every rule, NOT VALID violation counts, All constraints.
• Triggers: each trigger with its detail and DDL.
• Access: roles against privileges, and row-level security policies.
• Partitions: a range timeline, list groups or hash buckets.
• Schema reports: Columns (All, Mixed types, Mostly empty), Indexes (Map or Table, Needs a look, Estimate bloat), Constraints (what points where), Sequences (runway).

Engines

Read: What does this table do?