joelonsql / Joel on

Robots.txt Information

Robot	Path	Permission
GoogleBot	/	✔
BingBot	/	✔
BaiduSpider	/	✔
YandexBot	/	✔
# If you are regularly crawling WordPress.com sites, please use our firehose to receive real-time push updates instead. # Please see https://developer.wordpress.com/docs/firehose/ for more details. Sitemap: https://joelonsql.com/sitemap.xml Sitemap: https://joelonsql.com/news-sitemap.xml User-agent: * Disallow: /wp-admin/ Allow: /wp-admin/admin-ajax.php Disallow: /wp-login.php Disallow: /wp-signup.php Disallow: /press-this.php Disallow: /remote-login.php Disallow: /activate/ Disallow: /cgi-bin/ Disallow: /mshots/v1/ Disallow: /next/ Disallow: /public.api/ # This file was generated on Wed, 01 Feb 2023 18:16:26

Meta Tags

Title	Joel on
Description	Menu Skip to primary content Home About Search Joel on SQL Using pg_badplan to CREATE STATISTICS is a good plan Thanks to Thomas Vondra’s presentation CRE
Keywords	N/A

Server Information

WebSite	joelonsql.com
Host IP	192.0.78.24
Location	United States

Related Websites

                        Site
                        Rank
                    

More to Explore

joelonsql.com Valuation

US$302,658

Last updated: 2023-05-14 12:08:06

joelonsql.com has Semrush global rank of 34,971,259. joelonsql.com has an estimated worth of US$ 302,658, based on its estimated Ads revenue. joelonsql.com receives approximately 34,922 unique visitors each day. Its web server is located in United States, with IP address 192.0.78.24. According to SiteAdvisor, joelonsql.com is safe to visit.

Traffic & Worth Estimates

Purchase/Sale Value	US$302,658
Daily Ads Revenue	US$280
Monthly Ads Revenue	US$8,382
Yearly Ads Revenue	US$100,576
Daily Unique Visitors	2,329
Note: All traffic and earnings values are estimates.

DNS Records

Host	Type	TTL	Data
joelonsql.com.	A	299	IP: 192.0.78.24
joelonsql.com.	A	299	IP: 192.0.78.25
joelonsql.com.	NS	86400	NS Record: ns1.wordpress.com.
joelonsql.com.	NS	86400	NS Record: ns2.wordpress.com.
joelonsql.com.	NS	86400	NS Record: ns3.wordpress.com.

HtmlToTextCheckTime:2023-05-14 12:08:06

Menu Skip to primary content Home About Search Joel on SQL Using pg_badplan to CREATE STATISTICS is a good plan Thanks to Thomas Vondra’s presentation CREATE STATISTICS – What is it for? at Nordic PGDay 2018 , my Trustly colleague Claes Jakobsson came up with the idea for a new extension . The presentation explained how to manually compare the cost rows with the actual rows output from manually executing EXPLAIN ANALYZE . Claes came up with the idea to do this comparison automatically, right after a query has been executed. During the conference, Claes implemented the idea and emailed me some code for me to test. Below is a demo of this extension, using the same data set and queries as in the presentation. git clone https://github.com/tvondra/create-statistics-talk.git psql -X -f create-statistics-talk/create.sql Let’s first try the query without pg_badplan using EXPLAIN ANALYZE : \copy zip_codes from ~/src/create-statistics-talk/no_postal_codes_utf.csv with csv header; COPY 4574

HTTP Headers

HTTP/1.1 301 Moved Permanently
Server: nginx
Date: Thu, 23 Dec 2021 09:35:13 GMT
Content-Type: text/html
Content-Length: 162
Connection: keep-alive
Location: https://joelonsql.com/
X-ac: 3.ewr _dca 

HTTP/2 200 
server: nginx
date: Thu, 23 Dec 2021 09:35:14 GMT
content-type: text/html; charset=UTF-8
strict-transport-security: max-age=86400
vary: Accept-Encoding
vary: Cookie
x-hacker: If you're reading this, you should visit automattic.com/jobs and apply to join the fun, mention this header.
host-header: WordPress.com
link: ; rel=shortlink
x-ac: 3.ewr _dca

joelonsql.com Whois Information

Domain Name: JOELONSQL.COM
Registry Domain ID: 1721625106_DOMAIN_COM-VRSN
Registrar WHOIS Server: whois.wildwestdomains.com
Registrar URL: http://www.wildwestdomains.com
Updated Date: 2021-04-19T10:21:56Z
Creation Date: 2012-05-20T05:30:30Z
Registry Expiry Date: 2022-05-20T05:30:30Z
Registrar: Wild West Domains, LLC
Registrar IANA ID: 440
Registrar Abuse Contact Email: abuse@wildwestdomains.com
Registrar Abuse Contact Phone: 480-624-2505
Domain Status: clientDeleteProhibited https://icann.org/epp#clientDeleteProhibited
Domain Status: clientRenewProhibited https://icann.org/epp#clientRenewProhibited
Domain Status: clientTransferProhibited https://icann.org/epp#clientTransferProhibited
Domain Status: clientUpdateProhibited https://icann.org/epp#clientUpdateProhibited
Name Server: NS1.WORDPRESS.COM
Name Server: NS2.WORDPRESS.COM
DNSSEC: unsigned
>>> Last update of whois database: 2021-12-26T07:25:12Z <<<

joelonsql.com valuation and analysis