# Databases : PostgreSQL : Explain
```sql
EXPLAIN SELECT * FROM migrations;
QUERY PLAN
---------------------------------------------------------------
Seq Scan on migrations (cost=0.00..13.40 rows=340 width=208)
(1 row)
```
```sql
EXPLAIN ( VERBOSE ) SELECT * FROM migrations;
QUERY PLAN
----------------------------------------------------------------------
Seq Scan on public.migrations (cost=0.00..13.40 rows=340 width=208)
Output: number, filename, sha1, ts
(2 rows)
```
```sql
EXPLAIN ( FORMAT JSON ) SELECT * FROM migrations;
QUERY PLAN
--------------------------------------
[ +
{ +
"Plan": { +
"Node Type": "Seq Scan", +
"Parallel Aware": false, +
"Async Capable": false, +
"Relation Name": "migrations",+
"Alias": "migrations", +
"Startup Cost": 0.00, +
"Total Cost": 13.40, +
"Plan Rows": 340, +
"Plan Width": 208 +
} +
} +
]
(1 row)
```
```sql
EXPLAIN ( FORMAT JSON, VERBOSE ) SELECT * FROM migrations;
QUERY PLAN
------------------------------------------------------
[ +
{ +
"Plan": { +
"Node Type": "Seq Scan", +
"Parallel Aware": false, +
"Async Capable": false, +
"Relation Name": "migrations", +
"Schema": "public", +
"Alias": "migrations", +
"Startup Cost": 0.00, +
"Total Cost": 13.40, +
"Plan Rows": 340, +
"Plan Width": 208 +
"Output": ["number", "filename", "sha1", "ts"]+
} +
} +
]
(1 row)
```