postgresql2.18.log

Angie Rudolph, 2018-06-15 11:20 PM

Download (23.6 KB)

 
1
2018-06-15 15:03:44.526 MDT [17884] [email protected] LOG:  statement: set client_encoding to 'UNICODE'
2
2018-06-15 15:03:44.615 MDT [17884] [email protected] LOG:  statement: select regclass('pg_class')::oid
3
2018-06-15 15:03:44.705 MDT [17884] [email protected] LOG:  statement: BEGIN
4
2018-06-15 15:03:44.795 MDT [17884] [email protected] LOG:  statement: DECLARE oidcursor BINARY CURSOR FOR select regclass('pg_class')::oid
5
2018-06-15 15:03:44.884 MDT [17884] [email protected] LOG:  statement: fetch forward 1 from oidcursor
6
2018-06-15 15:03:44.982 MDT [17884] [email protected] LOG:  statement: CLOSE oidcursor
7
2018-06-15 15:03:45.070 MDT [17884] [email protected] LOG:  statement: COMMIT
8
2018-06-15 15:03:45.158 MDT [17884] [email protected] LOG:  statement: SELECT postgis_version()
9
2018-06-15 15:03:45.255 MDT [17884] [email protected] LOG:  statement: SELECT postgis_geos_version(),postgis_proj_version()
10
2018-06-15 15:03:45.345 MDT [17884] [email protected] 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] [email protected] LOG:  statement: SELECT oid FROM pg_catalog.pg_extension WHERE extname = 'pointcloud_postgis'
12
2018-06-15 15:03:45.523 MDT [17884] [email protected] LOG:  statement: SET application_name='QGIS'
13
2018-06-15 15:03:45.613 MDT [17884] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected]blette 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] postg[email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] LOG:  statement: set client_encoding to 'UNICODE'
64
2018-06-15 15:03:58.475 MDT [17895] [email protected] LOG:  statement: select regclass('pg_class')::oid
65
2018-06-15 15:03:58.564 MDT [17895] [email protected] LOG:  statement: BEGIN
66
2018-06-15 15:03:58.653 MDT [17895] [email protected] LOG:  statement: DECLARE oidcursor BINARY CURSOR FOR select regclass('pg_class')::oid
67
2018-06-15 15:03:58.742 MDT [17895] [email protected] LOG:  statement: fetch forward 1 from oidcursor
68
2018-06-15 15:03:58.832 MDT [17895] [email protected] LOG:  statement: CLOSE oidcursor
69
2018-06-15 15:03:58.921 MDT [17895] [email protected] LOG:  statement: COMMIT
70
2018-06-15 15:03:59.009 MDT [17895] [email protected] LOG:  statement: SELECT postgis_version()
71
2018-06-15 15:03:59.104 MDT [17895] [email protected] LOG:  statement: SELECT postgis_geos_version(),postgis_proj_version()
72
2018-06-15 15:03:59.194 MDT [17895] [email protected] 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] [email protected] LOG:  statement: SELECT oid FROM pg_catalog.pg_extension WHERE extname = 'pointcloud_postgis'
74
2018-06-15 15:03:59.374 MDT [17895] [email protected] LOG:  statement: SET application_name='QGIS'
75
2018-06-15 15:03:59.463 MDT [17895] [email protected] LOG:  statement: SELECT * FROM "work"."parcel" LIMIT 1
76
2018-06-15 15:03:59.553 MDT [17895] [email protected] LOG:  statement: SELECT pg_is_in_recovery()
77
2018-06-15 15:03:59.643 MDT [17895] [email protected] 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] [email protected] 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] [email protected] 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] [email protected] LOG:  statement: SELECT regclass('"work"."parcel"')::oid
81
2018-06-15 15:04:00.014 MDT [17895] [email protected] LOG:  statement: SELECT description FROM pg_description WHERE objoid=70281 AND objsubid=0
82
2018-06-15 15:04:00.105 MDT [17895] [email protected] LOG:  statement: SELECT * FROM "work"."parcel" LIMIT 0
83
2018-06-15 15:04:00.196 MDT [17895] [email protected] LOG:  statement: SELECT oid,typname,typtype,typelem,typlen FROM pg_type
84
2018-06-15 15:04:00.755 MDT [17895] [email protected] 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] [email protected] LOG:  statement: SELECT count(*) FROM pg_inherits WHERE inhparent='"work"."parcel"'::regclass
86
2018-06-15 15:04:00.941 MDT [17895] [email protected] 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] [email protected] 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] [email protected] LOG:  statement: set client_min_messages to error
89
2018-06-15 15:04:01.773 MDT [17897] [email protected] LOG:  statement: set client_encoding to 'UNICODE'
90
2018-06-15 15:04:01.863 MDT [17897] [email protected] LOG:  statement: select regclass('pg_class')::oid
91
2018-06-15 15:04:01.953 MDT [17897] [email protected] LOG:  statement: BEGIN
92
2018-06-15 15:04:02.042 MDT [17897] [email protected] LOG:  statement: DECLARE oidcursor BINARY CURSOR FOR select regclass('pg_class')::oid
93
2018-06-15 15:04:02.131 MDT [17897] [email protected] LOG:  statement: fetch forward 1 from oidcursor
94
2018-06-15 15:04:02.220 MDT [17897] [email protected] LOG:  statement: CLOSE oidcursor
95
2018-06-15 15:04:02.308 MDT [17897] [email protected] LOG:  statement: COMMIT
96
2018-06-15 15:04:02.396 MDT [17897] [email protected] LOG:  statement: SELECT postgis_version()
97
2018-06-15 15:04:02.493 MDT [17897] [email protected] LOG:  statement: SELECT postgis_geos_version(),postgis_proj_version()
98
2018-06-15 15:04:02.584 MDT [17897] [email protected] 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] [email protected] LOG:  statement: SELECT oid FROM pg_catalog.pg_extension WHERE extname = 'pointcloud_postgis'
100
2018-06-15 15:04:02.772 MDT [17897] [email protected] LOG:  statement: SET application_name='QGIS'
101
2018-06-15 15:04:02.859 MDT [17897] [email protected] LOG:  statement: SELECT COUNT(*) FROM information_schema.tables WHERE table_name='layer_styles'
102
2018-06-15 15:04:02.972 MDT [17895] [email protected] 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] [email protected] 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] [email protected] LOG:  statement: SELECT st_estimatedextent('work','parcel','wkb_geometry')
105
2018-06-15 15:04:03.342 MDT [17884] [email protected] LOG:  statement: BEGIN READ ONLY
106
2018-06-15 15:04:03.430 MDT [17884] [email protected] 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] [email protected] LOG:  statement: FETCH FORWARD 2000 FROM qgis_1
108
2018-06-15 15:04:05.650 MDT [17884] [email protected] LOG:  statement: FETCH FORWARD 2000 FROM qgis_1
109
2018-06-15 15:04:07.135 MDT [17884] [email protected] LOG:  statement: FETCH FORWARD 2000 FROM qgis_1
110
2018-06-15 15:04:08.397 MDT [17884] [email protected] LOG:  statement: FETCH FORWARD 2000 FROM qgis_1
111
2018-06-15 15:04:09.184 MDT [17884] [email protected] LOG:  statement: FETCH FORWARD 2000 FROM qgis_1
112
2018-06-15 15:04:10.363 MDT [17884] [email protected] LOG:  statement: CLOSE qgis_1
113
2018-06-15 15:04:10.452 MDT [17884] [email protected] LOG:  statement: COMMIT