Submitted URL: http://pgexercises.com/
Effective URL: https://pgexercises.com/
Submission: On March 07 via api from US — Scanned from DE

Summary

This website contacted 5 IPs in 2 countries across 4 domains to perform 11 HTTP transactions. The main IP is 143.204.98.10, located in United States and belongs to AMAZON-02, US. The main domain is pgexercises.com.
TLS certificate: Issued by Amazon RSA 2048 M02 on July 18th 2023. Valid for: a year.
This is the only time pgexercises.com was scanned on urlscan.io!

urlscan.io Verdict: No classification

Domain & IP information

IP Address AS Autonomous System
1 1 143.204.98.85 16509 (AMAZON-02)
6 143.204.98.10 16509 (AMAZON-02)
1 2a00:1450:400... 15169 (GOOGLE)
2 2a00:1450:400... 15169 (GOOGLE)
1 2a00:1450:400... 15169 (GOOGLE)
1 2001:4860:480... 15169 (GOOGLE)
11 5
Apex Domain
Subdomains
Transfer
7 pgexercises.com
pgexercises.com
47 KB
3 google-analytics.com
www.google-analytics.com — Cisco Umbrella Rank: 29
region1.google-analytics.com — Cisco Umbrella Rank: 2089
21 KB
1 googletagmanager.com
www.googletagmanager.com — Cisco Umbrella Rank: 40
85 KB
1 googleapis.com
ajax.googleapis.com — Cisco Umbrella Rank: 368
33 KB
11 4
Domain Requested by
7 pgexercises.com 1 redirects pgexercises.com
2 www.google-analytics.com pgexercises.com
www.google-analytics.com
1 region1.google-analytics.com www.googletagmanager.com
1 www.googletagmanager.com www.google-analytics.com
1 ajax.googleapis.com pgexercises.com
11 5

This site contains links to these domains. Also see Links.

Domain
www.postgresql.org
creativecommons.org
Subject Issuer Validity Valid
*.pgexercises.com
Amazon RSA 2048 M02
2023-07-18 -
2024-08-15
a year crt.sh
upload.video.google.com
GTS CA 1C3
2024-02-19 -
2024-05-13
3 months crt.sh
*.google-analytics.com
GTS CA 1C3
2024-02-19 -
2024-05-13
3 months crt.sh

This page contains 1 frames:

Primary Page: https://pgexercises.com/
Frame ID: EC2053A5E2BC5F23E9D493D7F1E49F90
Requests: 11 HTTP requests in this frame

Screenshot

Page Title

PostgreSQL Exercises

Page URL History Show full URLs

  1. http://pgexercises.com/ HTTP 301
    https://pgexercises.com/ Page URL

Detected technologies

Overall confidence: 100%
Detected patterns
  • <link[^>]* href=[^>]*?bootstrap(?:[^>]*?([0-9a-fA-F]{7,40}|[\d]+(?:.[\d]+(?:.[\d]+)?)?)|)[^>]*?(?:\.min)?\.css
  • bootstrap(?:[^>]*?([0-9a-fA-F]{7,40}|[\d]+(?:.[\d]+(?:.[\d]+)?)?)|)[^>]*?(?:\.min)?\.js

Overall confidence: 100%
Detected patterns
  • google-analytics\.com/(?:ga|urchin|analytics)\.js

Overall confidence: 100%
Detected patterns
  • googleapis\.com/.+webfont

Overall confidence: 100%
Detected patterns
  • googletagmanager\.com/gtag/js

Overall confidence: 100%
Detected patterns
  • /([\d.]+)/jquery(?:\.min)?\.js
  • jquery.*\.js(?:\?ver(?:sion)?=([\d.]+))?

Page Statistics

11
Requests

100 %
HTTPS

67 %
IPv6

4
Domains

5
Subdomains

5
IPs

2
Countries

186 kB
Transfer

543 kB
Size

4
Cookies

Page URL History

This captures the URL locations of the websites, including HTTP redirects and client-side redirects via JavaScript or Meta fields.

  1. http://pgexercises.com/ HTTP 301
    https://pgexercises.com/ Page URL

Redirected requests

There were HTTP redirect chains for the following requests:

11 HTTP transactions

Resource
Path
Size
x-fer
Type
MIME-Type
Primary Request /
pgexercises.com/
Redirect Chain
  • http://pgexercises.com/
  • https://pgexercises.com/
4 KB
2 KB
Document
General
Full URL
https://pgexercises.com/
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
143.204.98.10 , United States, ASN16509 (AMAZON-02, US),
Reverse DNS
server-143-204-98-10.fra50.r.cloudfront.net
Software
AmazonS3 /
Resource Hash
2744ad56520b3cdaeda1c22b3f4a9a9e08425143f98a3cea1e337920dd716640

Request headers

Upgrade-Insecure-Requests
1
User-Agent
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.6261.111 Safari/537.36
accept-language
de-DE,de;q=0.9

Response headers

age
3596
content-encoding
gzip
content-type
text/html
date
Thu, 07 Mar 2024 08:17:57 GMT
etag
W/"f25873a905c616b1840d7efb82b6734a"
last-modified
Tue, 18 Jul 2023 16:29:57 GMT
server
AmazonS3
vary
Accept-Encoding
via
1.1 5d8c59c4e33ff30f6610982ac8ad0232.cloudfront.net (CloudFront)
x-amz-cf-id
eOpI2gOIV8_Tg4jASjh2vFr-Dlv1VyIvno_TEsBcDM7CoPfprA11Lw==
x-amz-cf-pop
FRA50-C1
x-amz-server-side-encryption
AES256
x-cache
Hit from cloudfront

Redirect headers

Connection
keep-alive
Content-Length
167
Content-Type
text/html
Date
Thu, 07 Mar 2024 09:08:50 GMT
Location
https://pgexercises.com/
Server
CloudFront
Via
1.1 c6702f5f3b6e77da6f394e67ef1a6aaa.cloudfront.net (CloudFront)
X-Amz-Cf-Id
2TCZHJEG_okwUCQLQchGP5FddmPTZ-r0_dbo571_h7jmkWEKfblcyQ==
X-Amz-Cf-Pop
FRA50-C1
X-Cache
Redirect from cloudfront
site.css
pgexercises.com/css/
2 KB
1 KB
Stylesheet
General
Full URL
https://pgexercises.com/css/site.css
Requested by
Host: pgexercises.com
URL: https://pgexercises.com/
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
143.204.98.10 , United States, ASN16509 (AMAZON-02, US),
Reverse DNS
server-143-204-98-10.fra50.r.cloudfront.net
Software
AmazonS3 /
Resource Hash
721d6d3a64e1a766ef72eb8fc62303fea1e2d844bf3140079abd1a68ba3ec9a7

Request headers

accept-language
de-DE,de;q=0.9
Referer
https://pgexercises.com/
User-Agent
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.6261.111 Safari/537.36

Response headers

date
Thu, 07 Mar 2024 09:04:45 GMT
content-encoding
gzip
via
1.1 5d8c59c4e33ff30f6610982ac8ad0232.cloudfront.net (CloudFront)
last-modified
Tue, 18 Jul 2023 16:29:58 GMT
server
AmazonS3
x-amz-cf-pop
FRA50-C1
age
246
x-amz-server-side-encryption
AES256
etag
W/"26bf7ee990b37764b6f35e68046868e3"
vary
Accept-Encoding
x-cache
Hit from cloudfront
content-type
text/css
x-amz-cf-id
4vKsvqbrUPi7gbvygYE4AXEML2vqMQhdQQ5A7CuZNvUreFN9lM8ucg==
bootstrap.min.css
pgexercises.com/css/
99 KB
16 KB
Stylesheet
General
Full URL
https://pgexercises.com/css/bootstrap.min.css
Requested by
Host: pgexercises.com
URL: https://pgexercises.com/
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
143.204.98.10 , United States, ASN16509 (AMAZON-02, US),
Reverse DNS
server-143-204-98-10.fra50.r.cloudfront.net
Software
AmazonS3 /
Resource Hash
13d49e20acbc4770ae4a766f5541c270e424e8223fec8c829264afb91ed23f6c

Request headers

accept-language
de-DE,de;q=0.9
Referer
https://pgexercises.com/
User-Agent
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.6261.111 Safari/537.36

Response headers

date
Thu, 07 Mar 2024 09:04:45 GMT
content-encoding
gzip
via
1.1 5d8c59c4e33ff30f6610982ac8ad0232.cloudfront.net (CloudFront)
last-modified
Tue, 18 Jul 2023 16:29:58 GMT
server
AmazonS3
x-amz-cf-pop
FRA50-C1
age
246
x-amz-server-side-encryption
AES256
etag
W/"a5e17e782755379829854364caad2b63"
vary
Accept-Encoding
x-cache
Hit from cloudfront
content-type
text/css
x-amz-cf-id
YjMtFiXJU5yk4dA_4AddT3eZ1eGMLib3sF0e0tpFZcVsC90YUrQDWA==
bootstrap-responsive.min.css
pgexercises.com/css/
16 KB
4 KB
Stylesheet
General
Full URL
https://pgexercises.com/css/bootstrap-responsive.min.css
Requested by
Host: pgexercises.com
URL: https://pgexercises.com/
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
143.204.98.10 , United States, ASN16509 (AMAZON-02, US),
Reverse DNS
server-143-204-98-10.fra50.r.cloudfront.net
Software
AmazonS3 /
Resource Hash
25b4cad4f7721f782bfd4dcad8c1504110210c8a840957ea25035660a3b965e5

Request headers

accept-language
de-DE,de;q=0.9
Referer
https://pgexercises.com/
User-Agent
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.6261.111 Safari/537.36

Response headers

date
Thu, 07 Mar 2024 09:04:45 GMT
content-encoding
gzip
via
1.1 5d8c59c4e33ff30f6610982ac8ad0232.cloudfront.net (CloudFront)
last-modified
Tue, 18 Jul 2023 16:29:58 GMT
server
AmazonS3
x-amz-cf-pop
FRA50-C1
age
246
x-amz-server-side-encryption
AES256
etag
W/"a28ca18eeef308daa32c00c928f40d00"
vary
Accept-Encoding
x-cache
Hit from cloudfront
content-type
text/css
x-amz-cf-id
5tPYQdCr6Gkbwk_82_yec2-u-UDNeRVkWDO1to8ybCJyDg0UzfUOnw==
jquery.min.js
ajax.googleapis.com/ajax/libs/jquery/1.11.0/
94 KB
33 KB
Script
General
Full URL
https://ajax.googleapis.com/ajax/libs/jquery/1.11.0/jquery.min.js
Requested by
Host: pgexercises.com
URL: https://pgexercises.com/
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:82f::200a Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
sffe /
Resource Hash
b294e973896f8f874e90a8eb1a8908ac790980d034c4c4bdf0fc3d37b8abf682
Security Headers
Name Value
X-Content-Type-Options nosniff
X-Xss-Protection 0

Request headers

accept-language
de-DE,de;q=0.9
Referer
https://pgexercises.com/
User-Agent
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.6261.111 Safari/537.36

Response headers

date
Tue, 05 Mar 2024 09:00:57 GMT
content-encoding
gzip
x-content-type-options
nosniff
age
173273
content-security-policy-report-only
require-trusted-types-for 'script'; report-uri https://csp.withgoogle.com/csp/hosted-libraries-pushers
cross-origin-resource-policy
cross-origin
alt-svc
h3=":443"; ma=2592000,h3-29=":443"; ma=2592000
content-length
33576
x-xss-protection
0
last-modified
Tue, 03 Mar 2020 19:15:00 GMT
server
sffe
cross-origin-opener-policy
same-origin; report-to="hosted-libraries-pushers"
vary
Accept-Encoding
report-to
{"group":"hosted-libraries-pushers","max_age":2592000,"endpoints":[{"url":"https://csp.withgoogle.com/csp/report-to/hosted-libraries-pushers"}]}
content-type
text/javascript; charset=UTF-8
access-control-allow-origin
*
cache-control
public, max-age=31536000, stale-while-revalidate=2592000
accept-ranges
bytes
timing-allow-origin
*
expires
Wed, 05 Mar 2025 09:00:57 GMT
bootstrap.min.js
pgexercises.com/js/
25 KB
7 KB
Script
General
Full URL
https://pgexercises.com/js/bootstrap.min.js
Requested by
Host: pgexercises.com
URL: https://pgexercises.com/
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
143.204.98.10 , United States, ASN16509 (AMAZON-02, US),
Reverse DNS
server-143-204-98-10.fra50.r.cloudfront.net
Software
AmazonS3 /
Resource Hash
fe8aead0b04ede75588da9410ba730c7d8bde6deefd700fa5117d7b8352fd245

Request headers

accept-language
de-DE,de;q=0.9
Referer
https://pgexercises.com/
User-Agent
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.6261.111 Safari/537.36

Response headers

date
Thu, 07 Mar 2024 09:04:45 GMT
content-encoding
gzip
via
1.1 5d8c59c4e33ff30f6610982ac8ad0232.cloudfront.net (CloudFront)
last-modified
Tue, 18 Jul 2023 16:30:00 GMT
server
AmazonS3
x-amz-cf-pop
FRA50-C1
age
246
x-amz-server-side-encryption
AES256
etag
W/"41e29a3120a385a8d44e06987d8688c9"
vary
Accept-Encoding
x-cache
Hit from cloudfront
content-type
application/javascript
x-amz-cf-id
uAsS8-cZCe5Dyu3iPwj1oibu58yDpSdLiNO4zaVoE7Oau2LqZ7f9cw==
Ubuntu-R-webfont.woff
pgexercises.com/lib/ubuntu-fontfacekit/
15 KB
16 KB
Font
General
Full URL
https://pgexercises.com/lib/ubuntu-fontfacekit/Ubuntu-R-webfont.woff
Requested by
Host: pgexercises.com
URL: https://pgexercises.com/css/site.css
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
143.204.98.10 , United States, ASN16509 (AMAZON-02, US),
Reverse DNS
server-143-204-98-10.fra50.r.cloudfront.net
Software
AmazonS3 /
Resource Hash
ec6faa51d5b0b071878586b0d1ea4c0f4e06caf3cc26a363c50962a38890f041

Request headers

Referer
https://pgexercises.com/css/site.css
Origin
https://pgexercises.com
accept-language
de-DE,de;q=0.9
User-Agent
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.6261.111 Safari/537.36

Response headers

date
Thu, 07 Mar 2024 09:08:50 GMT
via
1.1 5d8c59c4e33ff30f6610982ac8ad0232.cloudfront.net (CloudFront)
last-modified
Tue, 18 Jul 2023 16:30:13 GMT
server
AmazonS3
x-amz-cf-pop
FRA50-C1
age
65
x-amz-server-side-encryption
AES256
etag
"66f3e5a0c8c63c29604044d40bfbdbe8"
vary
Accept-Encoding
x-cache
Hit from cloudfront
content-type
binary/octet-stream
accept-ranges
bytes
content-length
15580
x-amz-cf-id
MRndd8n2IPCQhP_LyC6Mhi-bLeIoqS92hcMtcx9Dj9zq4eXJ3BNq1w==
analytics.js
www.google-analytics.com/
52 KB
21 KB
Script
General
Full URL
https://www.google-analytics.com/analytics.js
Requested by
Host: pgexercises.com
URL: https://pgexercises.com/
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:828::200e Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
Golfe2 /
Resource Hash
de36e50194320a7d3ef1ace9bd34a875a8bd458b253c061979dd628e9bf49afd
Security Headers
Name Value
Strict-Transport-Security max-age=10886400; includeSubDomains; preload
X-Content-Type-Options nosniff

Request headers

accept-language
de-DE,de;q=0.9
Referer
https://pgexercises.com/
User-Agent
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.6261.111 Safari/537.36

Response headers

strict-transport-security
max-age=10886400; includeSubDomains; preload
content-encoding
gzip
x-content-type-options
nosniff
date
Thu, 07 Mar 2024 07:48:08 GMT
last-modified
Tue, 12 Dec 2023 18:09:08 GMT
server
Golfe2
age
4842
vary
Accept-Encoding
content-type
text/javascript
cache-control
public, max-age=7200
cross-origin-resource-policy
cross-origin
alt-svc
h3=":443"; ma=2592000,h3-29=":443"; ma=2592000
content-length
20994
expires
Thu, 07 Mar 2024 09:48:08 GMT
collect
www.google-analytics.com/j/
15 B
220 B
XHR
General
Full URL
https://www.google-analytics.com/j/collect?v=1&_v=j101&a=1929608530&t=pageview&_s=1&dl=https%3A%2F%2Fpgexercises.com%2F&ul=en-us&de=UTF-8&dt=PostgreSQL%20Exercises&sd=24-bit&sr=1600x1200&vp=1600x1200&je=0&_u=IEBAAAABAAAAACAAI~&jid=1462945273&gjid=2121698996&cid=218700347.1709802531&tid=UA-45602502-1&_gid=1470181358.1709802531&_r=1&_slc=1&z=1135796499
Requested by
Host: www.google-analytics.com
URL: https://www.google-analytics.com/analytics.js
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:828::200e Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
Golfe2 /
Resource Hash
fc4e3750912ca2715359b6e23d02a4373695aa1502cbaffa928effb8e7967b12
Security Headers
Name Value
X-Content-Type-Options nosniff

Request headers

Referer
https://pgexercises.com/
accept-language
de-DE,de;q=0.9
User-Agent
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.6261.111 Safari/537.36
Content-Type
text/plain

Response headers

