1
|
2018-06-15 15:03:44.526 MDT [17884] postgres@sublette LOG: statement: set client_encoding to 'UNICODE'
|
2
|
2018-06-15 15:03:44.615 MDT [17884] postgres@sublette LOG: statement: select regclass('pg_class')::oid
|
3
|
2018-06-15 15:03:44.705 MDT [17884] postgres@sublette LOG: statement: BEGIN
|
4
|
2018-06-15 15:03:44.795 MDT [17884] postgres@sublette LOG: statement: DECLARE oidcursor BINARY CURSOR FOR select regclass('pg_class')::oid
|
5
|
2018-06-15 15:03:44.884 MDT [17884] postgres@sublette LOG: statement: fetch forward 1 from oidcursor
|
6
|
2018-06-15 15:03:44.982 MDT [17884] postgres@sublette LOG: statement: CLOSE oidcursor
|
7
|
2018-06-15 15:03:45.070 MDT [17884] postgres@sublette LOG: statement: COMMIT
|
8
|
2018-06-15 15:03:45.158 MDT [17884] postgres@sublette LOG: statement: SELECT postgis_version()
|
9
|
2018-06-15 15:03:45.255 MDT [17884] postgres@sublette LOG: statement: SELECT postgis_geos_version(),postgis_proj_version()
|
10
|
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' )
|
11
|
2018-06-15 15:03:45.435 MDT [17884] postgres@sublette LOG: statement: SELECT oid FROM pg_catalog.pg_extension WHERE extname = 'pointcloud_postgis'
|
12
|
2018-06-15 15:03:45.523 MDT [17884] postgres@sublette LOG: statement: SET application_name='QGIS'
|
13
|
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
|
14
|
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
|
15
|
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
|
16
|
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
|
17
|
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
|
18
|
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
|
19
|
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
|
20
|
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
|
21
|
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
|
22
|
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
|
23
|
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
|
24
|
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
|
25
|
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
|
26
|
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
|
27
|
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
|
28
|
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
|
29
|
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
|
30
|
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
|
31
|
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
|
32
|
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
|
33
|
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
|
34
|
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
|
35
|
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
|
36
|
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
|
37
|
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
|
38
|
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
|
39
|
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
|
40
|
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
|
41
|
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
|
42
|
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
|
43
|
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
|
44
|
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
|
45
|
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
|
46
|
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
|
47
|
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
|
48
|
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)
|
49
|
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
|
50
|
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
|
51
|
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
|
52
|
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
|
53
|
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
|
54
|
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
|
55
|
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
|
56
|
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
|
57
|
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
|
58
|
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
|
59
|
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
|
60
|
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
|
61
|
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
|
62
|
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
|
63
|
2018-06-15 15:03:58.358 MDT [17895] postgres@sublette LOG: statement: set client_encoding to 'UNICODE'
|
64
|
2018-06-15 15:03:58.475 MDT [17895] postgres@sublette LOG: statement: select regclass('pg_class')::oid
|
65
|
2018-06-15 15:03:58.564 MDT [17895] postgres@sublette LOG: statement: BEGIN
|
66
|
2018-06-15 15:03:58.653 MDT [17895] postgres@sublette LOG: statement: DECLARE oidcursor BINARY CURSOR FOR select regclass('pg_class')::oid
|
67
|
2018-06-15 15:03:58.742 MDT [17895] postgres@sublette LOG: statement: fetch forward 1 from oidcursor
|
68
|
2018-06-15 15:03:58.832 MDT [17895] postgres@sublette LOG: statement: CLOSE oidcursor
|
69
|
2018-06-15 15:03:58.921 MDT [17895] postgres@sublette LOG: statement: COMMIT
|
70
|
2018-06-15 15:03:59.009 MDT [17895] postgres@sublette LOG: statement: SELECT postgis_version()
|
71
|
2018-06-15 15:03:59.104 MDT [17895] postgres@sublette LOG: statement: SELECT postgis_geos_version(),postgis_proj_version()
|
72
|
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' )
|
73
|
2018-06-15 15:03:59.284 MDT [17895] postgres@sublette LOG: statement: SELECT oid FROM pg_catalog.pg_extension WHERE extname = 'pointcloud_postgis'
|
74
|
2018-06-15 15:03:59.374 MDT [17895] postgres@sublette LOG: statement: SET application_name='QGIS'
|
75
|
2018-06-15 15:03:59.463 MDT [17895] postgres@sublette LOG: statement: SELECT * FROM "work"."parcel" LIMIT 1
|
76
|
2018-06-15 15:03:59.553 MDT [17895] postgres@sublette LOG: statement: SELECT pg_is_in_recovery()
|
77
|
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()
|
78
|
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'
|
79
|
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'
|
80
|
2018-06-15 15:03:59.924 MDT [17895] postgres@sublette LOG: statement: SELECT regclass('"work"."parcel"')::oid
|
81
|
2018-06-15 15:04:00.014 MDT [17895] postgres@sublette LOG: statement: SELECT description FROM pg_description WHERE objoid=70281 AND objsubid=0
|
82
|
2018-06-15 15:04:00.105 MDT [17895] postgres@sublette LOG: statement: SELECT * FROM "work"."parcel" LIMIT 0
|
83
|
2018-06-15 15:04:00.196 MDT [17895] postgres@sublette LOG: statement: SELECT oid,typname,typtype,typelem,typlen FROM pg_type
|
84
|
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)
|
85
|
2018-06-15 15:04:00.852 MDT [17895] postgres@sublette LOG: statement: SELECT count(*) FROM pg_inherits WHERE inhparent='"work"."parcel"'::regclass
|
86
|
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
|
87
|
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)
|
88
|
2018-06-15 15:04:01.124 MDT [17895] postgres@sublette LOG: statement: set client_min_messages to error
|
89
|
2018-06-15 15:04:01.773 MDT [17897] postgres@sublette LOG: statement: set client_encoding to 'UNICODE'
|
90
|
2018-06-15 15:04:01.863 MDT [17897] postgres@sublette LOG: statement: select regclass('pg_class')::oid
|
91
|
2018-06-15 15:04:01.953 MDT [17897] postgres@sublette LOG: statement: BEGIN
|
92
|
2018-06-15 15:04:02.042 MDT [17897] postgres@sublette LOG: statement: DECLARE oidcursor BINARY CURSOR FOR select regclass('pg_class')::oid
|
93
|
2018-06-15 15:04:02.131 MDT [17897] postgres@sublette LOG: statement: fetch forward 1 from oidcursor
|
94
|
2018-06-15 15:04:02.220 MDT [17897] postgres@sublette LOG: statement: CLOSE oidcursor
|
95
|
2018-06-15 15:04:02.308 MDT [17897] postgres@sublette LOG: statement: COMMIT
|
96
|
2018-06-15 15:04:02.396 MDT [17897] postgres@sublette LOG: statement: SELECT postgis_version()
|
97
|
2018-06-15 15:04:02.493 MDT [17897] postgres@sublette LOG: statement: SELECT postgis_geos_version(),postgis_proj_version()
|
98
|
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' )
|
99
|
2018-06-15 15:04:02.681 MDT [17897] postgres@sublette LOG: statement: SELECT oid FROM pg_catalog.pg_extension WHERE extname = 'pointcloud_postgis'
|
100
|
2018-06-15 15:04:02.772 MDT [17897] postgres@sublette LOG: statement: SET application_name='QGIS'
|
101
|
2018-06-15 15:04:02.859 MDT [17897] postgres@sublette LOG: statement: SELECT COUNT(*) FROM information_schema.tables WHERE table_name='layer_styles'
|
102
|
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'
|
103
|
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
|
104
|
2018-06-15 15:04:03.158 MDT [17895] postgres@sublette LOG: statement: SELECT st_estimatedextent('work','parcel','wkb_geometry')
|
105
|
2018-06-15 15:04:03.342 MDT [17884] postgres@sublette LOG: statement: BEGIN READ ONLY
|
106
|
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)
|
107
|
2018-06-15 15:04:03.519 MDT [17884] postgres@sublette LOG: statement: FETCH FORWARD 2000 FROM qgis_1
|
108
|
2018-06-15 15:04:05.650 MDT [17884] postgres@sublette LOG: statement: FETCH FORWARD 2000 FROM qgis_1
|
109
|
2018-06-15 15:04:07.135 MDT [17884] postgres@sublette LOG: statement: FETCH FORWARD 2000 FROM qgis_1
|
110
|
2018-06-15 15:04:08.397 MDT [17884] postgres@sublette LOG: statement: FETCH FORWARD 2000 FROM qgis_1
|
111
|
2018-06-15 15:04:09.184 MDT [17884] postgres@sublette LOG: statement: FETCH FORWARD 2000 FROM qgis_1
|
112
|
2018-06-15 15:04:10.363 MDT [17884] postgres@sublette LOG: statement: CLOSE qgis_1
|
113
|
2018-06-15 15:04:10.452 MDT [17884] postgres@sublette LOG: statement: COMMIT
|