Explain
PostgreSQL Optimize: Explain
Categories:
Explain
Explain Query
EXPLAIN SELECT count(*) FROM users;
QUERY PLAN |
-------------------------------------------------------------+
Aggregate (cost=19.50..19.51 rows=1 width=8) |
-> Seq Scan on users (cost=0.00..17.00 rows=1000 width=0)|
Explain analyze
EXPLAIN ANALYZE SELECT * FROM users ORDER BY username;
QUERY PLAN |
---------------------------------------------------------------------------------------------------------------------------------+
Index Scan using people_username_idx on users (cost=0.28..28.27 rows=1000 width=17) (actual time=0.052..1.494 rows=1000 loops=1)|
Planning Time: 0.186 ms |
Execution Time: 1.686 ms