Flat profile: Each sample counts as 0.01 seconds. % cumulative self self total time seconds seconds calls s/call s/call name 10.65 0.80 0.80 50002910 0.00 0.00 AllocSetAlloc 8.66 1.45 0.65 10000000 0.00 0.00 slot_deform_tuple 7.86 2.04 0.59 40001617 0.00 0.00 AllocSetFree 7.46 2.60 0.56 9999999 0.00 0.00 add_abs 6.13 3.06 0.46 9999999 0.00 0.00 numeric_add 4.93 3.43 0.37 9999999 0.00 0.00 make_result 4.53 3.77 0.34 10000000 0.00 0.00 advance_transition_function 3.46 4.03 0.26 29999998 0.00 0.00 free_var 3.46 4.29 0.26 10000003 0.00 0.00 AllocSetReset 3.46 4.55 0.26 10000000 0.00 0.00 advance_aggregates 3.33 4.80 0.25 50002592 0.00 0.00 MemoryContextAlloc 3.20 5.04 0.24 10000001 0.00 0.00 heapgettup_pagemode 3.06 5.27 0.23 19999999 0.00 0.00 set_var_from_num 2.26 5.44 0.17 10000001 0.00 0.00 slot_getattr 2.13 5.60 0.16 40001616 0.00 0.00 pfree 2.13 5.76 0.16 10000003 0.00 0.00 ExecProcNode 2.13 5.92 0.16 10000001 0.00 0.00 ExecScan 1.73 6.05 0.13 10000103 0.00 0.00 heap_getnext 1.60 6.17 0.12 10000001 0.00 0.00 SeqNext 1.60 6.29 0.12 10000000 0.00 0.00 XidInSnapshot 1.60 6.41 0.12 9999999 0.00 0.00 add_var 1.46 6.52 0.11 19999999 0.00 0.00 alloc_var 1.46 6.63 0.11 10000001 0.00 0.00 datumGetSize 1.33 6.73 0.10 10000001 0.00 0.00 datumCopy 1.20 6.82 0.09 87860 0.00 0.00 heapgetpage 1.20 6.91 0.09 2 0.04 3.03 ExecAgg 0.93 6.98 0.07 10000000 0.00 0.00 ExecEvalVar 0.93 7.05 0.07 10000000 0.00 0.00 HeapTupleSatisfiesSnapshot 0.80 7.11 0.06 20000000 0.00 0.00 pg_detoast_datum 0.80 7.17 0.06 511486 0.00 0.00 LWLockRelease 0.80 7.23 0.06 511485 0.00 0.00 LWLockAcquire 0.67 7.28 0.05 10000001 0.00 0.00 ExecStoreTuple 0.40 7.31 0.03 10000009 0.00 0.00 TransactionIdPrecedes 0.40 7.34 0.03 10000001 0.00 0.00 MemoryContextReset 0.40 7.37 0.03 87761 0.00 0.00 StrategyGetBuffer 0.27 7.39 0.02 10000001 0.00 0.00 ExecSeqScan 0.27 7.41 0.02 9999999 0.00 0.00 strip_var 0.27 7.43 0.02 254355 0.00 0.00 hash_search_with_hash_value 0.13 7.44 0.01 176862 0.00 0.00 LockBuffer 0.13 7.45 0.01 175902 0.00 0.00 ResourceOwnerForgetBuffer 0.13 7.46 0.01 175901 0.00 0.00 UnpinBuffer 0.13 7.47 0.01 164908 0.00 0.00 hash_any 0.13 7.48 0.01 88213 0.00 0.00 BufTableLookup 0.13 7.49 0.01 88015 0.00 0.00 ReleaseBuffer 0.13 7.50 0.01 87761 0.00 0.00 TerminateBufferIO 0.13 7.51 0.01 __divdi3 0.00 7.51 0.00 175903 0.00 0.00 ResourceOwnerEnlargeBuffers 0.00 7.51 0.00 175902 0.00 0.00 ResourceOwnerRememberBuffer 0.00 7.51 0.00 164857 0.00 0.00 tag_hash 0.00 7.51 0.00 163576 0.00 0.00 get_hash_value 0.00 7.51 0.00 163174 0.00 0.00 BufTableHashCode 0.00 7.51 0.00 88214 0.00 0.00 ReleaseAndReadBuffer 0.00 7.51 0.00 88213 0.00 0.00 ReadBuffer 0.00 7.51 0.00 87802 0.00 0.00 FileSeek 0.00 7.51 0.00 87802 0.00 0.00 mdopen 0.00 7.51 0.00 87761 0.00 0.00 BufTableInsert 0.00 7.51 0.00 87761 0.00 0.00 FileAccess 0.00 7.51 0.00 87761 0.00 0.00 FileRead