Skip to content

Instantly share code, notes, and snippets.

{
"clientTracking":{
"hrefURL":"http://www.shopping.com/flowers-and-plants/products",
"titleText":"Flowers and Plants",
"altText":"Flowers and Plants",
"sourceURL":"https://rover.ebay.com/rover/13/0/19/pixel/noscript?PV_EvnTyp=APPV&APPV_APITSP=10%2F26%2F16_05%3A03%3A43_AM&APPV_DSPRQSID=p9.84c601f422cd131102a3&APPV_IMGURL=&APPV_LI_LNKINID=7000610&APPV_LI_SBMKYW=60+Silk+Iris+Flowers+-+New+Blue&APPV_MTCTYP=1000&APPV_PRTID=2002&APPV_BrnID=2455",
"height":"1",
"width":"1",
"type":"pixel"
},
-- Index hit rate
WITH idx_hit_rate as (
SELECT
relname as table_name,
n_live_tup,
round(100.0 * idx_scan / (seq_scan + idx_scan),2) as idx_hit_rate
FROM pg_stat_user_tables
ORDER BY n_live_tup DESC
),
##
# Calendar helper with proper events
# http://www.cuppadev.co.uk/webdev/making-a-real-calendar-in-rails/
#
# (C) 2009 James S Urquhart (jamesu at gmail dot com)
# Derived from calendar_helper
# (C) Jeremy Voorhis, Geoffrey Grosenbach, Jarkko Laine, Tom Armitage, Bryan Larsen
# Licensed under MIT. http://www.opensource.org/licenses/mit-license.php
##