2018-06-15 15:03:44.526 MDT [17884] postgres@sublette LOG: statement: set client_encoding to 'UNICODE' 2018-06-15 15:03:44.615 MDT [17884] postgres@sublette LOG: statement: select regclass('pg_class')::oid 2018-06-15 15:03:44.705 MDT [17884] postgres@sublette LOG: statement: BEGIN 2018-06-15 15:03:44.795 MDT [17884] postgres@sublette LOG: statement: DECLARE oidcursor BINARY CURSOR FOR select regclass('pg_class')::oid 2018-06-15 15:03:44.884 MDT [17884] postgres@sublette LOG: statement: fetch forward 1 from oidcursor 2018-06-15 15:03:44.982 MDT [17884] postgres@sublette LOG: statement: CLOSE oidcursor 2018-06-15 15:03:45.070 MDT [17884] postgres@sublette LOG: statement: COMMIT 2018-06-15 15:03:45.158 MDT [17884] postgres@sublette LOG: statement: SELECT postgis_version() 2018-06-15 15:03:45.255 MDT [17884] postgres@sublette LOG: statement: SELECT postgis_geos_version(),postgis_proj_version() 2018-06-15 15:03:45.345 MDT [17884] postgres@sublette LOG: statement: SELECT EXISTS ( SELECT c.oid FROM pg_class AS c JOIN pg_namespace AS n ON c.relnamespace=n.oid WHERE n.nspname='topology' AND c.relname='topology' ) 2018-06-15 15:03:45.435 MDT [17884] postgres@sublette LOG: statement: SELECT oid FROM pg_catalog.pg_extension WHERE extname = 'pointcloud_postgis' 2018-06-15 15:03:45.523 MDT [17884] postgres@sublette LOG: statement: SET application_name='QGIS' 2018-06-15 15:03:45.613 MDT [17884] postgres@sublette LOG: statement: SELECT nspname, pg_get_userbyid(nspowner), pg_catalog.obj_description(oid) FROM pg_namespace WHERE nspname !~ '^pg_' AND nspname != 'information_schema' ORDER BY nspname 2018-06-15 15:03:47.668 MDT [17884] postgres@sublette LOG: statement: SELECT l.f_table_name,l.f_table_schema,l.f_geometry_column,upper(l.type),l.srid,l.coord_dimension,c.relkind,obj_description(c.oid) FROM geometry_columns l,pg_class c,pg_namespace n WHERE c.relname=l.f_table_name AND l.f_table_schema=n.nspname AND n.oid=c.relnamespace AND has_schema_privilege(n.nspname,'usage') AND has_table_privilege('"'||n.nspname||'"."'||c.relname||'"','select') AND l.f_table_schema='work' ORDER BY n.nspname,c.relname,l.f_geometry_column 2018-06-15 15:03:47.826 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."address"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:47.918 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."address_backup"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:48.030 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."aliquot"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:48.122 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."angie"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:48.235 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."co_boundary"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:48.326 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."cornerrecords"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:48.439 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."dtgw"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:48.528 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."fema_firm"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:48.620 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."image_dates_2014"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:48.714 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."image_dates_2015"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:48.804 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."image_dates_2017"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:48.896 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."mosquitodist"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:48.986 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."ownership"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:49.088 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."ownership"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:49.182 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."ownership"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:49.273 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."ownership2"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:49.371 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."ownership2"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:49.463 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."ownership_export_view"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:49.558 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."parcel"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:49.651 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."parcel_multipoly_backup"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:49.743 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."retired"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:49.834 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."road_cl"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:49.926 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."road_cl_segmented"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:50.017 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."road_cl_sorted"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:50.108 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."section"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:50.199 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."subdivision"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:50.293 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."taxdistricts"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:50.385 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."township"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:50.477 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."underlyinglot"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:50.567 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."well_exemptions"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:50.659 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."wellheads"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:50.751 MDT [17884] postgres@sublette LOG: statement: SELECT attname, CASE WHEN typname = ANY(ARRAY['geometry','geography','topogeometry']) THEN 1 ELSE null END AS isSpatial FROM pg_attribute JOIN pg_type ON atttypid=pg_type.oid WHERE attrelid=regclass('"work"."zonemap1"') AND attnum>0 ORDER BY attnum 2018-06-15 15:03:50.842 MDT [17884] postgres@sublette LOG: statement: SELECT l.f_table_name,l.f_table_schema,l.f_geography_column,upper(l.type),l.srid,2,c.relkind,obj_description(c.oid) FROM geography_columns l,pg_class c,pg_namespace n WHERE c.relname=l.f_table_name AND l.f_table_schema=n.nspname AND n.oid=c.relnamespace AND has_schema_privilege(n.nspname,'usage') AND has_table_privilege('"'||n.nspname||'"."'||c.relname||'"','select') AND l.f_table_schema='work' ORDER BY n.nspname,c.relname,l.f_geography_column 2018-06-15 15:03:50.937 MDT [17884] postgres@sublette LOG: statement: SELECT c.relname,n.nspname,a.attname,c.relkind,CASE WHEN t.typname IN ('geometry','geography','topogeometry') THEN t.typname ELSE b.typname END AS coltype,obj_description(c.oid) FROM pg_attribute a JOIN pg_class c ON c.oid=a.attrelid JOIN pg_namespace n ON n.oid=c.relnamespace JOIN pg_type t ON t.oid=a.atttypid LEFT JOIN pg_type b ON b.oid=t.typbasetype WHERE c.relkind IN ('v','r','m') AND has_schema_privilege( n.nspname, 'usage' ) AND has_table_privilege( '"' || n.nspname || '"."' || c.relname || '"', 'select' ) AND (t.typname IN ('geometry','geography','topogeometry') OR b.typname IN ('geometry','geography','topogeometry','pcpatch')) AND n.nspname='work' AND (n.nspname,c.relname,a.attname) NOT IN (SELECT f_table_schema,f_table_name,f_geometry_column FROM geometry_columns) AND (n.nspname,c.relname,a.attname) NOT IN (SELECT f_table_schema,f_table_name,f_geography_column FROM geography_columns) 2018-06-15 15:03:51.042 MDT [17884] postgres@sublette LOG: statement: SELECT DISTINCT upper(geometrytype("wkb_geometry")),3739,st_ndims("wkb_geometry") FROM (SELECT "wkb_geometry" FROM "work"."aliquot" LIMIT 100) AS t 2018-06-15 15:03:51.138 MDT [17884] postgres@sublette LOG: statement: SELECT DISTINCT upper(geometrytype("wkb_geometry")),3739,st_ndims("wkb_geometry") FROM (SELECT "wkb_geometry" FROM "work"."fema_firm" LIMIT 100) AS t 2018-06-15 15:03:51.242 MDT [17884] postgres@sublette LOG: statement: SELECT DISTINCT upper(geometrytype("wkb_geometry")),3739,st_ndims("wkb_geometry") FROM (SELECT "wkb_geometry" FROM "work"."image_dates_2014" LIMIT 100) AS t 2018-06-15 15:03:51.340 MDT [17884] postgres@sublette LOG: statement: SELECT DISTINCT upper(geometrytype("wkb_geometry")),st_srid("wkb_geometry"),st_ndims("wkb_geometry") FROM (SELECT "wkb_geometry" FROM "work"."ownership" LIMIT 100) AS t 2018-06-15 15:03:51.437 MDT [17884] postgres@sublette LOG: statement: SELECT DISTINCT upper(geometrytype("wkb_geometry")),3739,st_ndims("wkb_geometry") FROM (SELECT "wkb_geometry" FROM "work"."retired" LIMIT 100) AS t 2018-06-15 15:03:51.528 MDT [17884] postgres@sublette LOG: statement: SELECT DISTINCT upper(geometrytype("wkb_geometry")),3739,st_ndims("wkb_geometry") FROM (SELECT "wkb_geometry" FROM "work"."road_cl" LIMIT 100) AS t 2018-06-15 15:03:51.622 MDT [17884] postgres@sublette LOG: statement: SELECT DISTINCT upper(geometrytype("wkb_geometry")),3739,st_ndims("wkb_geometry") FROM (SELECT "wkb_geometry" FROM "work"."road_cl_segmented" LIMIT 100) AS t 2018-06-15 15:03:51.736 MDT [17884] postgres@sublette LOG: statement: SELECT DISTINCT upper(geometrytype("wkb_geometry")),3739,st_ndims("wkb_geometry") FROM (SELECT "wkb_geometry" FROM "work"."road_cl_sorted" LIMIT 100) AS t 2018-06-15 15:03:51.834 MDT [17884] postgres@sublette LOG: statement: SELECT DISTINCT upper(geometrytype("geom")),3739,st_ndims("geom") FROM (SELECT "geom" FROM "work"."section" LIMIT 100) AS t 2018-06-15 15:03:51.929 MDT [17884] postgres@sublette LOG: statement: SELECT DISTINCT upper(geometrytype("wkb_geometry")),3739,st_ndims("wkb_geometry") FROM (SELECT "wkb_geometry" FROM "work"."subdivision" LIMIT 100) AS t 2018-06-15 15:03:52.026 MDT [17884] postgres@sublette LOG: statement: SELECT DISTINCT upper(geometrytype("geom")),3739,st_ndims("geom") FROM (SELECT "geom" FROM "work"."township" LIMIT 100) AS t 2018-06-15 15:03:52.119 MDT [17884] postgres@sublette LOG: statement: SELECT DISTINCT upper(geometrytype("wkb_geometry")),3739,st_ndims("wkb_geometry") FROM (SELECT "wkb_geometry" FROM "work"."underlyinglot" LIMIT 100) AS t 2018-06-15 15:03:52.210 MDT [17884] postgres@sublette LOG: statement: SELECT DISTINCT upper(geometrytype("geom")),3739,st_ndims("geom") FROM (SELECT "geom" FROM "work"."well_exemptions" LIMIT 100) AS t 2018-06-15 15:03:52.301 MDT [17884] postgres@sublette LOG: statement: SELECT DISTINCT upper(geometrytype("wkb_geometry")),3739,st_ndims("wkb_geometry") FROM (SELECT "wkb_geometry" FROM "work"."zonemap1" LIMIT 100) AS t 2018-06-15 15:03:58.358 MDT [17895] postgres@sublette LOG: statement: set client_encoding to 'UNICODE' 2018-06-15 15:03:58.475 MDT [17895] postgres@sublette LOG: statement: select regclass('pg_class')::oid 2018-06-15 15:03:58.564 MDT [17895] postgres@sublette LOG: statement: BEGIN 2018-06-15 15:03:58.653 MDT [17895] postgres@sublette LOG: statement: DECLARE oidcursor BINARY CURSOR FOR select regclass('pg_class')::oid 2018-06-15 15:03:58.742 MDT [17895] postgres@sublette LOG: statement: fetch forward 1 from oidcursor 2018-06-15 15:03:58.832 MDT [17895] postgres@sublette LOG: statement: CLOSE oidcursor 2018-06-15 15:03:58.921 MDT [17895] postgres@sublette LOG: statement: COMMIT 2018-06-15 15:03:59.009 MDT [17895] postgres@sublette LOG: statement: SELECT postgis_version() 2018-06-15 15:03:59.104 MDT [17895] postgres@sublette LOG: statement: SELECT postgis_geos_version(),postgis_proj_version() 2018-06-15 15:03:59.194 MDT [17895] postgres@sublette LOG: statement: SELECT EXISTS ( SELECT c.oid FROM pg_class AS c JOIN pg_namespace AS n ON c.relnamespace=n.oid WHERE n.nspname='topology' AND c.relname='topology' ) 2018-06-15 15:03:59.284 MDT [17895] postgres@sublette LOG: statement: SELECT oid FROM pg_catalog.pg_extension WHERE extname = 'pointcloud_postgis' 2018-06-15 15:03:59.374 MDT [17895] postgres@sublette LOG: statement: SET application_name='QGIS' 2018-06-15 15:03:59.463 MDT [17895] postgres@sublette LOG: statement: SELECT * FROM "work"."parcel" LIMIT 1 2018-06-15 15:03:59.553 MDT [17895] postgres@sublette LOG: statement: SELECT pg_is_in_recovery() 2018-06-15 15:03:59.643 MDT [17895] postgres@sublette LOG: statement: SELECT has_table_privilege('"work"."parcel"','DELETE'),has_any_column_privilege('"work"."parcel"','UPDATE'),has_column_privilege('"work"."parcel"','wkb_geometry','UPDATE'),has_table_privilege('"work"."parcel"','INSERT'),current_schema() 2018-06-15 15:03:59.743 MDT [17895] postgres@sublette LOG: statement: SELECT 1 FROM pg_class,pg_namespace WHERE pg_class.relnamespace=pg_namespace.oid AND pg_has_role(relowner,'MEMBER') AND relname='parcel' AND nspname='work' 2018-06-15 15:03:59.832 MDT [17895] postgres@sublette LOG: statement: SELECT upper(type),srid,coord_dimension FROM geometry_columns WHERE f_table_name='parcel' AND f_geometry_column='wkb_geometry' AND f_table_schema='work' 2018-06-15 15:03:59.924 MDT [17895] postgres@sublette LOG: statement: SELECT regclass('"work"."parcel"')::oid 2018-06-15 15:04:00.014 MDT [17895] postgres@sublette LOG: statement: SELECT description FROM pg_description WHERE objoid=70281 AND objsubid=0 2018-06-15 15:04:00.105 MDT [17895] postgres@sublette LOG: statement: SELECT * FROM "work"."parcel" LIMIT 0 2018-06-15 15:04:00.196 MDT [17895] postgres@sublette LOG: statement: SELECT oid,typname,typtype,typelem,typlen FROM pg_type 2018-06-15 15:04:00.755 MDT [17895] postgres@sublette LOG: statement: SELECT attrelid, attnum, pg_catalog.format_type(atttypid,atttypmod), pg_catalog.col_description(attrelid,attnum), pg_catalog.pg_get_expr(adbin,adrelid), atttypid FROM pg_attribute LEFT OUTER JOIN pg_attrdef ON attrelid=adrelid AND attnum=adnum WHERE attrelid IN (70281) 2018-06-15 15:04:00.852 MDT [17895] postgres@sublette LOG: statement: SELECT count(*) FROM pg_inherits WHERE inhparent='"work"."parcel"'::regclass 2018-06-15 15:04:00.941 MDT [17895] postgres@sublette LOG: statement: SELECT indexrelid FROM pg_index WHERE indrelid='"work"."parcel"'::regclass AND (indisprimary OR indisunique) ORDER BY CASE WHEN indisprimary THEN 1 ELSE 2 END LIMIT 1 2018-06-15 15:04:01.033 MDT [17895] postgres@sublette LOG: statement: SELECT attname,attnotnull FROM pg_index,pg_attribute WHERE indexrelid=71283 AND indrelid=attrelid AND pg_attribute.attnum=any(pg_index.indkey) 2018-06-15 15:04:01.124 MDT [17895] postgres@sublette LOG: statement: set client_min_messages to error 2018-06-15 15:04:01.773 MDT [17897] postgres@sublette LOG: statement: set client_encoding to 'UNICODE' 2018-06-15 15:04:01.863 MDT [17897] postgres@sublette LOG: statement: select regclass('pg_class')::oid 2018-06-15 15:04:01.953 MDT [17897] postgres@sublette LOG: statement: BEGIN 2018-06-15 15:04:02.042 MDT [17897] postgres@sublette LOG: statement: DECLARE oidcursor BINARY CURSOR FOR select regclass('pg_class')::oid 2018-06-15 15:04:02.131 MDT [17897] postgres@sublette LOG: statement: fetch forward 1 from oidcursor 2018-06-15 15:04:02.220 MDT [17897] postgres@sublette LOG: statement: CLOSE oidcursor 2018-06-15 15:04:02.308 MDT [17897] postgres@sublette LOG: statement: COMMIT 2018-06-15 15:04:02.396 MDT [17897] postgres@sublette LOG: statement: SELECT postgis_version() 2018-06-15 15:04:02.493 MDT [17897] postgres@sublette LOG: statement: SELECT postgis_geos_version(),postgis_proj_version() 2018-06-15 15:04:02.584 MDT [17897] postgres@sublette LOG: statement: SELECT EXISTS ( SELECT c.oid FROM pg_class AS c JOIN pg_namespace AS n ON c.relnamespace=n.oid WHERE n.nspname='topology' AND c.relname='topology' ) 2018-06-15 15:04:02.681 MDT [17897] postgres@sublette LOG: statement: SELECT oid FROM pg_catalog.pg_extension WHERE extname = 'pointcloud_postgis' 2018-06-15 15:04:02.772 MDT [17897] postgres@sublette LOG: statement: SET application_name='QGIS' 2018-06-15 15:04:02.859 MDT [17897] postgres@sublette LOG: statement: SELECT COUNT(*) FROM information_schema.tables WHERE table_name='layer_styles' 2018-06-15 15:04:02.972 MDT [17895] postgres@sublette LOG: statement: SELECT count(*) FROM pg_stats WHERE schemaname='work' AND tablename='parcel' AND attname='wkb_geometry' 2018-06-15 15:04:03.067 MDT [17895] postgres@sublette LOG: statement: SELECT reltuples::int FROM pg_catalog.pg_class WHERE oid=regclass('"work"."parcel"')::oid 2018-06-15 15:04:03.158 MDT [17895] postgres@sublette LOG: statement: SELECT st_estimatedextent('work','parcel','wkb_geometry') 2018-06-15 15:04:03.342 MDT [17884] postgres@sublette LOG: statement: BEGIN READ ONLY 2018-06-15 15:04:03.430 MDT [17884] postgres@sublette LOG: statement: DECLARE qgis_1 BINARY CURSOR FOR SELECT st_asbinary("wkb_geometry",'NDR'),"ogc_fid" FROM "work"."parcel" WHERE "wkb_geometry" && st_makeenvelope(2297666.33120186626911163,957851.88906250009313226,3087871.66879813373088837,1421644.17343749990686774,3739) 2018-06-15 15:04:03.519 MDT [17884] postgres@sublette LOG: statement: FETCH FORWARD 2000 FROM qgis_1 2018-06-15 15:04:05.650 MDT [17884] postgres@sublette LOG: statement: FETCH FORWARD 2000 FROM qgis_1 2018-06-15 15:04:07.135 MDT [17884] postgres@sublette LOG: statement: FETCH FORWARD 2000 FROM qgis_1 2018-06-15 15:04:08.397 MDT [17884] postgres@sublette LOG: statement: FETCH FORWARD 2000 FROM qgis_1 2018-06-15 15:04:09.184 MDT [17884] postgres@sublette LOG: statement: FETCH FORWARD 2000 FROM qgis_1 2018-06-15 15:04:10.363 MDT [17884] postgres@sublette LOG: statement: CLOSE qgis_1 2018-06-15 15:04:10.452 MDT [17884] postgres@sublette LOG: statement: COMMIT