Skip to content

Instantly share code, notes, and snippets.

@nicolasiensen

nicolasiensen/count_users.sql

Created December 17, 2014 12:52
Show Gist options
  • Star 0 You must be signed in to star a gist
  • Fork 0 You must be signed in to fork a gist
  • Save nicolasiensen/ca85e509ce18f3757466 to your computer and use it in GitHub Desktop.
Save nicolasiensen/ca85e509ce18f3757466 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
count_users.sql
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