Created
March 3, 2016 09:36
-
-
Save fabienengels/fcac2c1057e90c2ddd16 to your computer and use it in GitHub Desktop.
Delete a SeisComP object
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| Delete on object (cost=0.00..19.66 rows=1 width=6) (actual time=4.508..4.508 rows=0 loops=1) | |
| -> Index Scan using object_pkey on object (cost=0.00..19.66 rows=1 width=6) (actual time=4.441..4.442 rows=1 loops=1) | |
| Index Cond: (_oid = 65262249) | |
| Trigger for constraint amplitude__oid_fkey1: time=5.848 calls=1 | |
| Trigger for constraint amplitude__parent_oid_fkey1: time=145.531 calls=1 | |
| Trigger for constraint publicobject__oid_fkey: time=0.349 calls=1 | |
| Trigger for constraint eventdescription__oid_fkey: time=6.320 calls=1 | |
| Trigger for constraint eventdescription__parent_oid_fkey: time=1.502 calls=1 | |
| Trigger for constraint comment__oid_fkey: time=0.259 calls=1 | |
| Trigger for constraint comment__parent_oid_fkey: time=0.095 calls=1 | |
| Trigger for constraint dataused__oid_fkey: time=0.211 calls=1 | |
| Trigger for constraint dataused__parent_oid_fkey: time=0.097 calls=1 | |
| Trigger for constraint compositetime__oid_fkey: time=0.294 calls=1 | |
| Trigger for constraint compositetime__parent_oid_fkey: time=0.118 calls=1 | |
| Trigger for constraint pickreference__oid_fkey: time=0.210 calls=1 | |
| Trigger for constraint pickreference__parent_oid_fkey: time=0.088 calls=1 | |
| Trigger for constraint amplitudereference__oid_fkey: time=0.214 calls=1 | |
| Trigger for constraint amplitudereference__parent_oid_fkey: time=0.094 calls=1 | |
| Trigger for constraint reading__oid_fkey: time=0.169 calls=1 | |
| Trigger for constraint reading__parent_oid_fkey: time=0.082 calls=1 | |
| Trigger for constraint momenttensorcomponentcontribution__oid_fkey: time=0.230 calls=1 | |
| Trigger for constraint momenttensorcomponentcontribution__parent_oid_fkey: time=0.102 calls=1 | |
| Trigger for constraint momenttensorstationcontribution__oid_fkey: time=0.200 calls=1 | |
| Trigger for constraint momenttensorstationcontribution__parent_oid_fkey: time=0.093 calls=1 | |
| Trigger for constraint momenttensorphasesetting__oid_fkey: time=0.205 calls=1 | |
| Trigger for constraint momenttensorphasesetting__parent_oid_fkey: time=0.091 calls=1 | |
| Trigger for constraint momenttensor__oid_fkey: time=0.232 calls=1 | |
| Trigger for constraint momenttensor__parent_oid_fkey: time=0.104 calls=1 | |
| Trigger for constraint focalmechanism__oid_fkey: time=0.261 calls=1 | |
| Trigger for constraint focalmechanism__parent_oid_fkey: time=0.121 calls=1 | |
| Trigger for constraint stationmagnitudecontribution__oid_fkey: time=12.116 calls=1 | |
| Trigger for constraint stationmagnitudecontribution__parent_oid_fkey: time=7.147 calls=1 | |
| Trigger for constraint magnitude__oid_fkey: time=2.493 calls=1 | |
| Trigger for constraint magnitude__parent_oid_fkey: time=2.411 calls=1 | |
| Trigger for constraint stationmagnitude__oid_fkey: time=11.625 calls=1 | |
| Trigger for constraint stationmagnitude__parent_oid_fkey: time=10.714 calls=1 | |
| Trigger for constraint pick__oid_fkey: time=4.748 calls=1 | |
| Trigger for constraint pick__parent_oid_fkey: time=2215.513 calls=1 | |
| Trigger for constraint originreference__oid_fkey: time=4.753 calls=1 | |
| Trigger for constraint originreference__parent_oid_fkey: time=4.868 calls=1 | |
| Trigger for constraint focalmechanismreference__oid_fkey: time=0.437 calls=1 | |
| Trigger for constraint focalmechanismreference__parent_oid_fkey: time=0.107 calls=1 | |
| Trigger for constraint event__oid_fkey: time=2.222 calls=1 | |
| Trigger for constraint event__parent_oid_fkey: time=14.310 calls=1 | |
| Trigger for constraint arrival__oid_fkey: time=8.843 calls=1 | |
| Trigger for constraint arrival__parent_oid_fkey: time=5.648 calls=1 | |
| Trigger for constraint origin__oid_fkey: time=6.162 calls=1 | |
| Trigger for constraint origin__parent_oid_fkey: time=28.312 calls=1 | |
| Trigger for constraint parameter__oid_fkey: time=0.362 calls=1 | |
| Trigger for constraint parameter__parent_oid_fkey: time=0.119 calls=1 | |
| Trigger for constraint parameterset__oid_fkey: time=0.213 calls=1 | |
| Trigger for constraint parameterset__parent_oid_fkey: time=0.154 calls=1 | |
| Trigger for constraint setup__oid_fkey: time=0.244 calls=1 | |
| Trigger for constraint setup__parent_oid_fkey: time=0.107 calls=1 | |
| Trigger for constraint configstation__oid_fkey: time=0.213 calls=1 | |
| Trigger for constraint configstation__parent_oid_fkey: time=0.107 calls=1 | |
| Trigger for constraint configmodule__oid_fkey: time=0.191 calls=1 | |
| Trigger for constraint configmodule__parent_oid_fkey: time=0.091 calls=1 | |
| Trigger for constraint qclog__oid_fkey: time=0.248 calls=1 | |
| Trigger for constraint qclog__parent_oid_fkey: time=0.102 calls=1 | |
| Trigger for constraint waveformquality__oid_fkey: time=0.458 calls=1 | |
| Trigger for constraint waveformquality__parent_oid_fkey: time=0.096 calls=1 | |
| Trigger for constraint outage__oid_fkey: time=4.148 calls=1 | |
| Trigger for constraint outage__parent_oid_fkey: time=1.889 calls=1 | |
| Trigger for constraint stationreference__oid_fkey: time=0.313 calls=1 | |
| Trigger for constraint stationreference__parent_oid_fkey: time=0.098 calls=1 | |
| Trigger for constraint stationgroup__oid_fkey: time=0.245 calls=1 | |
| Trigger for constraint stationgroup__parent_oid_fkey: time=0.093 calls=1 | |
| Trigger for constraint auxsource__oid_fkey: time=0.230 calls=1 | |
| Trigger for constraint auxsource__parent_oid_fkey: time=0.093 calls=1 | |
| Trigger for constraint auxdevice__oid_fkey: time=0.233 calls=1 | |
| Trigger for constraint auxdevice__parent_oid_fkey: time=0.095 calls=1 | |
| Trigger for constraint sensorcalibration__oid_fkey: time=1.831 calls=1 | |
| Trigger for constraint sensorcalibration__parent_oid_fkey: time=0.146 calls=1 | |
| Trigger for constraint sensor__oid_fkey: time=0.230 calls=1 | |
| Trigger for constraint sensor__parent_oid_fkey: time=0.473 calls=1 | |
| Trigger for constraint responsepaz__oid_fkey: time=0.244 calls=1 | |
| Trigger for constraint responsepaz__parent_oid_fkey: time=0.612 calls=1 | |
| Trigger for constraint responsepolynomial__oid_fkey: time=0.209 calls=1 | |
| Trigger for constraint responsepolynomial__parent_oid_fkey: time=0.092 calls=1 | |
| Trigger for constraint dataloggercalibration__oid_fkey: time=0.226 calls=1 | |
| Trigger for constraint dataloggercalibration__parent_oid_fkey: time=0.109 calls=1 | |
| Trigger for constraint decimation__oid_fkey: time=0.216 calls=1 | |
| Trigger for constraint decimation__parent_oid_fkey: time=0.111 calls=1 | |
| Trigger for constraint datalogger__oid_fkey: time=0.207 calls=1 | |
| Trigger for constraint datalogger__parent_oid_fkey: time=0.531 calls=1 | |
| Trigger for constraint responsefir__oid_fkey: time=0.226 calls=1 | |
| Trigger for constraint responsefir__parent_oid_fkey: time=4.726 calls=1 | |
| Trigger for constraint auxstream__oid_fkey: time=0.350 calls=1 | |
| Trigger for constraint auxstream__parent_oid_fkey: time=0.091 calls=1 | |
| Trigger for constraint stream__oid_fkey: time=0.277 calls=1 | |
| Trigger for constraint stream__parent_oid_fkey: time=0.123 calls=1 | |
| Trigger for constraint sensorlocation__oid_fkey: time=0.211 calls=1 | |
| Trigger for constraint sensorlocation__parent_oid_fkey: time=0.113 calls=1 | |
| Trigger for constraint station__oid_fkey: time=0.223 calls=1 | |
| Trigger for constraint station__parent_oid_fkey: time=0.116 calls=1 | |
| Trigger for constraint network__oid_fkey: time=0.202 calls=1 | |
| Trigger for constraint network__parent_oid_fkey: time=0.101 calls=1 | |
| Trigger for constraint routearclink__oid_fkey: time=0.223 calls=1 | |
| Trigger for constraint routearclink__parent_oid_fkey: time=0.096 calls=1 | |
| Trigger for constraint routeseedlink__oid_fkey: time=0.208 calls=1 | |
| Trigger for constraint routeseedlink__parent_oid_fkey: time=0.095 calls=1 | |
| Trigger for constraint route__oid_fkey: time=0.211 calls=1 | |
| Trigger for constraint route__parent_oid_fkey: time=0.095 calls=1 | |
| Trigger for constraint access__oid_fkey: time=0.221 calls=1 | |
| Trigger for constraint access__parent_oid_fkey: time=0.092 calls=1 | |
| Trigger for constraint journalentry__oid_fkey: time=0.300 calls=1 | |
| Trigger for constraint journalentry__parent_oid_fkey: time=0.081 calls=1 | |
| Trigger for constraint arclinkuser__oid_fkey: time=0.215 calls=1 | |
| Trigger for constraint arclinkuser__parent_oid_fkey: time=0.088 calls=1 | |
| Trigger for constraint arclinkstatusline__oid_fkey: time=0.224 calls=1 | |
| Trigger for constraint arclinkstatusline__parent_oid_fkey: time=0.095 calls=1 | |
| Trigger for constraint arclinkrequestline__oid_fkey: time=0.272 calls=1 | |
| Trigger for constraint arclinkrequestline__parent_oid_fkey: time=0.098 calls=1 | |
| Trigger for constraint arclinkrequest__oid_fkey: time=0.248 calls=1 | |
| Trigger for constraint arclinkrequest__parent_oid_fkey: time=0.102 calls=1 | |
| Total runtime: 2535.346 ms |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment