Skip to content

Instantly share code, notes, and snippets.

@bmbouter

bmbouter/sql_query_output_showing_index_scan

Created March 6, 2020 15:26
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 bmbouter/4eff2c9376232a3c66340aeb248085d9 to your computer and use it in GitHub Desktop.
Save bmbouter/4eff2c9376232a3c66340aeb248085d9 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
sql_query_output_showing_index_scan
pulp=> explain select * from core_content where pulp_id = 'c310ae21-3c34-4c8c-a6a5-1985f244581d';
QUERY PLAN
---------------------------------------------------------------------------------------
Index Scan using core_content_pkey on core_content (cost=0.29..8.30 rows=1 width=59)
Index Cond: (pulp_id = 'c310ae21-3c34-4c8c-a6a5-1985f244581d'::uuid)
(2 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment