Skip to content

Instantly share code, notes, and snippets.

set enable_seqscan = on;
--set random_page_cost = 3.0;
set search_path to 'aatams', 'public';
--explain
with rxr_filtered_dets as (
select valid_detection.id as id
from valid_detection
join receiver_deployment on valid_detection.receiver_deployment_id = receiver_deployment.id
join installation_station on receiver_deployment.station_id = installation_station.id
<?xml version="1.0" encoding="UTF-8"?>
<urlset xmlns="http://www.sitemaps.org/schemas/sitemap/0.9">
<url>
<loc>https://imos.aodn.org.au/data_collections.html</loc>
<lastmod>2015-01-21T17:47:59.645+11:00</lastmod>
<changefreq>daily</changefreq>
</url>
<url>
<loc>https://imos.aodn.org.au/Salinity-%7C-CARS-2009-World-monthly-sea-water-salinity-anomaly.html</loc>
<lastmod>2014-12-12T12:21:07</lastmod>
2015-02-10 12:10:29,293 [main] [] TRACE LongType - returning '17' as column: id32_0_
2015-02-10 12:10:29,439 [main] [] WARN GroovyTestCase - +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
2015-02-10 12:10:29,440 [main] [] WARN GroovyTestCase - +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
2015-02-10 12:10:29,440 [main] [] WARN GroovyTestCase - +++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
2015-02-10 12:10:29,446 [main] [] DEBUG SQL -
select
this_.id as id37_0_,
this_.version as version37_0_,
this_.location as location37_0_,
this_.provisional as provisio4_37_0_,
,,,,,,,??TWWWWWT?,,,,,,,,,,,,,
?TWHHHHHHHHHHHHHHT,,,,,,,,
?HHHHHHHHHHHHHHHHHHH?,,,
,,,WHW?,,,,,,,,,??WHHHHHHT,,
,,,,,,,,,,,,,,,,,,,,,,,,,,HHHHHHW
,,,,,,,,,,,,,,,,,,,,,,,,,,,?HHHHHH
,,,,,,,,,,,,,,,,,,,,,,,,,,,?HHHHHH
,,,,,,,,,,,,,,,,,,,,,,,,,,?WHHHHW
,,,,,,,,,,,,,,,,,,,,,,,,?WHHHHH??
,,,,,,,,,,,,,,,,,,,,,,THHHHHHT?,,
@jkburges
jkburges / index.html
Created March 13, 2015 02:32
Very simple example which updates the URL every second.
<!DOCTYPE html>
<html>
<script type="text/javascript">
var count = 0;
setInterval(function() {
count++;
window.history.pushState(null, '', count);
}, 2000);
curl "http://po.aodn.org.au/geoserver/imos/wfs?service=wfs&request=DescribeFeatureType&typeNames=imos:argo_profile_download_data"
<xsd:complexType name="argo_profile_download_dataType">
<xsd:complexContent>
<xsd:extension base="gml:AbstractFeatureType">
<xsd:sequence>
<xsd:element maxOccurs="1" minOccurs="0" name="data_centre" nillable="true" type="xsd:string"/>
<xsd:element maxOccurs="1" minOccurs="0" name="platform_number" nillable="true" type="xsd:string"/>
<xsd:element maxOccurs="1" minOccurs="0" name="cycle_number" nillable="true" type="xsd:int"/>
| Environment set to test.....
Skipped gathering metadata as environment is 'development' or 'test'
Loading base Portal configuration...
Not loading external config
| Error Fatal error running tests: org/hamcrest/SelfDescribing (NOTE: Stack trace has been filtered. Use --verbose to see entire trace.)
java.lang.NoClassDefFoundError: org/hamcrest/SelfDescribing
at _GrailsTest$_run_closure1.doCall(_GrailsTest.groovy:102)
at org.codehaus.gant.GantMetaClass.invokeMethod(GantMetaClass.java:133)
at org.codehaus.gant.GantBinding$_initializeGantBinding_closure5_closure16_closure18.doCall(GantBinding.groovy:185)
at org.codehaus.gant.GantBinding$_initializeGantBinding_closure5_closure16_closure18.doCall(GantBinding.groovy)
$ curl -I "http://localhost:8080/netcdf-subset?typeName=anmn_ts_timeseries_data&CQL_FILTER=INTERSECTS(geom,POLYGON((113.3349609375 -33.091796875,113.3349609375 -30.982421875,117.1142578125 -30.982421875,117.1142578125 -33.091796875,113.3349609375 -33.091796875))) AND TIME >= '2015-01-13T23:00:00Z' AND TIME <= '2015-04-14T00:00:00Z'"
HTTP/1.1 505 HTTP Version Not Supported
Server: Apache-Coyote/1.1
Date: Mon, 20 Apr 2015 00:46:33 GMT
jburgess@emiidt01:~/git/ncdfgenerator(master)$ mvn -Dtest=MyIT test
[INFO] Scanning for projects...
[INFO]
[INFO] Using the builder org.apache.maven.lifecycle.internal.builder.singlethreaded.SingleThreadedBuilder with a thread count of 1
[INFO]
[INFO] ------------------------------------------------------------------------
[INFO] Building NcdfGenerator artifact (jar) 1.0.0
[INFO] ------------------------------------------------------------------------
[INFO]
[INFO] --- maven-resources-plugin:2.6:resources (default-resources) @ ncdfgenerator ---
@jkburges
jkburges / gist:06c0b369b3822142ff26
Last active August 29, 2015 14:20
Index sizes
Separate indexes:
"aatams.detection";"16 GB"
"aatams.detection_transmitter_id_index";"4882 MB"
"aatams.detection_receiver_name_index";"4877 MB"
"aatams.detection_timestamp_index";"4706 MB"
"aatams.detection_pkey";"4055 MB"
"aatams.detection_receiver_download_id_index";"3507 MB"