Skip to content

Instantly share code, notes, and snippets.

@mbork

mbork/02-04-pytanie-1

Created March 4, 2020 21:54
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 mbork/e607c1569f5482bc49f13e5dab9cfd45 to your computer and use it in GitHub Desktop.
Save mbork/e607c1569f5482bc49f13e5dab9cfd45 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
02-04-pytanie-1
postgres=# EXPLAIN analyze SELECT * FROM SalesOrderDetail
postgres-# WHERE Qty=12 AND Rebate =6;
QUERY PLAN
---------------------------------------------------------------------------------------------------------------
Seq Scan on salesorderdetail (cost=0.00..494.15 rows=30 width=26) (actual time=0.278..5.196 rows=28 loops=1)
Filter: ((qty = 12) AND (rebate = 6))
Rows Removed by Filter: 22049
Planning Time: 0.140 ms
Execution Time: 5.224 ms
(5 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment