Skip to content

Instantly share code, notes, and snippets.

Embed
What would you like to do?
EXPLAIN ANALYZE SELECT count(*) FROM users;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=166.31..166.32 rows=1 width=0) (actual time=1720.265..1720.266 rows=1 loops=1)
-> Foreign Scan on users (cost=100.00..164.61 rows=3413 width=0) (actual time=2.437..1606.006 rows=118069 loops=1)
Total runtime: 1722.674 ms
(3 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment
You can’t perform that action at this time.