visibletrap.blogspot.com

tAp's blog

Monday, July 13, 2015. PostgreSQL] List index usage. This query is much cooler Index size/usage statistics. In psql console, connect to the database you want to check its indexes usage. Then execute this query. SELECT * FROM pg stat user indexes ORDER BY idx scan DESC;. If your database is manage by Rails's schema, you could filter out auto generated public key indexes like so. SELECT * FROM pg stat user indexes WHERE indexrelname NOT LIKE '% pkey' ORDER BY idx scan DESC;. Tuesday, June 16, 2015. Be sure...

http://visibletrap.blogspot.com/

OVERVIEW OF visibletrap.blogspot.com

TRAFFIC RANK

>1,000,000

REVIEWS

0

PAGES IN THIS WEBSITE

20

LINKS TO THIS WEBSITE

CONTACTS

ADDRESSES

SOCIAL LINKS

ONLINE SINCE

WEBSITE DETAILS

SEO

PAGES

SIMILAR SITES

TRAFFIC RANK FOR VISIBLETRAP.BLOGSPOT.COM

TODAY'S RATING

>1,000,000

TRAFFIC RANK - AVERAGE PER MONTH

BEST MONTH

December

AVERAGE PER DAY Of THE WEEK

HIGHEST TRAFFIC ON

Thursday

TRAFFIC BY CITY

Sign up

CUSTOMER REVIEWS

Average Rating: 4.3 out of 5 with 7 reviews

5 star

2

4 star

5

3 star

0

2 star

0

1 star

0

Hey there! Start your review of visibletrap.blogspot.com

AVERAGE USER RATING

Write a Review

WEBSITE PREVIEW

LOAD TIME

0.5 seconds

FAVICON PREVIEW

16x16
32x32
64x64
128x128

CONTACTS AT VISIBLETRAP.BLOGSPOT.COM

ADD CONTACT

Login

TO VIEW CONTACTS

Remove Contacts

FOR PRIVACY ISSUES

CONTENT

PAGES IN
THIS WEBSITE

20

SSL

EXTERNAL LINKS

1

SITE IP

216.58.216.193

LOAD TIME

0.453 sec

SCORE

6.2

PAGE TITLE

tAp's blog | visibletrap.blogspot.com Reviews

<META> DESCRIPTION

Monday, July 13, 2015. PostgreSQL] List index usage. This query is much cooler Index size/usage statistics. In psql console, connect to the database you want to check its indexes usage. Then execute this query. SELECT * FROM pg stat user indexes ORDER BY idx scan DESC;. If your database is manage by Rails's schema, you could filter out auto generated public key indexes like so. SELECT * FROM pg stat user indexes WHERE indexrelname NOT LIKE '% pkey' ORDER BY idx scan DESC;. Tuesday, June 16, 2015. Be sure...

<META> KEYWORDS

1 tap's blog

2 update

3 posted by

4 no comments

5 email this

6 blogthis

7 share to twitter

8 share to facebook

9 share to pinterest

10 labels postgresql

CONTENT

Page content here

KEYWORDS ON PAGE

tap's blog,update,posted by,no comments,email this,blogthis,share to twitter,share to facebook,share to pinterest,labels postgresql,rails,labels git,or state change,like so;,labels clojure,leiningen,set sidescroll=1,duplicate,thanks @iporsut,labels vim

SERVER

GSE

CONTENT-TYPE

utf-8

GOOGLE PREVIEW

tAp's blog | visibletrap.blogspot.com Reviews

https://visibletrap.blogspot.com

Monday, July 13, 2015. PostgreSQL] List index usage. This query is much cooler Index size/usage statistics. In psql console, connect to the database you want to check its indexes usage. Then execute this query. SELECT * FROM pg stat user indexes ORDER BY idx scan DESC;. If your database is manage by Rails's schema, you could filter out auto generated public key indexes like so. SELECT * FROM pg stat user indexes WHERE indexrelname NOT LIKE '% pkey' ORDER BY idx scan DESC;. Tuesday, June 16, 2015. Be sure...

INTERNAL PAGES

visibletrap.blogspot.com

1

tAp's blog: [PostgreSQL] List running queries

http://visibletrap.blogspot.com/2015/05/postgresql-list-running-queries.html

Monday, May 25, 2015. PostgreSQL] List running queries. In psql, run this command. Select * from pg stat activity where datname = YOUR DB NAME. And state = 'active'. You might also what to order the result by query start. Subscribe to: Post Comments (Atom). PostgreSQL] List running queries. This is a link to my profile. View my complete profile. Simple template. Powered by Blogger.

2

tAp's blog: [PostgreSQL] Using some indexes from Composite index

http://visibletrap.blogspot.com/2015/06/postgresql-using-some-indexes-from.html

Tuesday, June 9, 2015. PostgreSQL] Using some indexes from Composite index. If we had a composite index on three fields: we would be able to use it for queries on the first field, for queries on the first two fields and for queries involving all three fields, but not on any other field combination. Copied directly from How to stop worrying and love your Postgres indexes. Subscribe to: Post Comments (Atom). Sort file name by number of changes in git history. This is a link to my profile.

3

tAp's blog: June 2014

http://visibletrap.blogspot.com/2014_06_01_archive.html

Saturday, June 7, 2014. Clone a PostgreSQL database. At some point in development, you may want to make a copy of your existing development database to play with an unstable new feature. Postgres makes it super trivial to do that by allow us to create a new database by using existing database as a template. In postgres console, run. CREATE DATABASE new database name WITH TEMPLATE original database name;. You got a cloned database named new database name. Credit: Creating a copy of a database in Postgres.

4

tAp's blog: June 2015

http://visibletrap.blogspot.com/2015_06_01_archive.html

Tuesday, June 16, 2015. Sort file name by number of changes in git history. Git log - pretty=format: - name-only sort uniq -c sort -rg less. Literally copied from the answer of " Finding most changed files in git. Tuesday, June 9, 2015. PostgreSQL] Using some indexes from Composite index. Copied directly from How to stop worrying and love your Postgres indexes. Subscribe to: Posts (Atom). Sort file name by number of changes in git history. PostgreSQL] Using some indexes from Composite ind.

5

tAp's blog: VIM - How to format and syntax highlight JSON file

http://visibletrap.blogspot.com/2010/05/vim-how-to-format-and-syntax-highlight.html

Monday, May 10, 2010. VIM - How to format and syntax highlight JSON file. Run this command in shell. Put this line to /.vimrc. When want to format JSON file press. Credit : “tidify” a json in vim. Download json.vim form http:/ www.vim.org/scripts/script.php? Put this line to /.vimrc. Au BufRead,BufNewFile *.json set filetype=json. Credit : Add JSON syntax highlighting in Vim on OS X. You missed the y on the end of pretty. :). April 11, 2011 at 10:56 PM. Its good post, thanks :). April 14, 2011 at 8:48 AM.

UPGRADE TO PREMIUM TO VIEW 15 MORE

TOTAL PAGES IN THIS WEBSITE

20

SOCIAL ENGAGEMENT

iporsut

OTHER SITES

visibletracks.wordpress.com

visibletracks | documenting WAKE & ARCHIPELAGO, a constantly evolving programme of installations, performances and interventions created by over 20 artists. WAKE and ARCHIPELAGO are produced by Artsadmin in association with CGP London and supported by

Films by Olga Koroleva and Publications by Hydar Dewachi now available online…. Latest from @wake arch on Twitter. Up online by @ artsadm. I wrote a little something about the projects earlier in the year twitter.com/iok. RT @ laura milnes. Tonight's the launch of the @ wake arch. Film and online publications. Excited to welcome the gang back to Toynbee Studi . 3 years ago. The Barbican Centre's Extraordinary Voices Weekender should get you singing http:/ bit.ly/qEsekr. Sponsor) 4 years ago. Following th...

visibletrade.com

Price Request - BuyDomains

Url=' escape(document.location.href) , 'Chat367233609785093432', 'toolbar=0,scrollbars=0,location=0,statusbar=0,menubar=0,resizable=0,width=640,height=500');return false;". Need a price instantly? Just give us a call. Toll Free in the U.S. We can give you the price over the phone, help you with the purchase process, and answer any questions. Get a price in less than 24 hours. Fill out the form below. One of our domain experts will have a price to you within 24 business hours. United States of America.

visibletransformation.com

www.visibletransformation.com

visibletransformations-lbc.com

Coming Soon

Powered by InstantPage® from GoDaddy.com. Want one?

visibletransformations.com

Beauty Salon | Hair Salon | Barbershop | Houston, Texas

Need to transform your style or maybe you just want to maintain your style. You can. Staff to make you look good and feel good. Our stylists are skilled in the. And trends or can customize a look just right for your. Come in today for a. To make an appointment, book online. Visible Transformations will be opening in Houston, Texas. Stay tuned for more details.

visibletrap.blogspot.com

tAp's blog

Monday, July 13, 2015. PostgreSQL] List index usage. This query is much cooler Index size/usage statistics. In psql console, connect to the database you want to check its indexes usage. Then execute this query. SELECT * FROM pg stat user indexes ORDER BY idx scan DESC;. If your database is manage by Rails's schema, you could filter out auto generated public key indexes like so. SELECT * FROM pg stat user indexes WHERE indexrelname NOT LIKE '% pkey' ORDER BY idx scan DESC;. Tuesday, June 16, 2015. Be sure...

visibletrap.github.io

About Me by visibletrap

View My GitHub Profile. Hi I'm Nuttanart Pornprasitsakul or you can call me Tap. I'm a programmer who favor on product quality and life happiness. I'm a generalist but most familiar with Ruby on Rails stack and Clojure. I know a little about Object-Oriented design, Functional programming concepts, Test-driven development, Developer testing, API design, Agile development thought and I also have some experiences with Unix, Redis, PostgreSQL, Ansible, Docker and Java. Find out more about me.

visibletrap.wordpress.com

Tap | Programmer Story

แนวทางการ design api บน Clojure. ว นน ไปเจอโปรเจ คเล ก ๆ ท ช อว า progrock. ซ งเป นไลบราล ท ช วยในการวาด progress bar บน Clojure. ด วยความท ม นเล ก แก ป ญหาท เข าใจง าย และม ขอบเขตช ดเจนน เอง ผมจ งร ส กว าม นเป นโปรเจ คสำหร บการศ กษาการจ ดวางโค ด Clojure ท ด เลย ด วยขนาด code แค 100 บรรท ด และ test อ ก 50 บรรท ด ทำให น าจะเข าใจได ง าย. จ ดส งเกตหน งท ผมอยากจะกล าวถ งสำหร บโปรเจ คน ค อ Clojure api design เน นให ความสำค ญก บ data เสมอ จะเห นว าหน าตาของ data จะอย ในส วนต นๆ ของ README. การ เข ยน test.

visibletrash.com

Best Home Improvement Ideas | Home Improvement Gallery

Best Home Improvement Ideas Home Improvement Gallery. Transition From Tile To Carpet Stairs. August 12, 2015. Terra Cotta Tile Flooring. August 12, 2015. Terra Cotta Tile Flooring Price. August 12, 2015. Peel And Stick Glass Tile Backsplash. August 12, 2015. Peel And Stick Glass Tile Backsplash Kit. August 12, 2015. Transition From Tile To Carpet Stairs. Terra Cotta Tile Flooring. Terra Cotta Tile Flooring Price. Peel And Stick Glass Tile Backsplash. Peel And Stick Glass Tile Backsplash Kit.

visibletreasures.blogspot.com

Adventures of the Cautious

Adventures of the Cautious. We are serving under Evangelical Mennonite Conference. Chihuahua State, Mexico. Cuauhtemoc is in the south west corner of Chihuahua State (the orange part). Monday, October 31, 2011. Thanks to my mom mentioning this, some of you may have been looking here to read about us and see we haven't written since May. We have actually been writing, but on our other blog. So you'll hear more about us if you click on the link above that says Our Family Adventures, or click here. We came ...

visibletreasures2.blogspot.com

Our Family Adventures

Thursday, March 13, 2014. Why do I put myself through guilt of not writing here? Why do I spend so much time trying to think of what to write and end up sitting here blank looking at the screen? Thank you for reading here over the years, praying for us, loving us, and encouraging us. It's been quite the adventure, and now that chapter is slowly closing as we wait for a new one to begin. Wednesday, January 22, 2014. Monday, January 20, 2014. Starting to settle in. And just like that my thoughts have alrea...