Skip to content

Instantly share code, notes, and snippets.

@osiro

osiro/sample.sh

Created July 1, 2014 14:13
Show Gist options
  • Save osiro/efa199e5f14e34e7c5e9 to your computer and use it in GitHub Desktop.
Save osiro/efa199e5f14e34e7c5e9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sample.sh
EXPLAIN SELECT * FROM users WHERE LOWER(full_name) LIKE 'vinny%';
QUERY PLAN
----------------------------------------------------------------------------
Seq Scan on users (cost=10000000000.00..10000000001.01 rows=1 width=1784)
Filter: (lower((full_name)::text) ~~ 'vinny%'::text)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment