Skip to content

Instantly share code, notes, and snippets.

@joevandyk

joevandyk/gist:8946810

Created February 11, 2014 23:45
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 joevandyk/8946810 to your computer and use it in GitHub Desktop.
Save joevandyk/8946810 to your computer and use it in GitHub Desktop.
Download ZIP
Raw
gistfile1.txt
QUERY PLAN
---------------------------------------------------------------------------------------------------------------------------------------------------------------
Append (cost=0.00..65.76 rows=10 width=109) (actual time=0.126..0.126 rows=0 loops=1)
-> Seq Scan on medias (cost=0.00..0.00 rows=1 width=588) (actual time=0.000..0.000 rows=0 loops=1)
Filter: (id = 2)
-> Index Scan using channel_medias_pkey on channel_medias (cost=0.28..8.29 rows=1 width=66) (actual time=0.015..0.015 rows=0 loops=1)
Index Cond: (id = 2)
-> Index Scan using product_medias_id_media_of_id_idx on product_medias (cost=0.29..8.31 rows=1 width=58) (actual time=0.007..0.007 rows=0 loops=1)
Index Cond: (id = 2)
-> Index Scan using comment_medias_pkey on comment_medias (cost=0.28..8.30 rows=1 width=51) (actual time=0.014..0.014 rows=0 loops=1)
Index Cond: (id = 2)
-> Index Scan using crossword_word_medias_pkey on crossword_word_medias (cost=0.29..8.30 rows=1 width=48) (actual time=0.010..0.010 rows=0 loops=1)
Index Cond: (id = 2)
-> Index Scan using highlighted_link_medias_id_idx on highlighted_link_medias (cost=0.28..8.29 rows=1 width=68) (actual time=0.015..0.015 rows=0 loops=1)
Index Cond: (id = 2)
-> Index Scan using profile_medias_pkey on profile_medias (cost=0.28..8.30 rows=1 width=52) (actual time=0.010..0.010 rows=0 loops=1)
Index Cond: (id = 2)
-> Index Scan using puzzle_medias_pkey on puzzle_medias (cost=0.29..8.30 rows=1 width=50) (actual time=0.012..0.012 rows=0 loops=1)
Index Cond: (id = 2)
-> Seq Scan on tanga_badge_medias (cost=0.00..1.31 rows=1 width=54) (actual time=0.008..0.008 rows=0 loops=1)
Filter: (id = 2)
Rows Removed by Filter: 25
-> Seq Scan on vendor_medias (cost=0.00..6.34 rows=1 width=53) (actual time=0.033..0.033 rows=0 loops=1)
Filter: (id = 2)
Rows Removed by Filter: 187
Total runtime: 0.224 ms
(24 rows)
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment