SHOW INDEX
SafeInspect indexes
SHOW INDEX FROM <table>;
Shows indexes and cardinality — when EXPLAIN says full scan, check whether a usable index even exists.
Examples
SHOW INDEX FROM orders;Index columns and stats
Syntax
SHOW INDEX FROM table; / \d table(psql)
Before you run it
Read only.
Related commands
- CREATE INDEXCreate an index
- EXPLAINQuery plan
The same reference, with no signal at all
Every command and flow from this site, held on your device and searchable with no connection. Free to install, no ads.
Get it free on the App Store