> -----Original Message-----
> From: ldh@xxxxxxxxxxxxxxxxxx <ldh@xxxxxxxxxxxxxxxxxx>
> Sent: Saturday, August 21, 2021 19:02
> To: Justin Pryzby <pryzby@xxxxxxxxxxxxx>
> Cc: Tom Lane <tgl@xxxxxxxxxxxxx>; pgsql-performance@xxxxxxxxxxxxxx
> Subject: RE: Big Performance drop of Exceptions in UDFs between V11.2
> and 13.4
>
>
>
> > -----Original Message-----
> > From: Justin Pryzby <pryzby@xxxxxxxxxxxxx>
> > Sent: Saturday, August 21, 2021 18:17
> > To: ldh@xxxxxxxxxxxxxxxxxx
> > Cc: Tom Lane <tgl@xxxxxxxxxxxxx>; pgsql-
> performance@xxxxxxxxxxxxxx
> > Subject: Re: Big Performance drop of Exceptions in UDFs between
> V11.2
> > and 13.4
> >
> > Could you send SELECT * FROM pg_config() and try to find the CPU
> > model ?
> >
> > I think it's possible the hypervisor is trapping and emulating
> unhandled
> > CPU instructions.
> >
> > Actually, it would be interesting to see if the performance differs
> > between
> > 11.2 and 11.13. It's possible that EDB compiled 11.13 on a newer
> CPU
> > (or a newer compiler) than 11.2 was compiled.
> >
> > If you test that, it should be on a separate VM, unless the existing
> data
> > dir can be restored from backup. Once you've started a cluster with
> > updated binaries, you should avoid downgrading the binaries.
>
>
>
> Hello all,
>
> OK, I was able to do a clean install of 13.4 on the VM. All stock settings,
> no extensions loaded, pure clean straight out of the install.
>
> create table sampletest (a varchar, b varchar);
> -- truncate table sampletest;
> insert into sampletest (a, b)
> select substr(md5(random()::text), 0, 15),
> (100000000*random())::integer::varchar
> from generate_series(1,1000000);
>
> CREATE OR REPLACE FUNCTION toFloat(str varchar, val real) RETURNS
> real AS $$ BEGIN
> RETURN case when str is null then val else str::real end; EXCEPTION
> WHEN OTHERS THEN
> RETURN val;
> END;
> $$ LANGUAGE plpgsql COST 1 IMMUTABLE;
>
>
> explain (analyze,buffers,COSTS,TIMING) select MAX(toFloat(b, null)) as
> "b" from sampletest
>
> Aggregate (cost=21370.00..21370.01 rows=1 width=4) (actual
> time=1780.561..1780.563 rows=1 loops=1)
> Buffers: shared hit=6387
> -> Seq Scan on sampletest (cost=0.00..16370.00 rows=1000000
> width=8) (actual time=0.053..97.329 rows=1000000 loops=1)
> Buffers: shared hit=6370
> Planning:
> Buffers: shared hit=36
> Planning Time: 2.548 ms
> Execution Time: 1,810.330 ms
>
>
> explain (analyze,buffers,COSTS,TIMING) select MAX(toFloat(a, null)) as
> "a" from sampletest
>
> Aggregate (cost=21370.00..21370.01 rows=1 width=4) (actual
> time=863243.876..863243.877 rows=1 loops=1)
> Buffers: shared hit=6373
> -> Seq Scan on sampletest (cost=0.00..16370.00 rows=1000000
> width=15) (actual time=0.009..301.553 rows=1000000 loops=1)
> Buffers: shared hit=6370
> Planning:
> Buffers: shared hit=44
> Planning Time: 0.469 ms
> Execution Time: 863,243.911 ms
>
>
> So I am still able to reproduce this on a different VM and a clean install
> of 13.4 ☹
>
>
> SELECT * FROM pg_config();
>
> BINDIR C:/PROGRA~1/POSTGR~1/13/bin
> DOCDIR C:/PROGRA~1/POSTGR~1/13/doc
> HTMLDIR C:/PROGRA~1/POSTGR~1/13/doc
> INCLUDEDIR C:/PROGRA~1/POSTGR~1/13/include
> PKGINCLUDEDIR C:/PROGRA~1/POSTGR~1/13/include
> INCLUDEDIR-SERVER C:/PROGRA~1/POSTGR~1/13/include/server
> LIBDIR C:/PROGRA~1/POSTGR~1/13/lib
> PKGLIBDIR C:/PROGRA~1/POSTGR~1/13/lib
> LOCALEDIR C:/PROGRA~1/POSTGR~1/13/share/locale
> MANDIR C:/Program Files/PostgreSQL/13/man
> SHAREDIR C:/PROGRA~1/POSTGR~1/13/share
> SYSCONFDIR C:/Program Files/PostgreSQL/13/etc
> PGXS C:/Program Files/PostgreSQL/13/lib/pgxs/src/makefiles/pgxs.mk
> CONFIGURE --enable-thread-safety --enable-nls --with-ldap --with-
> openssl --with-uuid --with-libxml --with-libxslt --with-icu --with-tcl --with-
> perl --with-python
> CC not recorded
> CPPFLAGS not recorded
> CFLAGS not recorded
> CFLAGS_SL not recorded
> LDFLAGS not recorded
> LDFLAGS_EX not recorded
> LDFLAGS_SL not recorded
> LIBS not recorded
> VERSION PostgreSQL 13.4
>
>
> And here is SYSINFO:
>
> C:\Users\LHASSON>systeminfo
>
> Host Name: PRODDB
> OS Name: Microsoft Windows Server 2012 R2 Standard
> OS Version: 6.3.9600 N/A Build 9600
> OS Manufacturer: Microsoft Corporation
> OS Configuration: Member Server
> OS Build Type: Multiprocessor Free
> Original Install Date: 2015-09-19, 18:19:41
> System Boot Time: 2021-07-22, 11:45:09
> System Manufacturer: VMware, Inc.
> System Model: VMware Virtual Platform
> System Type: x64-based PC
> Processor(s): 4 Processor(s) Installed.
> [01]: Intel64 Family 6 Model 79 Stepping 1 GenuineIntel
> ~2397 Mhz
> [02]: Intel64 Family 6 Model 79 Stepping 1 GenuineIntel
> ~2397 Mhz
> [03]: Intel64 Family 6 Model 79 Stepping 1 GenuineIntel
> ~2397 Mhz
> [04]: Intel64 Family 6 Model 79 Stepping 1 GenuineIntel
> ~2397 Mhz
> BIOS Version: Phoenix Technologies LTD 6.00, 2020-05-28
> Windows Directory: C:\Windows
> System Directory: C:\Windows\system32
> Boot Device: \Device\HarddiskVolume1
> System Locale: en-us;English (United States)
> Input Locale: en-us;English (United States)
> Time Zone: (UTC-05:00) Eastern Time (US & Canada)
> Total Physical Memory: 65,535 MB
> Available Physical Memory: 57,791 MB
> Virtual Memory: Max Size: 75,263 MB
> Virtual Memory: Available: 66,956 MB
> Virtual Memory: In Use: 8,307 MB
> Page File Location(s): C:\pagefile.sys
>
And by the way, I reproduced this again on my personal laptop with a fresh clean base-line install of 13.4.
Systeminfo
-------------------
OS Name: Microsoft Windows 10 Pro
OS Version: 10.0.19043 N/A Build 19043
OS Manufacturer: Microsoft Corporation
OS Configuration: Standalone Workstation
OS Build Type: Multiprocessor Free
Registered Owner: Windows User
Registered Organization:
Product ID: 00330-50535-98614-AAOEM
Original Install Date: 2021-04-04, 09:50:59
System Boot Time: 2021-08-19, 10:18:03
System Manufacturer: LENOVO
System Model: 20HRCTO1WW
System Type: x64-based PC
Processor(s): 1 Processor(s) Installed.
[01]: Intel64 Family 6 Model 142 Stepping 9 GenuineIntel ~801 Mhz
BIOS Version: LENOVO N1MET64W (1.49 ), 2020-10-14
Windows Directory: C:\WINDOWS
System Directory: C:\WINDOWS\system32
Boot Device: \Device\HarddiskVolume1
System Locale: en-us;English (United States)
Input Locale: en-us;English (United States)
Time Zone: (UTC-05:00) Eastern Time (US & Canada)
Total Physical Memory: 16,219 MB
Available Physical Memory: 4,971 MB
Virtual Memory: Max Size: 32,603 MB
Virtual Memory: Available: 12,168 MB
Virtual Memory: In Use: 20,435 MB
Page File Location(s): C:\pagefile.sys
SELECT * FROM pg_config();
--------------------------------------------
BINDIR C:/PROGRA~1/POSTGR~1/13/bin
DOCDIR C:/PROGRA~1/POSTGR~1/13/doc
HTMLDIR C:/PROGRA~1/POSTGR~1/13/doc
INCLUDEDIR C:/PROGRA~1/POSTGR~1/13/include
PKGINCLUDEDIR C:/PROGRA~1/POSTGR~1/13/include
INCLUDEDIR-SERVER C:/PROGRA~1/POSTGR~1/13/include/server
LIBDIR C:/PROGRA~1/POSTGR~1/13/lib
PKGLIBDIR C:/PROGRA~1/POSTGR~1/13/lib
LOCALEDIR C:/PROGRA~1/POSTGR~1/13/share/locale
MANDIR C:/Program Files/PostgreSQL/13/man
SHAREDIR C:/PROGRA~1/POSTGR~1/13/share
SYSCONFDIR C:/Program Files/PostgreSQL/13/etc
PGXS C:/Program Files/PostgreSQL/13/lib/pgxs/src/makefiles/pgxs.mk
CONFIGURE --enable-thread-safety --enable-nls --with-ldap --with-openssl --with-uuid --with-libxml --with-libxslt --with-icu --with-tcl --with-perl --with-python
CC not recorded
CPPFLAGS not recorded
CFLAGS not recorded
CFLAGS_SL not recorded
LDFLAGS not recorded
LDFLAGS_EX not recorded
LDFLAGS_SL not recorded
LIBS not recorded
VERSION PostgreSQL 13.4
Tried to check this with Very Sleepy at Windows 10 (bare metal).
Not sure it can help if someone can guide how to test this better?Postgres (head)
Debug build with msvc 2019 64 bits.
explain (analyze,buffers,COSTS,TIMING) select MAX(toFloat(a, null)) as "a" from sampletest;
1. Postgres (head) with normal startup:
postgres=# explain (analyze,buffers,COSTS,TIMING) select MAX(toFloat(a, null)) as "a" from sampletest;
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=21370.00..21370.01 rows=1 width=4) (actual time=103064.061..103064.062 rows=1 loops=1)
Buffers: shared hit=6370
-> Seq Scan on sampletest (cost=0.00..16370.00 rows=1000000 width=15) (actual time=0.037..1253.552 rows=1000000 loops=1)
Buffers: shared hit=6370
Planning Time: 0.252 ms
Execution Time: 103064.136 ms
(6 rows)
QUERY PLAN
------------------------------------------------------------------------------------------------------------------------------
Aggregate (cost=21370.00..21370.01 rows=1 width=4) (actual time=103064.061..103064.062 rows=1 loops=1)
Buffers: shared hit=6370
-> Seq Scan on sampletest (cost=0.00..16370.00 rows=1000000 width=15) (actual time=0.037..1253.552 rows=1000000 loops=1)
Buffers: shared hit=6370
Planning Time: 0.252 ms
Execution Time: 103064.136 ms
(6 rows)
Files:
postgres.png (print screen from Very Sleepy)
postgres.csv
postgres.capture
2. Postgres (head) with --single startup:
backend> explain (analyze,buffers,COSTS,TIMING) select MAX(toFloat(a, null)) as "a" from sampletest;
1: QUERY PLAN (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = "Aggregate (cost=21370.00..21370.01 rows=1 width=4) (actual time=61820.815..61820.816 rows=1 loops=1)" (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = " Buffers: shared hit=11 read=6379" (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = " -> Seq Scan on sampletest (cost=0.00..16370.00 rows=1000000 width=15) (actual time=0.113..1607.444 rows=1000000 loops=1)" (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = " Buffers: shared read=6370" (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = "Planning:" (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = " Buffers: shared hit=51 read=24" (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = "Planning Time: 21.647 ms" (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = "Execution Time: 61835.470 ms" (typeid = 25, len = -1, typmod = -1, byval = f)
1: QUERY PLAN (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = "Aggregate (cost=21370.00..21370.01 rows=1 width=4) (actual time=61820.815..61820.816 rows=1 loops=1)" (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = " Buffers: shared hit=11 read=6379" (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = " -> Seq Scan on sampletest (cost=0.00..16370.00 rows=1000000 width=15) (actual time=0.113..1607.444 rows=1000000 loops=1)" (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = " Buffers: shared read=6370" (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = "Planning:" (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = " Buffers: shared hit=51 read=24" (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = "Planning Time: 21.647 ms" (typeid = 25, len = -1, typmod = -1, byval = f)
----
1: QUERY PLAN = "Execution Time: 61835.470 ms" (typeid = 25, len = -1, typmod = -1, byval = f)
postgres_single.png (print screen from Very Sleepy)
Attached some files with results.
regards,
Ranier Vilela
Attachment:
postgres.capture
Description: Binary data
Name,Exclusive secs,Inclusive secs,% Exclusive,% Inclusive,Module,Source File,Source Line "plpgsql_compile",0.117839,1.25201,0.0355265,0.377462,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_comp.c",137 "MemoryContextSwitchTo",0.0739634,0.0739634,0.0222988,0.0222988,"plpgsql","C:\dll\postgres\postgres\src\include\utils\palloc.h",110 "plpgsql_exec_function",0.521996,95.7026,0.157374,28.8528,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",475 "plpgsql_subxact_cb",0.332662,1.56392,0.100292,0.471496,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",8360 "plpgsql_exec_error_callback",0.0420896,3.91885,0.0126893,1.18147,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",1215 "copy_plpgsql_datums",0.333684,0.812194,0.1006,0.244864,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",1274 "get_stmt_mcontext",0.142035,0.280984,0.0428213,0.0847122,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",1507 "pop_stmt_mcontext",0.0962913,0.194206,0.0290303,0.0585501,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",1545 "exec_toplevel_block",0.0926197,91.4691,0.0279234,27.5765,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",1600 "exec_stmt_block",5.40944,91.3764,1.63086,27.5486,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",1626 "exec_stmts",0.414362,60.3314,0.124924,18.189,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",1952 "exec_stmt_return",0.184501,59.9171,0.0556242,18.064,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",3138 "plpgsql_estate_setup",0.33043,2.06276,0.0996194,0.621891,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",3933 "exec_eval_cleanup",0.122818,0.175172,0.0370277,0.0528115,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",4077 "exec_eval_simple_expr",0.101256,0.101256,0.0305269,0.0305269,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",5958 "exec_eval_expr",0.0180124,59.7326,0.00543045,18.0084,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",5621 "exec_run_select",0.0080222,59.6133,0.00241857,17.9725,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",5728 "setup_param_list",0.0119723,0.0119723,0.00360946,0.00360946,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",6199 "plpgsql_param_compile",0.327534,0.817417,0.0987463,0.246438,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",6361 "plpgsql_param_eval_var_ro",0.176651,0.290182,0.0532575,0.0874852,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",6467 "exec_set_found",0.0177746,0.0406868,0.00535876,0.0122664,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",8213 "plpgsql_create_econtext",0.0904546,2.274,0.0272706,0.685576,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",8226 "plpgsql_destroy_econtext",0.0349107,0.761688,0.010525,0.229637,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",8295 "assign_simple_var",0.145071,0.145071,0.0437365,0.0437365,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",8387 "assign_text_var",0.0235715,0.928989,0.00710643,0.280076,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",8453 "exception_matches_conditions",0.0369618,0.0369618,0.0111434,0.0111434,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_exec.c",1558 "plpgsql_stmt_typename",0.205643,0.205643,0.0619982,0.0619982,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_funcs.c",233 "plpgsql_call_handler",0.362165,99.111,0.109187,29.8804,"plpgsql","C:\dll\postgres\postgres\src\pl\plpgsql\src\pl_handler.c",223 "set_errcontext_domain",0.004987,0.004987,0.0015035,0.0015035,"plpgsql","[unknown]",0 "palloc",0.0059878,0.0059878,0.00180523,0.00180523,"plpgsql","[unknown]",0 "SearchSysCache1",0.005008,0.005008,0.00150983,0.00150983,"plpgsql","[unknown]",0 "ReleaseSysCache",0.0049771,0.0049771,0.00150052,0.00150052,"plpgsql","[unknown]",0 "CopyErrorData",0.0099652,0.0099652,0.00300435,0.00300435,"plpgsql","[unknown]",0 "MakeExpandedObjectReadOnlyInternal",0.0059836,0.0059836,0.00180396,0.00180396,"plpgsql","[unknown]",0 "ExprEvalPushStep",0.0069827,0.0069827,0.00210517,0.00210517,"plpgsql","[unknown]",0 "SPI_connect_ext",0.0069754,0.0069754,0.00210297,0.00210297,"plpgsql","[unknown]",0 "SPI_finish",0.0051131,0.0051131,0.00154152,0.00154152,"plpgsql","[unknown]",0 "__GSHandlerCheck",0.0208694,0.0995084,0.00629179,0.0300002,"plpgsql","d:\a01\_work\2\s\src\vctools\crt\vcstartup\src\gs\amd64\gshandler.cpp",74 "__GSHandlerCheckCommon",0.0597756,0.078639,0.0180214,0.0237084,"plpgsql","d:\a01\_work\2\s\src\vctools\crt\vcstartup\src\gs\amd64\gshandler.cpp",128 "__security_check_cookie",0.0507713,0.0507713,0.0153067,0.0153067,"plpgsql","d:\a01\_work\2\s\src\vctools\crt\vcstartup\src\gs\amd64\amdsecgs.asm",45 "memcpy",0.005982,0.005982,0.00180348,0.00180348,"plpgsql","[unknown]",0 "_intrinsic_setjmp",0.0119732,0.0119732,0.00360973,0.00360973,"plpgsql","[unknown]",0 "heap_fill_tuple",0,0.0059954,0,0.00180752,"postgres","C:\dll\postgres\postgres\src\backend\access\common\heaptuple.c",343 "heap_form_tuple",0,0.0119761,0,0.0036106,"postgres","C:\dll\postgres\postgres\src\backend\access\common\heaptuple.c",1069 "fill_val",0.0059954,0.0059954,0.00180752,0.00180752,"postgres","C:\dll\postgres\postgres\src\backend\access\common\heaptuple.c",182 "CreateTemplateTupleDesc",0.0622488,0.398015,0.018767,0.119995,"postgres","C:\dll\postgres\postgres\src\backend\access\common\tupdesc.c",46 "CreateTupleDescCopy",0.0863072,0.297725,0.0260203,0.0897595,"postgres","C:\dll\postgres\postgres\src\backend\access\common\tupdesc.c",112 "TupleDescInitEntry",0.246567,1.44581,0.074336,0.435888,"postgres","C:\dll\postgres\postgres\src\backend\access\common\tupdesc.c",589 "TupleDescInitEntryCollation",0.0440975,0.0440975,0.0132947,0.0132947,"postgres","C:\dll\postgres\postgres\src\backend\access\common\tupdesc.c",757 "TestForOldSnapshot",0.0789309,0.0789309,0.0237964,0.0237964,"postgres","C:\dll\postgres\postgres\src\include\storage\bufmgr.h",279 "heapgetpage",0.0517327,0.162019,0.0155966,0.0488461,"postgres","C:\dll\postgres\postgres\src\backend\access\heap\heapam.c",389 "heap_getnextslot",0.30939,0.94544,0.093276,0.285035,"postgres","C:\dll\postgres\postgres\src\backend\access\heap\heapam.c",1390 "HeapCheckForSerializableConflictOut",0.006002,0.0149704,0.00180951,0.00451334,"postgres","C:\dll\postgres\postgres\src\backend\access\heap\heapam.c",9796 "heapgettup_pagemode",0.30718,0.54813,0.0926099,0.165252,"postgres","C:\dll\postgres\postgres\src\backend\access\heap\heapam.c",848 "heap_page_prune_opt",0.0055143,0.0055143,0.00166247,0.00166247,"postgres","C:\dll\postgres\postgres\src\backend\access\heap\pruneheap.c",118 "MemoryContextSwitchTo",0.498329,0.498329,0.150238,0.150238,"postgres","C:\dll\postgres\postgres\src\include\utils\palloc.h",110 "FullTransactionIdFromEpochAndXid",0.0057022,0.0057022,0.00171912,0.00171912,"postgres","C:\dll\postgres\postgres\src\include\access\transam.h",72 "GetCurrentTransactionIdIfAny",0.017141,0.017141,0.00516774,0.00516774,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",456 "GetCurrentSubTransactionId",0.0751782,0.0751782,0.022665,0.022665,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",724 "GetCurrentTransactionNestLevel",0.0506357,0.0506357,0.0152659,0.0152659,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",859 "StartTransactionCommand",0.0945769,0.106747,0.0285134,0.0321824,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",2839 "CommitTransactionCommand",0.150455,2.89156,0.0453598,0.871759,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",2940 "BeginInternalSubTransaction",0.1479,3.87316,0.0445894,1.1677,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",4408 "ReleaseCurrentSubTransaction",0,0.017957,0,0.00541375,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",4500 "RollbackAndReleaseCurrentSubTransaction",0.112795,15.8841,0.034006,4.78882,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",4513 "IsInParallelMode",0.0343719,0.0343719,0.0103626,0.0103626,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",1013 "pgstat_report_wait_end",0.053893,0.053893,0.0162479,0.0162479,"postgres","C:\dll\postgres\postgres\src\include\utils\wait_event.h",281 "CallSubXactCallbacks",0.153243,1.71716,0.0462004,0.517697,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",3619 "RecordTransactionAbort",0.0636766,0.0808176,0.0191975,0.0243652,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",1642 "StartSubTransaction",0.0526387,2.7411,0.0158697,0.826399,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",4781 "CommitSubTransaction",0,0.017957,0,0.00541375,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",4864 "AbortSubTransaction",0.286817,14.1584,0.0864707,4.26854,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",4925 "CleanupSubTransaction",0.0795804,1.61292,0.0239922,0.48627,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",5079 "PushTransaction",0.0582892,0.712028,0.0175733,0.214665,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",5112 "PopTransaction",0.0189666,0.188995,0.00571813,0.0569788,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",5175 "AtSubAbort_Memory",0.0129692,0.0186114,0.00391001,0.00561104,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",1777 "AtSubCleanup_Memory",0.0424056,0.228423,0.0127846,0.068866,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",1886 "AtSubAbort_ResourceOwner",0.0788519,0.0788519,0.0237726,0.0237726,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",1799 "AtSubStart_Memory",0.0220471,0.180939,0.00664685,0.0545502,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",1181 "AtSubStart_ResourceOwner",0.0309476,2.134,0.00933021,0.643368,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",1195 "ShowTransactionState",0.047842,0.33622,0.0144236,0.101365,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xact.c",5341 "XLogResetInsertion",0.124189,0.124189,0.0374411,0.0374411,"postgres","C:\dll\postgres\postgres\src\backend\access\transam\xloginsert.c",209 "ResetReindexState",0.0263718,0.0263718,0.00795068,0.00795068,"postgres","C:\dll\postgres\postgres\src\backend\catalog\index.c",4043 "OverrideSearchPathMatchesCurrent",0.0854128,0.258666,0.0257506,0.0779836,"postgres","C:\dll\postgres\postgres\src\backend\catalog\namespace.c",3465 "AtEOSubXact_Namespace",0.0337658,0.0337658,0.0101799,0.0101799,"postgres","C:\dll\postgres\postgres\src\backend\catalog\namespace.c",4179 "recomputeNamespacePath",0.143966,0.173253,0.0434035,0.052233,"postgres","C:\dll\postgres\postgres\src\backend\catalog\namespace.c",3783 "smgrDoPendingDeletes",0.242714,0.261491,0.0731745,0.0788354,"postgres","C:\dll\postgres\postgres\src\backend\catalog\storage.c",613 "AtSubAbort_smgr",0.0996009,0.361092,0.0300281,0.108864,"postgres","C:\dll\postgres\postgres\src\backend\catalog\storage.c",915 "AtSubAbort_Notify",0.0982736,0.11064,0.0296279,0.0333561,"postgres","C:\dll\postgres\postgres\src\backend\commands\async.c",1847 "ExplainQuery",0,103.061,0,31.0713,"postgres","C:\dll\postgres\postgres\src\backend\commands\explain.c",286 "ExplainOnePlan",0,103.061,0,31.0713,"postgres","C:\dll\postgres\postgres\src\backend\commands\explain.c",596 "ExplainOneQuery",0,103.061,0,31.0713,"postgres","C:\dll\postgres\postgres\src\backend\commands\explain.c",413 "AtEOSubXact_on_commit_actions",0.0283331,0.0283331,0.00854198,0.00854198,"postgres","C:\dll\postgres\postgres\src\backend\commands\tablecmds.c",16391 "AfterTriggerBeginSubXact",0.129465,0.134566,0.0390316,0.0405695,"postgres","C:\dll\postgres\postgres\src\backend\commands\trigger.c",4942 "AfterTriggerEndSubXact",0.152039,0.227204,0.0458374,0.0684983,"postgres","C:\dll\postgres\postgres\src\backend\commands\trigger.c",4989 "afterTriggerFreeEventList",0.0270197,0.0270197,0.00814601,0.00814601,"postgres","C:\dll\postgres\postgres\src\backend\commands\trigger.c",3909 "afterTriggerRestoreEventList",0.0417379,0.0687576,0.0125833,0.0207293,"postgres","C:\dll\postgres\postgres\src\backend\commands\trigger.c",3928 "ExprEvalPushStep",0.210415,0.849854,0.0634368,0.256218,"postgres","C:\dll\postgres\postgres\src\backend\executor\execExpr.c",2446 "ExecInitQual",0.118196,0.123171,0.0356342,0.0371342,"postgres","C:\dll\postgres\postgres\src\backend\executor\execExpr.c",210 "ExecBuildProjectionInfo",0.188852,7.90021,0.0569358,2.38179,"postgres","C:\dll\postgres\postgres\src\backend\executor\execExpr.c",358 "ExecReadyExpr",0.0365971,0.166231,0.0110334,0.0501161,"postgres","C:\dll\postgres\postgres\src\backend\executor\execExpr.c",884 "ExecInitExprRec",1.0581,5.329,0.319,1.60661,"postgres","C:\dll\postgres\postgres\src\backend\executor\execExpr.c",902 "ExecInitExprSlots",0.01858,1.18234,0.00560158,0.356456,"postgres","C:\dll\postgres\postgres\src\backend\executor\execExpr.c",2578 "ExecPushExprSlots",0.11109,0.125114,0.0334918,0.0377198,"postgres","C:\dll\postgres\postgres\src\backend\executor\execExpr.c",2595 "get_last_attnums_walker",0.239729,1.03864,0.0722745,0.313135,"postgres","C:\dll\postgres\postgres\src\backend\executor\execExpr.c",2639 "slot_getsomeattrs",0.0051545,0.330414,0.001554,0.0996147,"postgres","C:\dll\postgres\postgres\src\include\executor\tuptable.h",342 "ExecReadyInterpretedExpr",0.0658531,0.0868177,0.0198537,0.0261742,"postgres","C:\dll\postgres\postgres\src\backend\executor\execExprInterp.c",231 "ExecEvalStepOp",0.105241,0.105241,0.0317286,0.0317286,"postgres","C:\dll\postgres\postgres\src\backend\executor\execExprInterp.c",2319 "ExecInterpExprStillValid",0.0129721,38.4321,0.00391088,11.5867,"postgres","C:\dll\postgres\postgres\src\backend\executor\execExprInterp.c",1813 "CheckExprStillValid",0.234554,0.339796,0.0707145,0.102443,"postgres","C:\dll\postgres\postgres\src\backend\executor\execExprInterp.c",1833 "ExecInterpExpr",1.19276,100.258,0.359599,30.2263,"postgres","C:\dll\postgres\postgres\src\backend\executor\execExprInterp.c",391 "ExecInitInterpreter",0.0209646,0.0209646,0.00632049,0.00632049,"postgres","C:\dll\postgres\postgres\src\backend\executor\execExprInterp.c",2287 "CheckOpSlotCompatibility",0.0049514,0.0049514,0.00149277,0.00149277,"postgres","C:\dll\postgres\postgres\src\backend\executor\execExprInterp.c",1935 "ExecutorStart",0.116931,16.4587,0.0352529,4.96203,"postgres","C:\dll\postgres\postgres\src\backend\executor\execMain.c",131 "standard_ExecutorStart",0.0794353,16.0567,0.0239485,4.84084,"postgres","C:\dll\postgres\postgres\src\backend\executor\execMain.c",171 "ExecutorRun",0.0426055,103.061,0.0128449,31.0713,"postgres","C:\dll\postgres\postgres\src\backend\executor\execMain.c",301 "standard_ExecutorRun",0.108264,103.061,0.0326398,31.0713,"postgres","C:\dll\postgres\postgres\src\backend\executor\execMain.c",311 "ExecutorEnd",0,0.0169606,0,0.00511335,"postgres","C:\dll\postgres\postgres\src\backend\executor\execMain.c",465 "standard_ExecutorEnd",0,0.0169606,0,0.00511335,"postgres","C:\dll\postgres\postgres\src\backend\executor\execMain.c",496 "ExecCheckRTPerms",0.0766906,0.180933,0.023121,0.0545486,"postgres","C:\dll\postgres\postgres\src\backend\executor\execMain.c",569 "ExecProcNode",0.078892,103.061,0.0237847,31.0713,"postgres","C:\dll\postgres\postgres\src\include\executor\executor.h",253 "InitPlan",0.388441,14.7422,0.117109,4.44454,"postgres","C:\dll\postgres\postgres\src\backend\executor\execMain.c",804 "ExecEndPlan",0,0.0049846,0,0.00150278,"postgres","C:\dll\postgres\postgres\src\backend\executor\execMain.c",1412 "ExecutePlan",0.0280732,103.061,0.00846362,31.0713,"postgres","C:\dll\postgres\postgres\src\backend\executor\execMain.c",1515 "ExecCheckRTEPerms",0.104243,0.104243,0.0314276,0.0314276,"postgres","C:\dll\postgres\postgres\src\backend\executor\execMain.c",600 "ExecInitNode",0.261383,13.8783,0.0788027,4.1841,"postgres","C:\dll\postgres\postgres\src\backend\executor\execProcnode.c",142 "ExecSetExecProcNode",0.0387325,0.0387325,0.0116772,0.0116772,"postgres","C:\dll\postgres\postgres\src\backend\executor\execProcnode.c",425 "ExecEndNode",0,0.0049846,0,0.00150278,"postgres","C:\dll\postgres\postgres\src\backend\executor\execProcnode.c",584 "ExecProcNodeFirst",0.0049122,103.061,0.00148095,31.0713,"postgres","C:\dll\postgres\postgres\src\backend\executor\execProcnode.c",443 "ExecProcNodeInstr",0.0607292,103.061,0.0183089,31.0713,"postgres","C:\dll\postgres\postgres\src\backend\executor\execProcnode.c",474 "ExecScan",0.0899883,1.27314,0.02713,0.383831,"postgres","C:\dll\postgres\postgres\src\backend\executor\execScan.c",161 "ExecScanFetch",0.0201161,1.07839,0.00606469,0.325118,"postgres","C:\dll\postgres\postgres\src\backend\executor\execScan.c",38 "MakeTupleTableSlot",0.221078,0.589697,0.0666516,0.177784,"postgres","C:\dll\postgres\postgres\src\backend\executor\execTuples.c",1114 "ExecAllocTableSlot",0.0797247,0.879965,0.0240357,0.265295,"postgres","C:\dll\postgres\postgres\src\backend\executor\execTuples.c",1173 "ExecStoreBufferHeapTuple",0.0154658,0.087921,0.00466269,0.0265068,"postgres","C:\dll\postgres\postgres\src\backend\executor\execTuples.c",1408 "slot_getsomeattrs_int",0.0279683,0.32526,0.008432,0.0980607,"postgres","C:\dll\postgres\postgres\src\backend\executor\execTuples.c",1908 "ExecInitResultTypeTL",0.0389333,2.57724,0.0117378,0.776996,"postgres","C:\dll\postgres\postgres\src\backend\executor\execTuples.c",1757 "ExecInitResultSlot",0.0589723,0.938937,0.0177792,0.283075,"postgres","C:\dll\postgres\postgres\src\backend\executor\execTuples.c",1780 "ExecInitResultTupleSlotTL",0.0378212,3.55399,0.0114025,1.07147,"postgres","C:\dll\postgres\postgres\src\backend\executor\execTuples.c",1801 "ExecTypeFromTL",0.0119622,2.5383,0.00360641,0.765258,"postgres","C:\dll\postgres\postgres\src\backend\executor\execTuples.c",1940 "ExecTypeFromTLInternal",0.0803219,2.52634,0.0242158,0.761652,"postgres","C:\dll\postgres\postgres\src\backend\executor\execTuples.c",1957 "slot_deform_heap_tuple",0.286325,0.286325,0.0863225,0.0863225,"postgres","C:\dll\postgres\postgres\src\backend\executor\execTuples.c",928 "tts_buffer_heap_store_tuple",0.0654731,0.0724552,0.0197391,0.0218441,"postgres","C:\dll\postgres\postgres\src\backend\executor\execTuples.c",873 "tts_virtual_clear",0.112112,0.112112,0.0338001,0.0338001,"postgres","C:\dll\postgres\postgres\src\backend\executor\execTuples.c",108 "tts_virtual_copy_heap_tuple",0,0.0119761,0,0.0036106,"postgres","C:\dll\postgres\postgres\src\backend\executor\execTuples.c",283 "tts_buffer_heap_getsomeattrs",0.0109663,0.297292,0.00330617,0.0896287,"postgres","C:\dll\postgres\postgres\src\backend\executor\execTuples.c",690 "list_length",0.0509103,0.0509103,0.0153486,0.0153486,"postgres","C:\dll\postgres\postgres\src\include\nodes\pg_list.h",150 "CreateExecutorState",0.0899953,1.11271,0.0271322,0.335464,"postgres","C:\dll\postgres\postgres\src\backend\executor\execUtils.c",99 "FreeExecutorState",0,0.011976,0,0.00361057,"postgres","C:\dll\postgres\postgres\src\backend\executor\execUtils.c",203 "CreateExprContext",0.0489197,2.98721,0.0147485,0.900595,"postgres","C:\dll\postgres\postgres\src\backend\executor\execUtils.c",302 "FreeExprContext",0.121728,1.6248,0.036699,0.489851,"postgres","C:\dll\postgres\postgres\src\backend\executor\execUtils.c",412 "ExecAssignExprContext",0.0124879,1.06332,0.0037649,0.320574,"postgres","C:\dll\postgres\postgres\src\backend\executor\execUtils.c",481 "ExecGetResultType",0.0279273,0.0279273,0.00841964,0.00841964,"postgres","C:\dll\postgres\postgres\src\backend\executor\execUtils.c",492 "ExecAssignProjectionInfo",0.0119405,7.91215,0.00359987,2.38539,"postgres","C:\dll\postgres\postgres\src\backend\executor\execUtils.c",538 "ExecFreeExprContext",0.0049846,0.0049846,0.00150278,0.00150278,"postgres","C:\dll\postgres\postgres\src\backend\executor\execUtils.c",651 "ExecInitRangeTable",0.140028,0.266556,0.0422163,0.0803625,"postgres","C:\dll\postgres\postgres\src\backend\executor\execUtils.c",752 "ExecTargetListLength",0.0574987,0.0924069,0.0173349,0.0278592,"postgres","C:\dll\postgres\postgres\src\backend\executor\execUtils.c",1138 "ShutdownExprContext",0.0776288,0.0776288,0.0234039,0.0234039,"postgres","C:\dll\postgres\postgres\src\backend\executor\execUtils.c",983 "CreateExprContextInternal",0.22969,2.93829,0.0692478,0.885847,"postgres","C:\dll\postgres\postgres\src\backend\executor\execUtils.c",233 "InstrStartNode",0.15834,0.499599,0.0477371,0.150621,"postgres","C:\dll\postgres\postgres\src\backend\executor\instrument.c",69 "InstrStopNode",0.0276745,0.242065,0.00834342,0.0729788,"postgres","C:\dll\postgres\postgres\src\backend\executor\instrument.c",85 "BufferUsageAccumDiff",0.137097,0.137097,0.0413327,0.0413327,"postgres","C:\dll\postgres\postgres\src\backend\executor\instrument.c",247 "ExecEvalExprSwitchContext",0.160829,100.528,0.0484873,30.3075,"postgres","C:\dll\postgres\postgres\src\include\executor\executor.h",338 "fetch_input_tuple",0.0259371,2.18919,0.00781962,0.660006,"postgres","C:\dll\postgres\postgres\src\backend\executor\nodeAgg.c",582 "advance_aggregates",0.0703002,100.598,0.0211944,30.3287,"postgres","C:\dll\postgres\postgres\src\backend\executor\nodeAgg.c",840 "agg_retrieve_direct",0.175925,103.061,0.0530387,31.0713,"postgres","C:\dll\postgres\postgres\src\backend\executor\nodeAgg.c",2448 "ExecAgg",0,103.061,0,31.0713,"postgres","C:\dll\postgres\postgres\src\backend\executor\nodeAgg.c",2180 "ExecClearTuple",0.0277014,0.139814,0.00835153,0.0421517,"postgres","C:\dll\postgres\postgres\src\include\executor\tuptable.h",426 "ExecProject",0.0169571,38.6358,0.0051123,11.6481,"postgres","C:\dll\postgres\postgres\src\include\executor\executor.h",363 "ExecInitResult",0.0929663,13.5176,0.0280279,4.07535,"postgres","C:\dll\postgres\postgres\src\backend\executor\nodeResult.c",182 "ExecEndResult",0,0.0049846,0,0.00150278,"postgres","C:\dll\postgres\postgres\src\backend\executor\nodeResult.c",251 "ExecResult",0.0451992,38.7219,0.0136268,11.674,"postgres","C:\dll\postgres\postgres\src\backend\executor\nodeResult.c",69 "table_scan_getnextslot",0.0618076,1.00725,0.018634,0.303669,"postgres","C:\dll\postgres\postgres\src\include\access\tableam.h",1033 "SeqNext",0.0510293,1.05828,0.0153845,0.319054,"postgres","C:\dll\postgres\postgres\src\backend\executor\nodeSeqscan.c",51 "ExecSeqScan",0.0236279,1.29677,0.00712344,0.390954,"postgres","C:\dll\postgres\postgres\src\backend\executor\nodeSeqscan.c",109 "list_nth_cell",0.0553287,0.0553287,0.0166807,0.0166807,"postgres","C:\dll\postgres\postgres\src\include\nodes\pg_list.h",260 "ExecCopySlotHeapTuple",0,0.0119761,0,0.0036106,"postgres","C:\dll\postgres\postgres\src\include\executor\tuptable.h",457 "slist_init",0.010825,0.010825,0.00326357,0.00326357,"postgres","C:\dll\postgres\postgres\src\include\lib\ilist.h",574 "slist_push_head",0.0251158,0.0251158,0.00757202,0.00757202,"postgres","C:\dll\postgres\postgres\src\include\lib\ilist.h",594 "slist_delete_current",0.0050005,0.0050005,0.00150757,0.00150757,"postgres","C:\dll\postgres\postgres\src\include\lib\ilist.h",684 "spi_dest_startup",0.119715,1.05598,0.0360922,0.318362,"postgres","C:\dll\postgres\postgres\src\backend\executor\spi.c",2005 "spi_printtup",0,0.0119761,0,0.0036106,"postgres","C:\dll\postgres\postgres\src\backend\executor\spi.c",2076 "SPI_connect_ext",0.150788,0.481949,0.0454603,0.1453,"postgres","C:\dll\postgres\postgres\src\backend\executor\spi.c",105 "SPI_finish",0.17266,1.16856,0.0520544,0.352304,"postgres","C:\dll\postgres\postgres\src\backend\executor\spi.c",186 "SPI_execute_plan_with_paramlist",0.0582335,59.5933,0.0175565,17.9664,"postgres","C:\dll\postgres\postgres\src\backend\executor\spi.c",641 "AtEOSubXact_SPI",0.225507,2.50758,0.0679868,0.755996,"postgres","C:\dll\postgres\postgres\src\backend\executor\spi.c",397 "_SPI_execute_plan",0.362877,59.479,0.109402,17.932,"postgres","C:\dll\postgres\postgres\src\backend\executor\spi.c",2280 "_SPI_pquery",0.114577,56.6152,0.0345433,17.0686,"postgres","C:\dll\postgres\postgres\src\backend\executor\spi.c",2703 "_SPI_error_callback",0.0952617,2.69742,0.0287199,0.81323,"postgres","C:\dll\postgres\postgres\src\backend\executor\spi.c",2784 "_SPI_begin_call",0.0712129,0.105302,0.0214696,0.0317469,"postgres","C:\dll\postgres\postgres\src\backend\executor\spi.c",2900 "_SPI_execmem",0.0069756,0.034089,0.00210303,0.0102773,"postgres","C:\dll\postgres\postgres\src\backend\executor\spi.c",2882 "_SPI_procmem",0.0193473,0.0461431,0.0058329,0.0139114,"postgres","C:\dll\postgres\postgres\src\backend\executor\spi.c",2888 "jit_compile_expr",0.0428166,0.0428166,0.0129085,0.0129085,"postgres","C:\dll\postgres\postgres\src\backend\jit\jit.c",154 "AtEOSubXact_LargeObject",0.0634795,0.0634795,0.0191381,0.0191381,"postgres","C:\dll\postgres\postgres\src\backend\libpq\be-fsstubs.c",634 "secure_read",0,7.50321,0,2.2621,"postgres","C:\dll\postgres\postgres\src\backend\libpq\be-secure.c",206 "pq_getbyte",0,7.50321,0,2.2621,"postgres","C:\dll\postgres\postgres\src\backend\libpq\pqcomm.c",1000 "pq_recvbuf",0,7.50321,0,2.2621,"postgres","C:\dll\postgres\postgres\src\backend\libpq\pqcomm.c",957 "main",0,110.564,0,33.3334,"postgres","C:\dll\postgres\postgres\src\backend\main\main.c",190 "list_last_cell",0.018067,0.018067,0.00544691,0.00544691,"postgres","C:\dll\postgres\postgres\src\include\nodes\pg_list.h",270 "lappend",0.02343,0.210543,0.00706377,0.0634754,"postgres","C:\dll\postgres\postgres\src\backend\nodes\list.c",337 "lappend_int",0.0398577,0.273277,0.0120165,0.0823888,"postgres","C:\dll\postgres\postgres\src\backend\nodes\list.c",355 "lcons",0.0940681,0.641564,0.02836,0.193421,"postgres","C:\dll\postgres\postgres\src\backend\nodes\list.c",469 "list_delete_ptr",0.120453,0.59799,0.0363148,0.180284,"postgres","C:\dll\postgres\postgres\src\backend\nodes\list.c",812 "list_delete_nth_cell",0.0528834,0.464782,0.0159435,0.140125,"postgres","C:\dll\postgres\postgres\src\backend\nodes\list.c",712 "list_delete_cell",0.0127539,0.477536,0.0038451,0.14397,"postgres","C:\dll\postgres\postgres\src\backend\nodes\list.c",784 "list_free",0.0173669,0.265809,0.00523585,0.0801371,"postgres","C:\dll\postgres\postgres\src\backend\nodes\list.c",1392 "pg_nextpower2_32",0.0371561,0.0371561,0.011202,0.011202,"postgres","C:\dll\postgres\postgres\src\include\port\pg_bitutils.h",147 "new_list",0.130016,0.802607,0.0391979,0.241973,"postgres","C:\dll\postgres\postgres\src\backend\nodes\list.c",89 "new_head_cell",0.0614558,0.0980065,0.0185279,0.0295474,"postgres","C:\dll\postgres\postgres\src\backend\nodes\list.c",303 "list_free_private",0.11474,0.248442,0.0345924,0.0749013,"postgres","C:\dll\postgres\postgres\src\backend\nodes\list.c",1366 "exprType",0.346827,0.346827,0.104563,0.104563,"postgres","C:\dll\postgres\postgres\src\backend\nodes\nodeFuncs.c",42 "exprTypmod",0.223573,0.393518,0.0674038,0.118639,"postgres","C:\dll\postgres\postgres\src\backend\nodes\nodeFuncs.c",268 "exprCollation",0.174091,0.174091,0.0524858,0.0524858,"postgres","C:\dll\postgres\postgres\src\backend\nodes\nodeFuncs.c",760 "expression_tree_walker",0.633177,0.995231,0.190893,0.300046,"postgres","C:\dll\postgres\postgres\src\backend\nodes\nodeFuncs.c",1907 "makeParamList",0.0865211,0.35973,0.0260847,0.108453,"postgres","C:\dll\postgres\postgres\src\backend\nodes\params.c",45 "pgwin32_dispatch_queued_signals",0.0129704,4.82301,0.00391037,1.45406,"postgres","C:\dll\postgres\postgres\src\backend\port\win32\signal.c",113 "pqsigsetmask",0.0413223,4.86433,0.012458,1.46652,"postgres","C:\dll\postgres\postgres\src\backend\port\win32\signal.c",148 "pg_signal_thread",0,110.564,0,33.3333,"postgres","C:\dll\postgres\postgres\src\backend\port\win32\signal.c",262 "pg_timer_thread",0,110.564,0,33.3333,"postgres","C:\dll\postgres\postgres\src\backend\port\win32\timer.c",48 "AtEOSubXact_PgStat",0.133048,0.133048,0.0401118,0.0401118,"postgres","C:\dll\postgres\postgres\src\backend\postmaster\pgstat.c",2423 "SubPostmasterMain",0,110.564,0,33.3334,"postgres","C:\dll\postgres\postgres\src\backend\postmaster\postmaster.c",5020 "BackendRun",0,110.564,0,33.3334,"postgres","C:\dll\postgres\postgres\src\backend\postmaster\postmaster.c",4515 "ResetLogicalStreamingState",0.0050297,0.0050297,0.00151637,0.00151637,"postgres","C:\dll\postgres\postgres\src\backend\replication\logical\logical.c",1786 "BufTableHashCode",0,0.0112871,0,0.00340288,"postgres","C:\dll\postgres\postgres\src\backend\storage\buffer\buf_table.c",82 "BufTableLookup",0,0.0129528,0,0.00390506,"postgres","C:\dll\postgres\postgres\src\backend\storage\buffer\buf_table.c",95 "ReadBufferExtended",0.007019,0.0694045,0.00211612,0.0209244,"postgres","C:\dll\postgres\postgres\src\backend\storage\buffer\bufmgr.c",743 "ReleaseBuffer",0,0.0203585,0,0.00613777,"postgres","C:\dll\postgres\postgres\src\backend\storage\buffer\bufmgr.c",3774 "UnlockBuffers",0.0312568,0.0312568,0.00942343,0.00942343,"postgres","C:\dll\postgres\postgres\src\backend\storage\buffer\bufmgr.c",3971 "LockBuffer",0,0.0070205,0,0.00211657,"postgres","C:\dll\postgres\postgres\src\backend\storage\buffer\bufmgr.c",4009 "AbortBufferIO",0.0363738,0.0363738,0.0109661,0.0109661,"postgres","C:\dll\postgres\postgres\src\backend\storage\buffer\bufmgr.c",4470 "ReadBuffer_common",0.0080203,0.0623855,0.00241799,0.0188082,"postgres","C:\dll\postgres\postgres\src\backend\storage\buffer\bufmgr.c",809 "UnpinBuffer",0.0133764,0.0203585,0.00403277,0.00613777,"postgres","C:\dll\postgres\postgres\src\backend\storage\buffer\bufmgr.c",1826 "BufferAlloc",0,0.0543652,0,0.0163902,"postgres","C:\dll\postgres\postgres\src\backend\storage\buffer\bufmgr.c",1113 "AtEOSubXact_Files",0.0914029,0.0914029,0.0275565,0.0275565,"postgres","C:\dll\postgres\postgres\src\backend\storage\file\fd.c",3008 "WaitEventSetWait",0,7.50321,0,2.2621,"postgres","C:\dll\postgres\postgres\src\backend\storage\ipc\latch.c",1396 "WaitEventSetWaitBlock",0,7.50321,0,2.2621,"postgres","C:\dll\postgres\postgres\src\backend\storage\ipc\latch.c",1892 "ConditionVariableCancelSleep",0.0852548,0.0852548,0.025703,0.025703,"postgres","C:\dll\postgres\postgres\src\backend\storage\lmgr\condition_variable.c",229 "AbortStrongLockAcquire",0.0849694,0.0849694,0.0256169,0.0256169,"postgres","C:\dll\postgres\postgres\src\backend\storage\lmgr\lock.c",1760 "LockReleaseCurrentOwner",0.144322,0.144322,0.0435107,0.0435107,"postgres","C:\dll\postgres\postgres\src\backend\storage\lmgr\lock.c",2485 "pg_atomic_read_u32_impl",0.006983,0.006983,0.00210526,0.00210526,"postgres","C:\dll\postgres\postgres\src\include\port\atomics\generic.h",49 "pg_atomic_read_u32",0,0.006983,0,0.00210526,"postgres","C:\dll\postgres\postgres\src\include\port\atomics.h",245 "pg_atomic_sub_fetch_u32",0.0070205,0.0070205,0.00211657,0.00211657,"postgres","C:\dll\postgres\postgres\src\include\port\atomics.h",402 "LWLockAcquire",0.0059813,0.0251271,0.00180327,0.00757542,"postgres","C:\dll\postgres\postgres\src\backend\storage\lmgr\lwlock.c",1200 "LWLockRelease",0.0049982,0.0120187,0.00150688,0.00362345,"postgres","C:\dll\postgres\postgres\src\backend\storage\lmgr\lwlock.c",1836 "LWLockReleaseAll",0.0664275,0.0664275,0.0200268,0.0200268,"postgres","C:\dll\postgres\postgres\src\backend\storage\lmgr\lwlock.c",1903 "LWLockAttemptLock",0.0121628,0.0191458,0.00366689,0.00577216,"postgres","C:\dll\postgres\postgres\src\backend\storage\lmgr\lwlock.c",818 "CheckForSerializableConflictOutNeeded",0,0.0089684,0,0.00270383,"postgres","C:\dll\postgres\postgres\src\backend\storage\lmgr\predicate.c",4091 "SerializationNeededForRead",0.0089684,0.0089684,0.00270383,0.00270383,"postgres","C:\dll\postgres\postgres\src\backend\storage\lmgr\predicate.c",518 "LockErrorCleanup",0.121878,0.206847,0.0367442,0.0623612,"postgres","C:\dll\postgres\postgres\src\backend\storage\lmgr\proc.c",717 "ItemPointerEquals",0.0771353,0.0771353,0.0232551,0.0232551,"postgres","C:\dll\postgres\postgres\src\backend\storage\page\itemptr.c",30 "CreateDestReceiver",0.12859,0.12859,0.0387679,0.0387679,"postgres","C:\dll\postgres\postgres\src\backend\tcop\dest.c",114 "donothingCleanup",0.0049869,0.0049869,0.00150347,0.00150347,"postgres","C:\dll\postgres\postgres\src\backend\tcop\dest.c",64 "check_stack_depth",0.174074,0.488894,0.0524806,0.147394,"postgres","C:\dll\postgres\postgres\src\backend\tcop\postgres.c",3470 "stack_is_too_deep",0.31482,0.31482,0.0949132,0.0949132,"postgres","C:\dll\postgres\postgres\src\backend\tcop\postgres.c",3484 "PostgresMain",0,110.564,0,33.3334,"postgres","C:\dll\postgres\postgres\src\backend\tcop\postgres.c",4420 "SocketBackend",0,7.50321,0,2.2621,"postgres","C:\dll\postgres\postgres\src\backend\tcop\postgres.c",353 "ReadCommand",0,7.50321,0,2.2621,"postgres","C:\dll\postgres\postgres\src\backend\tcop\postgres.c",476 "exec_simple_query",0,103.061,0,31.0713,"postgres","C:\dll\postgres\postgres\src\backend\tcop\postgres.c",1222 "CreateQueryDesc",0.0708039,0.650151,0.0213463,0.19601,"postgres","C:\dll\postgres\postgres\src\backend\tcop\pquery.c",75 "PortalRun",0,103.061,0,31.0713,"postgres","C:\dll\postgres\postgres\src\backend\tcop\pquery.c",763 "PlannedStmtRequiresSnapshot",0.0301897,0.0301897,0.00910172,0.00910172,"postgres","C:\dll\postgres\postgres\src\backend\tcop\pquery.c",1700 "EnsurePortalSnapshotExists",0.0048509,0.0274199,0.00146247,0.00826667,"postgres","C:\dll\postgres\postgres\src\backend\tcop\pquery.c",1748 "FillPortalStore",0,103.061,0,31.0713,"postgres","C:\dll\postgres\postgres\src\backend\tcop\pquery.c",1028 "PortalRunUtility",0,103.061,0,31.0713,"postgres","C:\dll\postgres\postgres\src\backend\tcop\pquery.c",1157 "ProcessUtility",0,103.061,0,31.0713,"postgres","C:\dll\postgres\postgres\src\backend\tcop\utility.c",530 "standard_ProcessUtility",0,103.061,0,31.0713,"postgres","C:\dll\postgres\postgres\src\backend\tcop\utility.c",846 "CommandIsReadOnly",0.0611946,0.0611946,0.0184492,0.0184492,"postgres","C:\dll\postgres\postgres\src\backend\tcop\utility.c",101 "pgstat_progress_end_command",0.0512112,0.0512112,0.0154394,0.0154394,"postgres","C:\dll\postgres\postgres\src\backend\utils\activity\backend_progress.c",100 "pgstat_report_query_id",0.285059,0.285059,0.0859408,0.0859408,"postgres","C:\dll\postgres\postgres\src\backend\utils\activity\backend_status.c",632 "datumCopy",0.0049713,0.0049713,0.00149877,0.00149877,"postgres","C:\dll\postgres\postgres\src\backend\utils\adt\datum.c",132 "datumTransfer",0,0.0049713,0,0.00149877,"postgres","C:\dll\postgres\postgres\src\backend\utils\adt\datum.c",199 "MakeExpandedObjectReadOnlyInternal",0.107547,0.107547,0.0324237,0.0324237,"postgres","C:\dll\postgres\postgres\src\backend\utils\adt\expandeddatum.c",96 "float4in",0.253525,37.0565,0.0764337,11.1719,"postgres","C:\dll\postgres\postgres\src\backend\utils\adt\float.c",163 "namestrcpy",0.0263877,0.280554,0.00795547,0.0845826,"postgres","C:\dll\postgres\postgres\src\backend\utils\adt\name.c",234 "varcharout",0.0276171,0.351867,0.00832612,0.106082,"postgres","C:\dll\postgres\postgres\src\backend\utils\adt\varchar.c",511 "cstring_to_text",0.0972837,0.811239,0.0293295,0.244576,"postgres","C:\dll\postgres\postgres\src\backend\utils\adt\varlena.c",190 "cstring_to_text_with_len",0.0756325,0.608452,0.022802,0.183439,"postgres","C:\dll\postgres\postgres\src\backend\utils\adt\varlena.c",202 "text_to_cstring",0.166469,0.32425,0.0501878,0.0977561,"postgres","C:\dll\postgres\postgres\src\backend\utils\adt\varlena.c",225 "murmurhash32",0.328954,0.328954,0.0991745,0.0991745,"postgres","C:\dll\postgres\postgres\src\include\common\hashfn.h",93 "dlist_move_head",0.04279,0.04279,0.0129005,0.0129005,"postgres","C:\dll\postgres\postgres\src\include\lib\ilist.h",386 "SearchCatCache1",0.165407,2.67556,0.0498675,0.806639,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\catcache.c",1168 "ReleaseCatCache",0.138292,0.389929,0.0416928,0.117557,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\catcache.c",1443 "SearchCatCacheInternal",1.23933,2.51015,0.373639,0.756771,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\catcache.c",1206 "CatalogCacheComputeHashValue",0.132848,0.510691,0.0400516,0.153965,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\catcache.c",272 "CatalogCacheCompareTuple",0.0748022,0.104416,0.0225517,0.0314798,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\catcache.c",377 "int4eqfast",0.029614,0.029614,0.00892815,0.00892815,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\catcache.c",160 "int4hashfast",0.0488887,0.377843,0.0147392,0.113914,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\catcache.c",166 "AtEOSubXact_Inval",0.0862065,0.0862065,0.0259899,0.0259899,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\inval.c",1065 "get_typlen",0.0238921,0.398268,0.00720309,0.120071,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\lsyscache.c",2148 "get_typlenbyval",0,0.0073201,0,0.00220689,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\lsyscache.c",2203 "getTypeIOParam",0.0587891,0.0587891,0.017724,0.017724,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\lsyscache.c",2251 "getTypeInputInfo",0.0396727,0.474415,0.0119607,0.143029,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\lsyscache.c",2822 "getTypeOutputInfo",0.12305,0.78593,0.0370976,0.236945,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\lsyscache.c",2855 "GetCachedPlan",0.156977,1.57547,0.0473262,0.474978,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\plancache.c",1143 "ReleaseCachedPlan",0.135675,0.313502,0.0409038,0.0945159,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\plancache.c",1265 "RevalidateCachedQuery",0.240057,0.638144,0.0723734,0.19239,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\plancache.c",557 "CheckCachedPlan",0.0607734,0.261913,0.0183222,0.0789626,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\plancache.c",797 "choose_custom_plan",0.0844272,0.0844272,0.0254535,0.0254535,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\plancache.c",1020 "AcquireExecutorLocks",0.20114,0.20114,0.0606404,0.0606404,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\plancache.c",1747 "AcquirePlannerLocks",0.103413,0.139421,0.0311775,0.0420332,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\plancache.c",1799 "ScanQueryForLocks",0.0360075,0.0360075,0.0108557,0.0108557,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\plancache.c",1833 "AtEOSubXact_RelationCache",0.120953,0.120953,0.0364654,0.0364654,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\relcache.c",3225 "SearchSysCache1",0.181529,2.85709,0.0547281,0.861367,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\syscache.c",1129 "ReleaseSysCache",0.131274,0.521202,0.0395769,0.157134,"postgres","C:\dll\postgres\postgres\src\backend\utils\cache\syscache.c",1176 "message_level_is_interesting",0.0681735,0.288378,0.0205532,0.0869414,"postgres","C:\dll\postgres\postgres\src\backend\utils\error\elog.c",271 "errstart",0.86892,1.38315,0.261966,0.416998,"postgres","C:\dll\postgres\postgres\src\backend\utils\error\elog.c",341 "errfinish",0.19656,25.4672,0.0592598,7.67795,"postgres","C:\dll\postgres\postgres\src\backend\utils\error\elog.c",514 "errcode",0.0319893,0.0319893,0.00964427,0.00964427,"postgres","C:\dll\postgres\postgres\src\backend\utils\error\elog.c",700 "errmsg",0.0704505,3.07587,0.0212397,0.927327,"postgres","C:\dll\postgres\postgres\src\backend\utils\error\elog.c",910 "set_errcontext_domain",0.237289,0.237289,0.0715389,0.0715389,"postgres","C:\dll\postgres\postgres\src\backend\utils\error\elog.c",1231 "errcontext_msg",0.169824,5.95758,0.0511992,1.79611,"postgres","C:\dll\postgres\postgres\src\backend\utils\error\elog.c",1205 "geterrposition",0.0734206,0.0734206,0.0221351,0.0221351,"postgres","C:\dll\postgres\postgres\src\backend\utils\error\elog.c",1419 "CopyErrorData",0.250889,1.89804,0.0756392,0.572228,"postgres","C:\dll\postgres\postgres\src\backend\utils\error\elog.c",1561 "FlushErrorState",0.0759111,0.739594,0.022886,0.222976,"postgres","C:\dll\postgres\postgres\src\backend\utils\error\elog.c",1655 "pg_re_throw",0.0119205,18.1245,0.00359384,5.46426,"postgres","C:\dll\postgres\postgres\src\backend\utils\error\elog.c",1802 "unpack_sql_state",0.119036,0.119036,0.0358876,0.0358876,"postgres","C:\dll\postgres\postgres\src\backend\utils\error\elog.c",2989 "in_error_recursion_trouble",0.0268219,0.0268219,0.00808638,0.00808638,"postgres","C:\dll\postgres\postgres\src\backend\utils\error\elog.c",292 "is_log_level_output",0.073421,0.073421,0.0221353,0.0221353,"postgres","C:\dll\postgres\postgres\src\backend\utils\error\elog.c",200 "should_output_to_server",0.0539226,0.127344,0.0162568,0.0383921,"postgres","C:\dll\postgres\postgres\src\backend\utils\error\elog.c",235 "should_output_to_client",0.15613,0.15613,0.0470708,0.0470708,"postgres","C:\dll\postgres\postgres\src\backend\utils\error\elog.c",243 "matches_backtrace_functions",0.01197,0.01197,0.00360877,0.00360877,"postgres","C:\dll\postgres\postgres\src\backend\utils\error\elog.c",487 "fmgr_info",0.0410852,0.376513,0.0123865,0.113513,"postgres","C:\dll\postgres\postgres\src\backend\utils\fmgr\fmgr.c",127 "pg_detoast_datum_packed",0.04648,0.04648,0.014013,0.014013,"postgres","C:\dll\postgres\postgres\src\backend\utils\fmgr\fmgr.c",1755 "fmgr_info_cxt_security",0.245717,0.335428,0.0740798,0.101126,"postgres","C:\dll\postgres\postgres\src\backend\utils\fmgr\fmgr.c",148 "fmgr_isbuiltin",0.0897104,0.0897104,0.0270463,0.0270463,"postgres","C:\dll\postgres\postgres\src\backend\utils\fmgr\fmgr.c",80 "get_hash_value",0,0.0112871,0,0.00340288,"postgres","C:\dll\postgres\postgres\src\backend\utils\hash\dynahash.c",911 "hash_search_with_hash_value",0.0069786,0.0129528,0.00210394,0.00390506,"postgres","C:\dll\postgres\postgres\src\backend\utils\hash\dynahash.c",1033 "hash_seq_init",0.111834,0.197828,0.0337163,0.0596421,"postgres","C:\dll\postgres\postgres\src\backend\utils\hash\dynahash.c",1427 "hash_seq_search",0.880737,0.959222,0.265528,0.28919,"postgres","C:\dll\postgres\postgres\src\backend\utils\hash\dynahash.c",1448 "hash_seq_term",0.0350853,0.0784855,0.0105777,0.0236621,"postgres","C:\dll\postgres\postgres\src\backend\utils\hash\dynahash.c",1513 "register_seq_scan",0.0780091,0.085994,0.0235185,0.0259258,"postgres","C:\dll\postgres\postgres\src\backend\utils\hash\dynahash.c",1837 "deregister_seq_scan",0.0434002,0.0434002,0.0130845,0.0130845,"postgres","C:\dll\postgres\postgres\src\backend\utils\hash\dynahash.c",1849 "GetUserId",0.0292867,0.0292867,0.00882948,0.00882948,"postgres","C:\dll\postgres\postgres\src\backend\utils\init\miscinit.c",496 "GetUserIdAndSecContext",0.0230096,0.0230096,0.00693703,0.00693703,"postgres","C:\dll\postgres\postgres\src\backend\utils\init\miscinit.c",601 "SetUserIdAndSecContext",0.0049881,0.0049881,0.00150383,0.00150383,"postgres","C:\dll\postgres\postgres\src\backend\utils\init\miscinit.c",610 "NewGUCNestLevel",0.0116605,0.0116605,0.00351546,0.00351546,"postgres","C:\dll\postgres\postgres\src\backend\utils\misc\guc.c",6205 "AtEOXact_GUC",0.049012,0.049012,0.0147763,0.0147763,"postgres","C:\dll\postgres\postgres\src\backend\utils\misc\guc.c",6219 "reschedule_timeouts",0.0569222,0.0569222,0.0171611,0.0171611,"postgres","C:\dll\postgres\postgres\src\backend\utils\misc\timeout.c",505 "AllocSetContextCreateInternal",0.601598,1.15474,0.181372,0.348136,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\aset.c",384 "AllocSetAlloc",3.5047,5.1944,1.05661,1.56603,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\aset.c",722 "AllocSetFree",0.803786,1.15289,0.242329,0.347577,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\aset.c",994 "AllocSetReset",2.54044,2.54044,0.765903,0.765903,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\aset.c",560 "AllocSetDelete",0.725873,2.22731,0.218839,0.671498,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\aset.c",628 "AllocSetFreeIndex",2.0388,2.0388,0.614666,0.614666,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\aset.c",310 "MemoryContextAlloc",0.348947,1.62718,0.105202,0.49057,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\mcxt.c",864 "MemoryContextAllocZero",2.22986,2.37478,0.672268,0.715958,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\mcxt.c",907 "MemoryContextAllocZeroAligned",3.06536,3.69995,0.924156,1.11548,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\mcxt.c",945 "palloc",0.662006,3.11131,0.199584,0.938012,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\mcxt.c",1063 "palloc0",1.13163,1.81897,0.341167,0.548391,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\mcxt.c",1094 "pfree",0.408379,1.81407,0.12312,0.546914,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\mcxt.c",1170 "MemoryContextStrdup",0.153429,2.1402,0.0462563,0.645237,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\mcxt.c",1287 "pstrdup",0.0430776,2.18328,0.0129872,0.658225,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\mcxt.c",1300 "MemoryContextReset",0.556388,3.22396,0.167742,0.971973,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\mcxt.c",144 "MemoryContextDelete",0.484365,3.33325,0.146028,1.00492,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\mcxt.c",219 "MemoryContextResetOnly",0.115238,2.85766,0.0347423,0.861538,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\mcxt.c",167 "MemoryContextDeleteChildren",0.123878,1.46699,0.0373471,0.442273,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\mcxt.c",264 "MemoryContextSetParent",0.358527,0.358527,0.10809,0.10809,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\mcxt.c",362 "MemoryContextGetParent",0.0979149,0.0979149,0.0295198,0.0295198,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\mcxt.c",447 "GetMemoryChunkContext",0.252805,0.252805,0.0762167,0.0762167,"postgres","C:\dll\postgres\postgres\src\include\utils\memutils.h",115 "MemoryContextCreate",0.553142,0.553142,0.166764,0.166764,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\mcxt.c",820 "MemoryContextCallResetCallbacks",0.40513,0.40513,0.12214,0.12214,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\mcxt.c",310 "AtSubAbort_Portals",0.0900189,0.835797,0.0271393,0.25198,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\portalmem.c",983 "AtSubCleanup_Portals",0.0291384,0.440411,0.00878477,0.132777,"postgres","C:\dll\postgres\postgres\src\backend\utils\mmgr\portalmem.c",1093 "ResourceOwnerCreate",0.157809,2.10306,0.047577,0.634038,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",429 "ResourceOwnerRelease",0.0461913,1.61734,0.0139259,0.487604,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",490 "ResourceOwnerDelete",0.107338,0.593531,0.0323607,0.17894,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",738 "ResourceOwnerNewParent",0.0824136,0.0824136,0.0248464,0.0248464,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",803 "ResourceOwnerForgetBuffer",0,0.0069821,0,0.00210499,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",970 "ResourceOwnerEnlargeCatCacheRefs",0.0270649,0.391621,0.00815964,0.118068,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",1036 "ResourceOwnerRememberCatCacheRef",0.0219004,0.166461,0.00660262,0.0501854,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",1047 "ResourceOwnerForgetCatCacheRef",0.0300474,0.251637,0.00905881,0.0758644,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",1056 "ResourceOwnerEnlargePlanCacheRefs",0.0139324,0.408087,0.0042004,0.123032,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",1151 "ResourceOwnerRememberPlanCacheRef",0.0059791,0.0259184,0.0018026,0.00781399,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",1162 "ResourceOwnerForgetPlanCacheRef",0.119887,0.177827,0.036144,0.0536121,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",1171 "ResourceOwnerEnlargeSnapshots",0.0120025,0.307422,0.00361856,0.0926828,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",1242 "ResourceOwnerRememberSnapshot",0,0.0664396,0,0.0200305,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",1254 "ResourceOwnerForgetSnapshot",0.050212,0.143643,0.0151381,0.043306,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",1261 "ResourceArrayInit",0.183835,0.183835,0.0554232,0.0554232,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",196 "ResourceArrayEnlarge",0.705924,1.05413,0.212825,0.317803,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",215 "ResourceArrayAdd",0.23094,0.23094,0.0696247,0.0696247,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",270 "ResourceArrayRemove",0.379943,0.379943,0.114547,0.114547,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",308 "ResourceArrayGetAny",0.380213,0.380213,0.114628,0.114628,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",377 "ResourceArrayFree",0.0398371,0.290745,0.0120103,0.0876552,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",409 "ResourceOwnerReleaseInternal",0.402167,1.57115,0.121247,0.473678,"postgres","C:\dll\postgres\postgres\src\backend\utils\resowner\resowner.c",500 "GetActiveSnapshot",0.0098911,0.0098911,0.00298201,0.00298201,"postgres","C:\dll\postgres\postgres\src\backend\utils\time\snapmgr.c",787 "ActiveSnapshotSet",0.022569,0.022569,0.0068042,0.0068042,"postgres","C:\dll\postgres\postgres\src\backend\utils\time\snapmgr.c",800 "RegisterSnapshot",0.0420857,0.51744,0.0126882,0.156,"postgres","C:\dll\postgres\postgres\src\backend\utils\time\snapmgr.c",811 "UnregisterSnapshot",0.054391,0.336927,0.016398,0.101578,"postgres","C:\dll\postgres\postgres\src\backend\utils\time\snapmgr.c",853 "RegisterSnapshotOnOwner",0.101493,0.475354,0.0305985,0.143312,"postgres","C:\dll\postgres\postgres\src\backend\utils\time\snapmgr.c",824 "UnregisterSnapshotFromOwner",0.138894,0.282536,0.0418742,0.0851802,"postgres","C:\dll\postgres\postgres\src\backend\utils\time\snapmgr.c",866 "AtSubAbort_Snapshot",0.0634953,0.080443,0.0191428,0.0242523,"postgres","C:\dll\postgres\postgres\src\backend\utils\time\snapmgr.c",971 "SnapshotResetXmin",0.0169477,0.0169477,0.00510946,0.00510946,"postgres","C:\dll\postgres\postgres\src\backend\utils\time\snapmgr.c",929 "hash_bytes",0.0112871,0.0112871,0.00340288,0.00340288,"postgres","C:\dll\postgres\postgres\src\common\hashfn.c",216 "tag_hash",0,0.0112871,0,0.00340288,"postgres","C:\dll\postgres\postgres\src\common\hashfn.c",680 "pvsnprintf",0.172077,4.97434,0.0518784,1.49968,"postgres","C:\dll\postgres\postgres\src\common\psprintf.c",107 "initStringInfo",0.068668,0.615484,0.0207023,0.185559,"postgres","C:\dll\postgres\postgres\src\common\stringinfo.c",60 "resetStringInfo",0.0649148,0.0649148,0.0195708,0.0195708,"postgres","C:\dll\postgres\postgres\src\common\stringinfo.c",77 "appendStringInfoVA",0.122427,5.09677,0.0369099,1.53659,"postgres","C:\dll\postgres\postgres\src\common\stringinfo.c",134 "appendStringInfoString",0.0278531,0.278728,0.00839727,0.084032,"postgres","C:\dll\postgres\postgres\src\common\stringinfo.c",177 "appendStringInfoChar",0.0888671,0.0888671,0.026792,0.026792,"postgres","C:\dll\postgres\postgres\src\common\stringinfo.c",189 "appendBinaryStringInfo",0.100287,0.179363,0.0302349,0.0540751,"postgres","C:\dll\postgres\postgres\src\common\stringinfo.c",228 "enlargeStringInfo",0.0339622,0.0339622,0.0102391,0.0102391,"postgres","C:\dll\postgres\postgres\src\common\stringinfo.c",284 "pg_strncasecmp",0.248437,0.248437,0.0748998,0.0748998,"postgres","C:\dll\postgres\postgres\src\port\pgstrcasecmp.c",70 "pg_vsnprintf",0.284625,4.80226,0.0858098,1.44781,"postgres","C:\dll\postgres\postgres\src\port\snprintf.c",175 "dopr",0.710368,4.51764,0.214165,1.362,"postgres","C:\dll\postgres\postgres\src\port\snprintf.c",378 "fmtint",0.254148,0.421812,0.0766216,0.12717,"postgres","C:\dll\postgres\postgres\src\port\snprintf.c",1017 "dostr",0.483113,0.865468,0.145651,0.260925,"postgres","C:\dll\postgres\postgres\src\port\snprintf.c",1358 "dopr_outch",0.0898488,0.0898488,0.027088,0.027088,"postgres","C:\dll\postgres\postgres\src\port\snprintf.c",1395 "adjust_sign",0.0059816,0.0059816,0.00180336,0.00180336,"postgres","C:\dll\postgres\postgres\src\port\snprintf.c",1456 "compute_padlen",0.0131527,0.0131527,0.00396533,0.00396533,"postgres","C:\dll\postgres\postgres\src\port\snprintf.c",1468 "leading_pad",0.0242529,0.0242529,0.00731187,0.00731187,"postgres","C:\dll\postgres\postgres\src\port\snprintf.c",1476 "trailing_pad",0.041403,0.041403,0.0124823,0.0124823,"postgres","C:\dll\postgres\postgres\src\port\snprintf.c",1512 "strchrnul",0.993648,0.993648,0.299569,0.299569,"postgres","C:\dll\postgres\postgres\src\port\snprintf.c",351 "__GSHandlerCheck",0.0065405,0.0485968,0.00197186,0.0146512,"postgres","d:\a01\_work\2\s\src\vctools\crt\vcstartup\src\gs\amd64\gshandler.cpp",74 "__GSHandlerCheckCommon",0.0360669,0.0420563,0.0108736,0.0126793,"postgres","d:\a01\_work\2\s\src\vctools\crt\vcstartup\src\gs\amd64\gshandler.cpp",142 "__security_check_cookie",0.158916,0.158916,0.0479105,0.0479105,"postgres","d:\a01\_work\2\s\src\vctools\crt\vcstartup\src\gs\amd64\amdsecgs.asm",45 "__scrt_common_main",0,110.564,0,33.3334,"postgres","d:\a01\_work\2\s\src\vctools\crt\vcstartup\src\startup\exe_common.inl",331 "__scrt_common_main_seh",0,110.564,0,33.3334,"postgres","d:\a01\_work\2\s\src\vctools\crt\vcstartup\src\startup\exe_common.inl",288 "invoke_main",0,110.564,0,33.3334,"postgres","d:\a01\_work\2\s\src\vctools\crt\vcstartup\src\startup\exe_common.inl",79 "mainCRTStartup",0,110.564,0,33.3334,"postgres","d:\a01\_work\2\s\src\vctools\crt\vcstartup\src\startup\exe_main.cpp",17 "memmove",0.010717,0.010717,0.00323101,0.00323101,"postgres","[unknown]",0 "memcpy",0.0411522,0.0411522,0.0124067,0.0124067,"postgres","[unknown]",0 "strrchr",0.0049975,0.0049975,0.00150667,0.00150667,"postgres","[unknown]",0 "strlen",0.013033,0.013033,0.00392924,0.00392924,"postgres","[unknown]",0 "cgetws",0.214744,1.02872,0.0647419,0.310143,"ucrtbased","[unknown]",0 "cputws",0.729626,0.922339,0.219971,0.278071,"ucrtbased","[unknown]",0 "_conio_common_vcwscanf",0.171283,0.964786,0.0516391,0.290868,"ucrtbased","[unknown]",0 "putwch_nolock",0.334184,1.13105,0.100751,0.340994,"ucrtbased","[unknown]",0 "o_wmemmove_s",0.872363,1.98789,0.263004,0.599319,"ucrtbased","[unknown]",0 "mbtowc",0.10653,3.00278,0.0321172,0.905292,"ucrtbased","[unknown]",0 "strtof",0.0676344,3.07042,0.0203907,0.925682,"ucrtbased","[unknown]",0 "ultow_s",0.318259,2.51371,0.09595,0.757843,"ucrtbased","[unknown]",0 "isspace",0.118587,2.63229,0.0357521,0.793595,"ucrtbased","[unknown]",0 "msize",1.26056,1.7656,0.38004,0.5323,"ucrtbased","[unknown]",0 "unlock_locales",0.851532,5.73976,0.256724,1.73045,"ucrtbased","[unknown]",0 "set_app_type",2.28902,4.65327,0.690104,1.40289,"ucrtbased","[unknown]",0 "localeconv",0.0730447,0.811008,0.0220218,0.244506,"ucrtbased","[unknown]",0 "errno",0.145606,3.81812,0.043898,1.1511,"ucrtbased","[unknown]",0 "strlen",0.944145,0.944145,0.284645,0.284645,"ucrtbased","[unknown]",0 "strncpy",0.254166,0.254166,0.0766271,0.0766271,"ucrtbased","[unknown]",0 "fegetround",0,0.0446999,0,0.0134763,"ucrtbased","[unknown]",0 "fesetenv",0.0129682,0.0129682,0.00390971,0.00390971,"ucrtbased","[unknown]",0 "truncl",0.0317317,0.0446999,0.0095666,0.0134763,"ucrtbased","[unknown]",0 "local_unwind",0.0394629,0.0394629,0.0118974,0.0118974,"ucrtbased","[unknown]",0 "o_memset",0.0525717,0.0525717,0.0158495,0.0158495,"ucrtbased","[unknown]",0 "memmove",0.0109687,0.0109687,0.00330689,0.00330689,"ucrtbased","[unknown]",0 "_report_gsfailure",0.0669196,0.0669196,0.0201752,0.0201752,"ucrtbased","[unknown]",0 "_intrinsic_setjmpex",0.111154,0.111154,0.033511,0.033511,"ucrtbased","[unknown]",0 "memcmp",0.0059742,0.0059742,0.00180113,0.00180113,"VCRUNTIME140D","[unknown]",0 "memcpy",1.98161,1.98161,0.597424,0.597424,"VCRUNTIME140D","[unknown]",0 "memset",0.184818,0.184818,0.0557196,0.0557196,"VCRUNTIME140D","[unknown]",0 "longjmp",0.0245448,18.1126,0.00739987,5.46067,"VCRUNTIME140D","[unknown]",0 "strrchr",0.507827,0.507827,0.153102,0.153102,"VCRUNTIME140D","[unknown]",0 "_report_gsfailure",0.0483124,17.9033,0.0145654,5.39755,"VCRUNTIME140D","[unknown]",0 "_intrinsic_setjmp",0.143234,0.143234,0.0431828,0.0431828,"VCRUNTIME140D","[unknown]",0 "WaitForSingleObjectEx",110.564,110.564,33.3333,33.3333,"KERNELBASE","[unknown]",0 "GetLastError",0.212332,0.212332,0.0640147,0.0640147,"KERNELBASE","[unknown]",0 "FlsGetValue",1.0534,1.0534,0.317583,0.317583,"KERNELBASE","[unknown]",0 "WaitForMultipleObjects",7.50321,7.50321,2.2621,2.2621,"KERNELBASE","[unknown]",0 "WaitForMultipleObjectsEx",0,0,0,0,"KERNELBASE","[unknown]",0 "ResetEvent",4.64257,4.64257,1.39966,1.39966,"KERNELBASE","[unknown]",0 "ConnectNamedPipe",110.564,110.564,33.3333,33.3333,"KERNELBASE","[unknown]",0 "QueryPerformanceCounter",0.0642238,0.0642238,0.0193625,0.0193625,"KERNEL32","[unknown]",0 "BaseThreadInitThunk",0,331.692,0,100,"KERNEL32","[unknown]",0 "ResetEvent",0.024084,0.024084,0.00726094,0.00726094,"KERNEL32","[unknown]",0 "RtlUnwind",0.0189477,0.0189477,0.00571243,0.00571243,"KERNEL32","[unknown]",0 "RtlLeaveCriticalSection",0.0595915,0.0595915,0.0179659,0.0179659,"ntdll","[unknown]",0 "RtlEnterCriticalSection",0.0837919,0.0837919,0.0252619,0.0252619,"ntdll","[unknown]",0 "RtlUnwindEx",0,0.148105,0,0.0446514,"ntdll","[unknown]",0 "RtlVirtualUnwind",0,0,0,0,"ntdll","[unknown]",0 "RtlLookupFunctionEntry",0,0,0,0,"ntdll","[unknown]",0 "LdrControlFlowGuardEnforced",0,0,0,0,"ntdll","[unknown]",0 "RtlQueryPerformanceCounter",0.354329,0.354329,0.106825,0.106825,"ntdll","[unknown]",0 "RtlRestoreLastWin32Error",0.365538,0.365538,0.110204,0.110204,"ntdll","[unknown]",0 "RtlUnwind",17.6879,17.836,5.33262,5.37727,"ntdll","[unknown]",0 "RtlInitializeExtendedContext",0,0,0,0,"ntdll","[unknown]",0 "RtlGetExtendedContextLength2",0,0,0,0,"ntdll","[unknown]",0 "RtlWow64GetCpuAreaInfo",0,0,0,0,"ntdll","[unknown]",0 "RtlInitializeExtendedContext2",0,0,0,0,"ntdll","[unknown]",0 "RtlFlsGetValue",0,0,0,0,"ntdll","[unknown]",0 "RtlUserThreadStart",0,331.692,0,100,"ntdll","[unknown]",0 "RtlRestoreContext",0,0,0,0,"ntdll","[unknown]",0 "RtlGuardCheckLongJumpTarget",0,0,0,0,"ntdll","[unknown]",0 "RtlDeleteAce",0,0,0,0,"ntdll","[unknown]",0 "RtlIpv4AddressToStringA",0,0,0,0,"ntdll","[unknown]",0 "RtlRetrieveNtUserPfn",0,0,0,0,"ntdll","[unknown]",0 "wcstombs",0,0,0,0,"ntdll","[unknown]",0 "NtWaitForSingleObject",0,0,0,0,"ntdll","[unknown]",0 "ZwFsControlFile",0,0,0,0,"ntdll","[unknown]",0 "NtClearEvent",0,0,0,0,"ntdll","[unknown]",0 "ZwWaitForMultipleObjects",0,0,0,0,"ntdll","[unknown]",0 "ZwContinueEx",0,0,0,0,"ntdll","[unknown]",0 "RtlCaptureContext2",0,0,0,0,"ntdll","[unknown]",0 "_chkstk",0,0.148105,0,0.0446514,"ntdll","[unknown]",0
Attachment:
postgres_single.png
Description: PNG image
Attachment:
postgres.png
Description: PNG image