pragma
no-cache
date
Thu, 07 Mar 2024 09:08:50 GMT
x-content-type-options
nosniff
last-modified
Sun, 17 May 1998 03:00:00 GMT
server
Golfe2
content-type
text/plain
access-control-allow-origin
https://pgexercises.com
cache-control
no-cache, no-store, must-revalidate
access-control-allow-credentials
true
cross-origin-resource-policy
cross-origin
alt-svc
h3=":443"; ma=2592000,h3-29=":443"; ma=2592000
content-length
15
expires
Fri, 01 Jan 1990 00:00:00 GMT
js
www.googletagmanager.com/gtag/
236 KB
85 KB
Script
General
Full URL
https://www.googletagmanager.com/gtag/js?id=G-DFWEVWFMP0&cx=c&_slc=1
Requested by
Host: www.google-analytics.com
URL: https://www.google-analytics.com/analytics.js
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2a00:1450:4001:801::2008 Frankfurt am Main, Germany, ASN15169 (GOOGLE, US),
Reverse DNS
Software
Google Tag Manager /
Resource Hash
f8f9a58ffd81228b9aab910c7e49f2b6159020516a9d9d2a75c12452ada35f5e
Security Headers
Name Value
Strict-Transport-Security max-age=31536000; includeSubDomains
X-Xss-Protection 0

Request headers

accept-language
de-DE,de;q=0.9
Referer
https://pgexercises.com/
User-Agent
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.6261.111 Safari/537.36

Response headers

date
Thu, 07 Mar 2024 09:08:50 GMT
content-encoding
br
strict-transport-security
max-age=31536000; includeSubDomains
server
Google Tag Manager
vary
Accept-Encoding
content-type
application/javascript; charset=UTF-8
access-control-allow-origin
*
cache-control
private, max-age=900
access-control-allow-credentials
true
cross-origin-resource-policy
cross-origin
access-control-allow-headers
Cache-Control
content-length
86153
x-xss-protection
0
alt-svc
h3=":443"; ma=2592000,h3-29=":443"; ma=2592000
expires
Thu, 07 Mar 2024 09:08:50 GMT
collect
region1.google-analytics.com/g/
0
253 B
Ping
General
Full URL
https://region1.google-analytics.com/g/collect?v=2&tid=G-DFWEVWFMP0&gtm=45je4340v9126415543za220&_p=1709802530775&gcd=13l3l3l2l2&npa=0&dma_cps=sypham&dma=1&ul=en-us&sr=1600x1200&cid=218700347.1709802531&ir=1&uaa=&uab=&uafvl=&uamb=0&uam=&uap=&uapv=&uaw=0&pscdl=noapi&_eu=EBAI&_s=1&dl=https%3A%2F%2Fpgexercises.com%2F&dt=PostgreSQL%20Exercises&sid=1709802531&sct=1&seg=0&en=page_view&_fv=1&_ss=1&_ee=1&tfd=653
Requested by
Host: www.googletagmanager.com
URL: https://www.googletagmanager.com/gtag/js?id=G-DFWEVWFMP0&cx=c&_slc=1
Protocol
H2
Security
TLS 1.3, , AES_128_GCM
Server
2001:4860:4802:34::36 , United States, ASN15169 (GOOGLE, US),
Reverse DNS
Software
Golfe2 /
Resource Hash
e3b0c44298fc1c149afbf4c8996fb92427ae41e4649b934ca495991b7852b855

Request headers

accept-language
de-DE,de;q=0.9
Referer
https://pgexercises.com/
User-Agent
Mozilla/5.0 (Windows NT 10.0; Win64; x64) AppleWebKit/537.36 (KHTML, like Gecko) Chrome/122.0.6261.111 Safari/537.36

Response headers

pragma
no-cache
date
Thu, 07 Mar 2024 09:08:51 GMT
server
Golfe2
content-type
text/plain
access-control-allow-origin
https://pgexercises.com
cache-control
no-cache, no-store, must-revalidate
access-control-allow-credentials
true
cross-origin-resource-policy
cross-origin
alt-svc
h3=":443"; ma=2592000,h3-29=":443"; ma=2592000
content-length
0
expires
Fri, 01 Jan 1990 00:00:00 GMT

Verdicts & Comments Add Verdict or Comment

11 JavaScript Global Variables

These are the non-standard "global" variables defined on the window object. These can be helpful in identifying possible client-side frameworks and code.

function| $ function| jQuery object| jQuery11100385790617707376 string| GoogleAnalyticsObject function| ga object| google_tag_data object| gaplugins object| gaGlobal object| gaData object| dataLayer object| google_tag_manager

4 Cookies

Domain/Path Name / Value
.pgexercises.com/ Name: _ga
Value: GA1.2.218700347.1709802531
.pgexercises.com/ Name: _gid
Value: GA1.2.1470181358.1709802531
.pgexercises.com/ Name: _gat
Value: 1
.pgexercises.com/ Name: _ga_DFWEVWFMP0
Value: GS1.2.1709802531.1.0.1709802531.0.0.0