Skip to content

Instantly share code, notes, and snippets.

@dramsay
Created January 10, 2020 14:38
Show Gist options
  • Save dramsay/3111bd14953bc9a808e40c0b94029c61 to your computer and use it in GitHub Desktop.
Save dramsay/3111bd14953bc9a808e40c0b94029c61 to your computer and use it in GitHub Desktop.
explain (analyze on, timing on) select * from foo where id = 500000;
QUERY PLAN
— — — — — — — — — — — — — — —
Index Scan using foo_id_ix on foo (cost=0.42..8.44 rows=1 width=37) (actual time=0.026..0.028 rows=1 loops=1)
Index Cond: (id = 500000)
Execution time: 0.060 ms
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment