Skip to content

Instantly share code, notes, and snippets.

@Madusudanan

Madusudanan/pg_plan_seq_2

Created May 10, 2016 04:53
Show Gist options
  • Save Madusudanan/81e0d7cd6735a76d9642cd273f054171 to your computer and use it in GitHub Desktop.
Save Madusudanan/81e0d7cd6735a76d9642cd273f054171 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
pg_plan_seq_2
performance_test=# explain (analyze,buffers) select count(*) from users;
QUERY PLAN
----------------------------------------------------------------------------------------------------------------------
Aggregate (cost=48214.95..48214.96 rows=1 width=0) (actual time=426.385..426.385 rows=1 loops=1)
Buffers: shared hit=32 read=35683
-> Seq Scan on users (cost=0.00..45714.96 rows=999996 width=0) (actual time=0.036..285.363 rows=1000000 loops=1)
Buffers: shared hit=32 read=35683
Planning time: 0.048 ms
Execution time: 426.431 ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment