Flat profile: Each sample counts as 0.01 seconds. no time accumulated % cumulative self self total time seconds seconds calls Ts/call Ts/call name 0.00 0.00 0.00 2056 0.00 0.00 LWLockAssign 0.00 0.00 0.00 2002 0.00 0.00 LWLockRelease 0.00 0.00 0.00 2000 0.00 0.00 LWLockAcquire 0.00 0.00 0.00 1161 0.00 0.00 PostmasterRandom 0.00 0.00 0.00 837 0.00 0.00 isblank 0.00 0.00 0.00 476 0.00 0.00 LockBuffer 0.00 0.00 0.00 464 0.00 0.00 CharRemap 0.00 0.00 0.00 319 0.00 0.00 AllocSetAlloc 0.00 0.00 0.00 319 0.00 0.00 MemoryContextAlloc 0.00 0.00 0.00 250 0.00 0.00 call_hash 0.00 0.00 0.00 250 0.00 0.00 hash_search 0.00 0.00 0.00 249 0.00 0.00 next_token 0.00 0.00 0.00 243 0.00 0.00 AllocSetFree 0.00 0.00 0.00 243 0.00 0.00 BasicOpenFile 0.00 0.00 0.00 243 0.00 0.00 pfree 0.00 0.00 0.00 239 0.00 0.00 XLogFlush 0.00 0.00 0.00 238 0.00 0.00 AddBufferToFreelist 0.00 0.00 0.00 238 0.00 0.00 PinBuffer 0.00 0.00 0.00 238 0.00 0.00 RelationNodeCacheGetRelation 0.00 0.00 0.00 238 0.00 0.00 StartBufferIO 0.00 0.00 0.00 238 0.00 0.00 TerminateBufferIO 0.00 0.00 0.00 238 0.00 0.00 UnpinBuffer 0.00 0.00 0.00 238 0.00 0.00 _mdfd_blind_getseg 0.00 0.00 0.00 238 0.00 0.00 mdblindwrt 0.00 0.00 0.00 238 0.00 0.00 relpath 0.00 0.00 0.00 238 0.00 0.00 smgrblindwrt 0.00 0.00 0.00 238 0.00 0.00 tag_hash 0.00 0.00 0.00 234 0.00 0.00 StreamClose 0.00 0.00 0.00 233 0.00 0.00 DLAddHead 0.00 0.00 0.00 233 0.00 0.00 DLNewElem 0.00 0.00 0.00 232 0.00 0.00 BackendStartup 0.00 0.00 0.00 232 0.00 0.00 ConnCreate 0.00 0.00 0.00 232 0.00 0.00 ConnFree 0.00 0.00 0.00 232 0.00 0.00 RandomSalt 0.00 0.00 0.00 232 0.00 0.00 StreamConnection 0.00 0.00 0.00 205 0.00 0.00 read_to_eol 0.00 0.00 0.00 187 0.00 0.00 GUC_yylex 0.00 0.00 0.00 135 0.00 0.00 pgstat_ispgstat 0.00 0.00 0.00 134 0.00 0.00 CleanupProc 0.00 0.00 0.00 134 0.00 0.00 DLFreeElem 0.00 0.00 0.00 134 0.00 0.00 DLRemove 0.00 0.00 0.00 133 0.00 0.00 pgstat_beterm 0.00 0.00 0.00 133 0.00 0.00 pgstat_send 0.00 0.00 0.00 59 0.00 0.00 ShmemAlloc 0.00 0.00 0.00 44 0.00 0.00 seg_alloc 0.00 0.00 0.00 36 0.00 0.00 my_log2 0.00 0.00 0.00 33 0.00 0.00 InternalIpcSemaphoreCreate 0.00 0.00 0.00 33 0.00 0.00 IpcSemaphoreCreate 0.00 0.00 0.00 33 0.00 0.00 IpcSemaphoreUnlock 0.00 0.00 0.00 28 0.00 0.00 DynaHashAlloc 0.00 0.00 0.00 24 0.00 0.00 pqsignal 0.00 0.00 0.00 19 0.00 0.00 newNode 0.00 0.00 0.00 16 0.00 0.00 lappend 0.00 0.00 0.00 16 0.00 0.00 lcons 0.00 0.00 0.00 16 0.00 0.00 nconc 0.00 0.00 0.00 14 0.00 0.00 AllocSetContextCreate 0.00 0.00 0.00 14 0.00 0.00 AllocSetInit 0.00 0.00 0.00 14 0.00 0.00 MemoryContextCreate 0.00 0.00 0.00 13 0.00 0.00 MemoryContextStrdup 0.00 0.00 0.00 12 0.00 0.00 ShmemInitStruct 0.00 0.00 0.00 12 0.00 0.00 string_hash 0.00 0.00 0.00 8 0.00 0.00 WriteCLOGPage 0.00 0.00 0.00 8 0.00 0.00 hash_create 0.00 0.00 0.00 8 0.00 0.00 hdefault 0.00 0.00 0.00 8 0.00 0.00 init_htab 0.00 0.00 0.00 7 0.00 0.00 AllocateFile 0.00 0.00 0.00 6 0.00 0.00 FreeFile 0.00 0.00 0.00 5 0.00 0.00 ShmemInitHash 0.00 0.00 0.00 5 0.00 0.00 hash_estimate_size 0.00 0.00 0.00 5 0.00 0.00 hash_select_dirsize 0.00 0.00 0.00 5 0.00 0.00 on_shmem_exit 0.00 0.00 0.00 4 0.00 0.00 SetConfigOption 0.00 0.00 0.00 4 0.00 0.00 find_option 0.00 0.00 0.00 4 0.00 0.00 on_proc_exit 0.00 0.00 0.00 4 0.00 0.00 set_config_option 0.00 0.00 0.00 3 0.00 0.00 GUC_yy_load_buffer_state 0.00 0.00 0.00 3 0.00 0.00 MemoryContextSwitchTo 0.00 0.00 0.00 3 0.00 0.00 NumLWLocks 0.00 0.00 0.00 3 0.00 0.00 SSDataBase 0.00 0.00 0.00 3 0.00 0.00 lconsi 0.00 0.00 0.00 3 0.00 0.00 parse_int 0.00 0.00 0.00 2 0.00 0.00 CreateLockFile 0.00 0.00 0.00 2 0.00 0.00 FindExec 0.00 0.00 0.00 2 0.00 0.00 GUC_yy_flex_alloc 0.00 0.00 0.00 2 0.00 0.00 GUC_yy_flush_buffer 0.00 0.00 0.00 2 0.00 0.00 GUC_yy_get_next_buffer 0.00 0.00 0.00 2 0.00 0.00 GUC_yy_init_buffer 0.00 0.00 0.00 2 0.00 0.00 IgnoreSystemIndexes 0.00 0.00 0.00 2 0.00 0.00 LWLockConditionalAcquire 0.00 0.00 0.00 2 0.00 0.00 LWLockShmemSize 0.00 0.00 0.00 2 0.00 0.00 SInvalShmemSize 0.00 0.00 0.00 2 0.00 0.00 StreamServerPort 0.00 0.00 0.00 2 0.00 0.00 ValidateBinary 0.00 0.00 0.00 2 0.00 0.00 ValidatePgVersion 0.00 0.00 0.00 2 0.00 0.00 XLOGPathInit 0.00 0.00 0.00 2 0.00 0.00 tokenize_file 0.00 0.00 0.00 1 0.00 0.00 AbortBufferIO 0.00 0.00 0.00 1 0.00 0.00 BaseInit 0.00 0.00 0.00 1 0.00 0.00 BootstrapMain 0.00 0.00 0.00 1 0.00 0.00 BufferShmemSize 0.00 0.00 0.00 1 0.00 0.00 BufferSync 0.00 0.00 0.00 1 0.00 0.00 CLOGPhysicalWritePage 0.00 0.00 0.00 1 0.00 0.00 CLOGShmemInit 0.00 0.00 0.00 1 0.00 0.00 CLOGShmemSize 0.00 0.00 0.00 1 0.00 0.00 CheckPointCLOG 0.00 0.00 0.00 1 0.00 0.00 ClearDateCache 0.00 0.00 0.00 1 0.00 0.00 ClosePostmasterPorts 0.00 0.00 0.00 1 0.00 0.00 CreateCacheMemoryContext 0.00 0.00 0.00 1 0.00 0.00 CreateCheckPoint 0.00 0.00 0.00 1 0.00 0.00 CreateDataDirLockFile 0.00 0.00 0.00 1 0.00 0.00 CreateDummyCaches 0.00 0.00 0.00 1 0.00 0.00 CreateLWLocks 0.00 0.00 0.00 1 0.00 0.00 CreateOptsFile 0.00 0.00 0.00 1 0.00 0.00 CreateSharedInvalidationState 0.00 0.00 0.00 1 0.00 0.00 CreateSharedMemoryAndSemaphores 0.00 0.00 0.00 1 0.00 0.00 CreateSocketLockFile 0.00 0.00 0.00 1 0.00 0.00 CreateSpinlocks 0.00 0.00 0.00 1 0.00 0.00 DLNewList 0.00 0.00 0.00 1 0.00 0.00 DebugFileOpen 0.00 0.00 0.00 1 0.00 0.00 DummyProcKill 0.00 0.00 0.00 1 0.00 0.00 EnableExceptionHandling 0.00 0.00 0.00 1 0.00 0.00 FlushBufferPool 0.00 0.00 0.00 1 0.00 0.00 FreeSpaceShmemSize 0.00 0.00 0.00 1 0.00 0.00 GUC_yy_create_buffer 0.00 0.00 0.00 1 0.00 0.00 GUC_yy_get_previous_state 0.00 0.00 0.00 1 0.00 0.00 GUC_yyrestart 0.00 0.00 0.00 1 0.00 0.00 GUC_yywrap 0.00 0.00 0.00 1 0.00 0.00 GetCurrentTransactionId 0.00 0.00 0.00 1 0.00 0.00 GetRedoRecPtr 0.00 0.00 0.00 1 0.00 0.00 GetUndoRecPtr 0.00 0.00 0.00 1 0.00 0.00 InitBufTable 0.00 0.00 0.00 1 0.00 0.00 InitBufferPool 0.00 0.00 0.00 1 0.00 0.00 InitBufferPoolAccess 0.00 0.00 0.00 1 0.00 0.00 InitCommunication 0.00 0.00 0.00 1 0.00 0.00 InitDummyProcess 0.00 0.00 0.00 1 0.00 0.00 InitFreeList 0.00 0.00 0.00 1 0.00 0.00 InitFreeSpaceMap 0.00 0.00 0.00 1 0.00 0.00 InitLocalBuffer 0.00 0.00 0.00 1 0.00 0.00 InitLockTable 0.00 0.00 0.00 1 0.00 0.00 InitLocks 0.00 0.00 0.00 1 0.00 0.00 InitProcGlobal 0.00 0.00 0.00 1 0.00 0.00 InitShmemAllocation 0.00 0.00 0.00 1 0.00 0.00 InitShmemIndex 0.00 0.00 0.00 1 0.00 0.00 InternalIpcMemoryCreate 0.00 0.00 0.00 1 0.00 0.00 IpcInitKeyAssignment 0.00 0.00 0.00 1 0.00 0.00 IpcMemoryCreate 0.00 0.00 0.00 1 0.00 0.00 LWLockReleaseAll 0.00 0.00 0.00 1 0.00 0.00 LockMethodInit 0.00 0.00 0.00 1 0.00 0.00 LockMethodTableInit 0.00 0.00 0.00 1 0.00 0.00 LockMethodTableRename 0.00 0.00 0.00 1 0.00 0.00 LockShmemSize 0.00 0.00 0.00 1 0.00 0.00 MemoryContextInit 0.00 0.00 0.00 1 0.00 0.00 PMSignalInit 0.00 0.00 0.00 1 0.00 0.00 PostmasterMain 0.00 0.00 0.00 1 0.00 0.00 PreallocXlogFiles 0.00 0.00 0.00 1 0.00 0.00 ProcessConfigFile 0.00 0.00 0.00 1 0.00 0.00 ReadControlFile 0.00 0.00 0.00 1 0.00 0.00 RecordSharedMemoryInLockFile 0.00 0.00 0.00 1 0.00 0.00 RemovePgTempFiles 0.00 0.00 0.00 1 0.00 0.00 ResetAllOptions 0.00 0.00 0.00 1 0.00 0.00 ResetBufferPool 0.00 0.00 0.00 1 0.00 0.00 ResetLocalBufferPool 0.00 0.00 0.00 1 0.00 0.00 SHMQueueElemInit 0.00 0.00 0.00 1 0.00 0.00 SHMQueueInit 0.00 0.00 0.00 1 0.00 0.00 SIBufferInit 0.00 0.00 0.00 1 0.00 0.00 ServerLoop 0.00 0.00 0.00 1 0.00 0.00 SetDataDir 0.00 0.00 0.00 1 0.00 0.00 SetRedoRecPtr 0.00 0.00 0.00 1 0.00 0.00 SetThisStartUpID 0.00 0.00 0.00 1 0.00 0.00 ShutdownBufferPoolAccess 0.00 0.00 0.00 1 0.00 0.00 TouchSocketLockFile 0.00 0.00 0.00 1 0.00 0.00 UnlockBuffers 0.00 0.00 0.00 1 0.00 0.00 UpdateControlFile 0.00 0.00 0.00 1 0.00 0.00 XLOGShmemInit 0.00 0.00 0.00 1 0.00 0.00 XLOGShmemSize 0.00 0.00 0.00 1 0.00 0.00 XLogFileInit 0.00 0.00 0.00 1 0.00 0.00 XLogFileOpen 0.00 0.00 0.00 1 0.00 0.00 XLogInsert 0.00 0.00 0.00 1 0.00 0.00 XLogWrite 0.00 0.00 0.00 1 0.00 0.00 ZeroProcSemaphore 0.00 0.00 0.00 1 0.00 0.00 assign_defaultxactisolevel 0.00 0.00 0.00 1 0.00 0.00 assign_xlog_sync_method 0.00 0.00 0.00 1 0.00 0.00 checkDataDir 0.00 0.00 0.00 1 0.00 0.00 crypt_getpwdfilename 0.00 0.00 0.00 1 0.00 0.00 crypt_openpwdfile 0.00 0.00 0.00 1 0.00 0.00 element_alloc 0.00 0.00 0.00 1 0.00 0.00 free_name_value_list 0.00 0.00 0.00 1 0.00 0.00 initMasks 0.00 0.00 0.00 1 0.00 0.00 init_ps_display 0.00 0.00 0.00 1 0.00 0.00 issue_xlog_fsync 0.00 0.00 0.00 1 0.00 0.00 load_hba 0.00 0.00 0.00 1 0.00 0.00 load_hba_and_ident 0.00 0.00 0.00 1 0.00 0.00 load_ident 0.00 0.00 0.00 1 0.00 0.00 load_password_cache 0.00 0.00 0.00 1 0.00 0.00 mdabort 0.00 0.00 0.00 1 0.00 0.00 mdinit 0.00 0.00 0.00 1 0.00 0.00 mdsync 0.00 0.00 0.00 1 0.00 0.00 on_exit_reset 0.00 0.00 0.00 1 0.00 0.00 parse_bool 0.00 0.00 0.00 1 0.00 0.00 pg_fdatasync 0.00 0.00 0.00 1 0.00 0.00 pg_fsync 0.00 0.00 0.00 1 0.00 0.00 pgstat_close_sockets 0.00 0.00 0.00 1 0.00 0.00 pgstat_init 0.00 0.00 0.00 1 0.00 0.00 pgstat_start 0.00 0.00 0.00 1 0.00 0.00 pqinitmask 0.00 0.00 0.00 1 0.00 0.00 proc_exit 0.00 0.00 0.00 1 0.00 0.00 reset_shared 0.00 0.00 0.00 1 0.00 0.00 save_ps_display_args 0.00 0.00 0.00 1 0.00 0.00 set_ps_display 0.00 0.00 0.00 1 0.00 0.00 shmem_exit 0.00 0.00 0.00 1 0.00 0.00 smgrabort 0.00 0.00 0.00 1 0.00 0.00 smgrinit 0.00 0.00 0.00 1 0.00 0.00 smgrshutdown 0.00 0.00 0.00 1 0.00 0.00 smgrsync % the percentage of the total running time of the time program used by this function. cumulative a running sum of the number of seconds accounted seconds for by this function and those listed above it. self the number of seconds accounted for by this seconds function alone. This is the major sort for this listing. calls the number of times this function was invoked, if this function is profiled, else blank. self the average number of milliseconds spent in this ms/call function per call, if this function is profiled, else blank. total the average number of milliseconds spent in this ms/call function and its descendents per call, if this function is profiled, else blank. name the name of the function. This is the minor sort for this listing. The index shows the location of the function in the gprof listing. If the index is in parenthesis it shows where it would appear in the gprof listing if it were to be printed. Call graph (explanation follows) granularity: each sample hit covers 4 byte(s) no time propagated index % time self children called name 0.00 0.00 8/2056 CLOGShmemInit [102] 0.00 0.00 2048/2056 InitBufferPool [131] [1] 0.0 0.00 0.00 2056 LWLockAssign [1] ----------------------------------------------- 0.00 0.00 1/2002 WriteCLOGPage [61] 0.00 0.00 1/2002 XLogInsert [177] 0.00 0.00 1/2002 InitBufferPool [131] 0.00 0.00 1/2002 InitShmemIndex [142] 0.00 0.00 1/2002 GetUndoRecPtr [129] 0.00 0.00 1/2002 LockMethodTableInit [148] 0.00 0.00 2/2002 CheckPointCLOG [104] 0.00 0.00 2/2002 XLogFlush [16] 0.00 0.00 5/2002 CreateCheckPoint [108] 0.00 0.00 11/2002 ShmemInitStruct [59] 0.00 0.00 238/2002 LockBuffer [6] 0.00 0.00 238/2002 TerminateBufferIO [21] 0.00 0.00 1500/2002 BufferSync [100] [2] 0.0 0.00 0.00 2002 LWLockRelease [2] ----------------------------------------------- 0.00 0.00 1/2000 CheckPointCLOG [104] 0.00 0.00 1/2000 XLogInsert [177] 0.00 0.00 1/2000 XLogFlush [16] 0.00 0.00 1/2000 InitBufferPool [131] 0.00 0.00 1/2000 GetUndoRecPtr [129] 0.00 0.00 1/2000 LockMethodTableInit [148] 0.00 0.00 2/2000 WriteCLOGPage [61] 0.00 0.00 4/2000 CreateCheckPoint [108] 0.00 0.00 12/2000 ShmemInitStruct [59] 0.00 0.00 238/2000 LockBuffer [6] 0.00 0.00 238/2000 StartBufferIO [20] 0.00 0.00 1500/2000 BufferSync [100] [3] 0.0 0.00 0.00 2000 LWLockAcquire [3] ----------------------------------------------- 0.00 0.00 1/1161 SSDataBase [78] 0.00 0.00 232/1161 BackendStartup [30] 0.00 0.00 928/1161 RandomSalt [33] [4] 0.0 0.00 0.00 1161 PostmasterRandom [4] ----------------------------------------------- 0.00 0.00 837/837 next_token [12] [5] 0.0 0.00 0.00 837 isblank [5] ----------------------------------------------- 0.00 0.00 476/476 FlushBufferPool [121] [6] 0.0 0.00 0.00 476 LockBuffer [6] 0.00 0.00 238/2002 LWLockRelease [2] 0.00 0.00 238/2000 LWLockAcquire [3] ----------------------------------------------- 0.00 0.00 464/464 ConnCreate [31] [7] 0.0 0.00 0.00 464 CharRemap [7] ----------------------------------------------- 0.00 0.00 319/319 MemoryContextAlloc [9] [8] 0.0 0.00 0.00 319 AllocSetAlloc [8] ----------------------------------------------- 0.00 0.00 1/319 crypt_getpwdfilename [183] 0.00 0.00 1/319 load_ident [192] 0.00 0.00 1/319 CreateOptsFile [112] 0.00 0.00 1/319 mdinit [195] 0.00 0.00 2/319 load_hba [190] 0.00 0.00 2/319 LockMethodTableInit [148] 0.00 0.00 13/319 MemoryContextCreate [57] 0.00 0.00 13/319 MemoryContextStrdup [58] 0.00 0.00 19/319 newNode [51] 0.00 0.00 28/319 DynaHashAlloc [49] 0.00 0.00 238/319 relpath [24] [9] 0.0 0.00 0.00 319 MemoryContextAlloc [9] 0.00 0.00 319/319 AllocSetAlloc [8] ----------------------------------------------- 0.00 0.00 250/250 hash_search [11] [10] 0.0 0.00 0.00 250 call_hash [10] ----------------------------------------------- 0.00 0.00 1/250 InitShmemIndex [142] 0.00 0.00 11/250 ShmemInitStruct [59] 0.00 0.00 238/250 RelationNodeCacheGetRelation [19] [11] 0.0 0.00 0.00 250 hash_search [11] 0.00 0.00 250/250 call_hash [10] 0.00 0.00 238/238 tag_hash [26] 0.00 0.00 12/12 string_hash [60] 0.00 0.00 1/59 ShmemAlloc [43] 0.00 0.00 1/1 element_alloc [185] ----------------------------------------------- 0.00 0.00 249/249 tokenize_file [95] [12] 0.0 0.00 0.00 249 next_token [12] 0.00 0.00 837/837 isblank [5] ----------------------------------------------- 0.00 0.00 243/243 pfree [15] [13] 0.0 0.00 0.00 243 AllocSetFree [13] ----------------------------------------------- 0.00 0.00 1/243 CLOGPhysicalWritePage [101] 0.00 0.00 1/243 XLogFileInit [175] 0.00 0.00 1/243 XLogFileOpen [176] 0.00 0.00 1/243 ReadControlFile [156] 0.00 0.00 1/243 UpdateControlFile [172] 0.00 0.00 238/243 _mdfd_blind_getseg [4052] [14] 0.0 0.00 0.00 243 BasicOpenFile [14] ----------------------------------------------- 0.00 0.00 1/243 crypt_openpwdfile [184] 0.00 0.00 1/243 load_ident [192] 0.00 0.00 1/243 LockMethodTableInit [148] 0.00 0.00 2/243 load_hba [190] 0.00 0.00 238/243 _mdfd_blind_getseg [4052] [15] 0.0 0.00 0.00 243 pfree [15] 0.00 0.00 243/243 AllocSetFree [13] ----------------------------------------------- 0.00 0.00 1/239 CreateCheckPoint [108] 0.00 0.00 238/239 BufferSync [100] [16] 0.0 0.00 0.00 239 XLogFlush [16] 0.00 0.00 2/2002 LWLockRelease [2] 0.00 0.00 1/2 LWLockConditionalAcquire [88] 0.00 0.00 1/2000 LWLockAcquire [3] 0.00 0.00 1/1 XLogWrite [178] ----------------------------------------------- 0.00 0.00 238/238 UnpinBuffer [22] [17] 0.0 0.00 0.00 238 AddBufferToFreelist [17] ----------------------------------------------- 0.00 0.00 238/238 BufferSync [100] [18] 0.0 0.00 0.00 238 PinBuffer [18] ----------------------------------------------- 0.00 0.00 238/238 BufferSync [100] [19] 0.0 0.00 0.00 238 RelationNodeCacheGetRelation [19] 0.00 0.00 238/250 hash_search [11] ----------------------------------------------- 0.00 0.00 238/238 BufferSync [100] [20] 0.0 0.00 0.00 238 StartBufferIO [20] 0.00 0.00 238/2000 LWLockAcquire [3] ----------------------------------------------- 0.00 0.00 238/238 BufferSync [100] [21] 0.0 0.00 0.00 238 TerminateBufferIO [21] 0.00 0.00 238/2002 LWLockRelease [2] ----------------------------------------------- 0.00 0.00 238/238 FlushBufferPool [121] [22] 0.0 0.00 0.00 238 UnpinBuffer [22] 0.00 0.00 238/238 AddBufferToFreelist [17] ----------------------------------------------- 0.00 0.00 238/238 smgrblindwrt [25] [23] 0.0 0.00 0.00 238 mdblindwrt [23] 0.00 0.00 238/238 _mdfd_blind_getseg [4052] ----------------------------------------------- 0.00 0.00 238/238 _mdfd_blind_getseg [4052] [24] 0.0 0.00 0.00 238 relpath [24] 0.00 0.00 238/319 MemoryContextAlloc [9] ----------------------------------------------- 0.00 0.00 238/238 BufferSync [100] [25] 0.0 0.00 0.00 238 smgrblindwrt [25] 0.00 0.00 238/238 mdblindwrt [23] ----------------------------------------------- 0.00 0.00 238/238 hash_search [11] [26] 0.0 0.00 0.00 238 tag_hash [26] ----------------------------------------------- 0.00 0.00 2/234 ClosePostmasterPorts [106] 0.00 0.00 232/234 ServerLoop [165] [27] 0.0 0.00 0.00 234 StreamClose [27] ----------------------------------------------- 0.00 0.00 1/233 SSDataBase [78] 0.00 0.00 232/233 BackendStartup [30] [28] 0.0 0.00 0.00 233 DLAddHead [28] ----------------------------------------------- 0.00 0.00 1/233 SSDataBase [78] 0.00 0.00 232/233 BackendStartup [30] [29] 0.0 0.00 0.00 233 DLNewElem [29] ----------------------------------------------- 0.00 0.00 232/232 ServerLoop [165] [30] 0.0 0.00 0.00 232 BackendStartup [30] 0.00 0.00 232/1161 PostmasterRandom [4] 0.00 0.00 232/233 DLNewElem [29] 0.00 0.00 232/233 DLAddHead [28] ----------------------------------------------- 0.00 0.00 232/232 ServerLoop [165] [31] 0.0 0.00 0.00 232 ConnCreate [31] 0.00 0.00 464/464 CharRemap [7] 0.00 0.00 232/232 StreamConnection [34] 0.00 0.00 232/232 RandomSalt [33] ----------------------------------------------- 0.00 0.00 232/232 ServerLoop [165] [32] 0.0 0.00 0.00 232 ConnFree [32] ----------------------------------------------- 0.00 0.00 232/232 ConnCreate [31] [33] 0.0 0.00 0.00 232 RandomSalt [33] 0.00 0.00 928/1161 PostmasterRandom [4] ----------------------------------------------- 0.00 0.00 232/232 ConnCreate [31] [34] 0.0 0.00 0.00 232 StreamConnection [34] ----------------------------------------------- 0.00 0.00 35/205 load_ident [192] 0.00 0.00 170/205 load_hba [190] [35] 0.0 0.00 0.00 205 read_to_eol [35] ----------------------------------------------- 0.00 0.00 187/187 ProcessConfigFile [155] [36] 0.0 0.00 0.00 187 GUC_yylex [36] 0.00 0.00 2/2 GUC_yy_get_next_buffer [85] 0.00 0.00 1/1 GUC_yy_create_buffer [123] 0.00 0.00 1/3 GUC_yy_load_buffer_state [75] 0.00 0.00 1/1 GUC_yyrestart [125] 0.00 0.00 1/1 GUC_yywrap [126] 0.00 0.00 1/1 GUC_yy_get_previous_state [124] ----------------------------------------------- 0.00 0.00 135/135 reaper [3444] [37] 0.0 0.00 0.00 135 pgstat_ispgstat [37] ----------------------------------------------- 0.00 0.00 134/134 reaper [3444] [38] 0.0 0.00 0.00 134 CleanupProc [38] 0.00 0.00 134/134 DLRemove [40] 0.00 0.00 134/134 DLFreeElem [39] ----------------------------------------------- 0.00 0.00 134/134 CleanupProc [38] [39] 0.0 0.00 0.00 134 DLFreeElem [39] ----------------------------------------------- 0.00 0.00 134/134 CleanupProc [38] [40] 0.0 0.00 0.00 134 DLRemove [40] ----------------------------------------------- 0.00 0.00 133/133 reaper [3444] [41] 0.0 0.00 0.00 133 pgstat_beterm [41] 0.00 0.00 133/133 pgstat_send [42] ----------------------------------------------- 0.00 0.00 133/133 pgstat_beterm [41] [42] 0.0 0.00 0.00 133 pgstat_send [42] ----------------------------------------------- 0.00 0.00 1/59 CLOGShmemInit [102] 0.00 0.00 1/59 reset_shared [206] 0.00 0.00 1/59 LockMethodTableInit [148] 0.00 0.00 1/59 InitProcGlobal [140] 0.00 0.00 1/59 hash_search [11] 0.00 0.00 2/59 XLOGShmemInit [173] 0.00 0.00 2/59 InitBufferPool [131] 0.00 0.00 5/59 ShmemInitHash [67] 0.00 0.00 7/59 CreateSharedMemoryAndSemaphores [114] 0.00 0.00 38/59 init_htab [64] [43] 0.0 0.00 0.00 59 ShmemAlloc [43] ----------------------------------------------- 0.00 0.00 44/44 init_htab [64] [44] 0.0 0.00 0.00 44 seg_alloc [44] 0.00 0.00 6/28 DynaHashAlloc [49] ----------------------------------------------- 0.00 0.00 10/36 hash_estimate_size [68] 0.00 0.00 10/36 hash_select_dirsize [69] 0.00 0.00 16/36 init_htab [64] [45] 0.0 0.00 0.00 36 my_log2 [45] ----------------------------------------------- 0.00 0.00 33/33 IpcSemaphoreCreate [47] [46] 0.0 0.00 0.00 33 InternalIpcSemaphoreCreate [46] ----------------------------------------------- 0.00 0.00 33/33 InitProcGlobal [140] [47] 0.0 0.00 0.00 33 IpcSemaphoreCreate [47] 0.00 0.00 33/33 InternalIpcSemaphoreCreate [46] 0.00 0.00 33/33 IpcSemaphoreUnlock [48] ----------------------------------------------- 0.00 0.00 33/33 IpcSemaphoreCreate [47] [48] 0.0 0.00 0.00 33 IpcSemaphoreUnlock [48] ----------------------------------------------- 0.00 0.00 3/28 init_htab [64] 0.00 0.00 6/28 seg_alloc [44] 0.00 0.00 19/28 hash_create [62] [49] 0.0 0.00 0.00 28 DynaHashAlloc [49] 0.00 0.00 28/319 MemoryContextAlloc [9] ----------------------------------------------- 0.00 0.00 11/24 PostmasterMain [153] 0.00 0.00 13/24 BootstrapMain [98] [50] 0.0 0.00 0.00 24 pqsignal [50] ----------------------------------------------- 0.00 0.00 3/19 lconsi [79] 0.00 0.00 16/19 lcons [53] [51] 0.0 0.00 0.00 19 newNode [51] 0.00 0.00 19/319 MemoryContextAlloc [9] ----------------------------------------------- 0.00 0.00 16/16 tokenize_file [95] [52] 0.0 0.00 0.00 16 lappend [52] 0.00 0.00 16/16 lcons [53] ----------------------------------------------- 0.00 0.00 16/16 lappend [52] [53] 0.0 0.00 0.00 16 lcons [53] 0.00 0.00 16/19 newNode [51] ----------------------------------------------- 0.00 0.00 16/16 tokenize_file [95] [54] 0.0 0.00 0.00 16 nconc [54] ----------------------------------------------- 0.00 0.00 1/14 PostmasterMain [153] 0.00 0.00 1/14 mdinit [195] 0.00 0.00 1/14 CreateCacheMemoryContext [107] 0.00 0.00 2/14 MemoryContextInit [151] 0.00 0.00 9/14 hash_create [62] [55] 0.0 0.00 0.00 14 AllocSetContextCreate [55] 0.00 0.00 14/14 MemoryContextCreate [57] ----------------------------------------------- 0.00 0.00 14/14 MemoryContextCreate [57] [56] 0.0 0.00 0.00 14 AllocSetInit [56] ----------------------------------------------- 0.00 0.00 14/14 AllocSetContextCreate [55] [57] 0.0 0.00 0.00 14 MemoryContextCreate [57] 0.00 0.00 14/14 AllocSetInit [56] 0.00 0.00 13/319 MemoryContextAlloc [9] ----------------------------------------------- 0.00 0.00 13/13 tokenize_file [95] [58] 0.0 0.00 0.00 13 MemoryContextStrdup [58] 0.00 0.00 13/319 MemoryContextAlloc [9] ----------------------------------------------- 0.00 0.00 1/12 CLOGShmemInit [102] 0.00 0.00 1/12 LockMethodTableInit [148] 0.00 0.00 1/12 InitProcGlobal [140] 0.00 0.00 2/12 XLOGShmemInit [173] 0.00 0.00 2/12 InitBufferPool [131] 0.00 0.00 5/12 ShmemInitHash [67] [59] 0.0 0.00 0.00 12 ShmemInitStruct [59] 0.00 0.00 12/2000 LWLockAcquire [3] 0.00 0.00 11/250 hash_search [11] 0.00 0.00 11/2002 LWLockRelease [2] ----------------------------------------------- 0.00 0.00 12/12 hash_search [11] [60] 0.0 0.00 0.00 12 string_hash [60] ----------------------------------------------- 0.00 0.00 8/8 CheckPointCLOG [104] [61] 0.0 0.00 0.00 8 WriteCLOGPage [61] 0.00 0.00 2/2000 LWLockAcquire [3] 0.00 0.00 1/2002 LWLockRelease [2] 0.00 0.00 1/1 CLOGPhysicalWritePage [101] ----------------------------------------------- 0.00 0.00 3/8 CreateDummyCaches [110] 0.00 0.00 5/8 ShmemInitHash [67] [62] 0.0 0.00 0.00 8 hash_create [62] 0.00 0.00 19/28 DynaHashAlloc [49] 0.00 0.00 9/14 AllocSetContextCreate [55] 0.00 0.00 8/8 init_htab [64] ----------------------------------------------- 0.00 0.00 3/8 CreateDummyCaches [110] 0.00 0.00 5/8 ShmemInitHash [67] [63] 0.0 0.00 0.00 8 hdefault [63] ----------------------------------------------- 0.00 0.00 8/8 hash_create [62] [64] 0.0 0.00 0.00 8 init_htab [64] 0.00 0.00 44/44 seg_alloc [44] 0.00 0.00 38/59 ShmemAlloc [43] 0.00 0.00 16/36 my_log2 [45] 0.00 0.00 3/28 DynaHashAlloc [49] ----------------------------------------------- 0.00 0.00 1/7 crypt_openpwdfile [184] 0.00 0.00 1/7 load_hba [190] 0.00 0.00 1/7 load_ident [192] 0.00 0.00 1/7 checkDataDir [182] 0.00 0.00 1/7 ProcessConfigFile [155] 0.00 0.00 2/7 ValidatePgVersion [93] [65] 0.0 0.00 0.00 7 AllocateFile [65] ----------------------------------------------- 0.00 0.00 1/6 load_hba [190] 0.00 0.00 1/6 load_ident [192] 0.00 0.00 1/6 checkDataDir [182] 0.00 0.00 1/6 ProcessConfigFile [155] 0.00 0.00 2/6 ValidatePgVersion [93] [66] 0.0 0.00 0.00 6 FreeFile [66] ----------------------------------------------- 0.00 0.00 1/5 InitBufTable [130] 0.00 0.00 1/5 InitFreeSpaceMap [136] 0.00 0.00 1/5 InitShmemIndex [142] 0.00 0.00 2/5 LockMethodTableInit [148] [67] 0.0 0.00 0.00 5 ShmemInitHash [67] 0.00 0.00 5/5 hash_select_dirsize [69] 0.00 0.00 5/59 ShmemAlloc [43] 0.00 0.00 5/12 ShmemInitStruct [59] 0.00 0.00 5/8 hdefault [63] 0.00 0.00 5/8 hash_create [62] ----------------------------------------------- 0.00 0.00 1/5 FreeSpaceShmemSize [122] 0.00 0.00 2/5 BufferShmemSize [99] 0.00 0.00 2/5 LockShmemSize [150] [68] 0.0 0.00 0.00 5 hash_estimate_size [68] 0.00 0.00 10/36 my_log2 [45] ----------------------------------------------- 0.00 0.00 5/5 ShmemInitHash [67] [69] 0.0 0.00 0.00 5 hash_select_dirsize [69] 0.00 0.00 10/36 my_log2 [45] ----------------------------------------------- 0.00 0.00 1/5 InitBufferPoolAccess [132] 0.00 0.00 1/5 InitProcGlobal [140] 0.00 0.00 1/5 InitDummyProcess [134] 0.00 0.00 2/5 InternalIpcMemoryCreate [143] [70] 0.0 0.00 0.00 5 on_shmem_exit [70] ----------------------------------------------- 0.00 0.00 1/4 BootstrapMain [98] 0.00 0.00 3/4 PostmasterMain [153] [71] 0.0 0.00 0.00 4 SetConfigOption [71] 0.00 0.00 4/4 set_config_option [74] ----------------------------------------------- 0.00 0.00 4/4 set_config_option [74] [72] 0.0 0.00 0.00 4 find_option [72] ----------------------------------------------- 0.00 0.00 1/4 StreamServerPort [91] 0.00 0.00 1/4 smgrinit [211] 0.00 0.00 2/4 CreateLockFile [81] [73] 0.0 0.00 0.00 4 on_proc_exit [73] ----------------------------------------------- 0.00 0.00 4/4 SetConfigOption [71] [74] 0.0 0.00 0.00 4 set_config_option [74] 0.00 0.00 4/4 find_option [72] 0.00 0.00 3/3 parse_int [80] 0.00 0.00 1/1 parse_bool [198] ----------------------------------------------- 0.00 0.00 1/3 GUC_yylex [36] 0.00 0.00 1/3 GUC_yy_get_next_buffer [85] 0.00 0.00 1/3 GUC_yy_flush_buffer [84] [75] 0.0 0.00 0.00 3 GUC_yy_load_buffer_state [75] ----------------------------------------------- 0.00 0.00 1/3 PostmasterMain [153] 0.00 0.00 2/3 CreateDummyCaches [110] [76] 0.0 0.00 0.00 3 MemoryContextSwitchTo [76] ----------------------------------------------- 0.00 0.00 1/3 CreateLWLocks [111] 0.00 0.00 2/3 LWLockShmemSize [89] [77] 0.0 0.00 0.00 3 NumLWLocks [77] ----------------------------------------------- 0.00 0.00 1/3 PostmasterMain [153] 0.00 0.00 2/3 ServerLoop [165] [78] 0.0 0.00 0.00 3 SSDataBase [78] 0.00 0.00 1/1 on_exit_reset [197] 0.00 0.00 1/1 pgstat_close_sockets [201] 0.00 0.00 1/1 set_ps_display [208] 0.00 0.00 1/1 BootstrapMain [98] 0.00 0.00 1/1161 PostmasterRandom [4] 0.00 0.00 1/233 DLNewElem [29] 0.00 0.00 1/233 DLAddHead [28] ----------------------------------------------- 0.00 0.00 3/3 tokenize_file [95] [79] 0.0 0.00 0.00 3 lconsi [79] 0.00 0.00 3/19 newNode [51] ----------------------------------------------- 0.00 0.00 3/3 set_config_option [74] [80] 0.0 0.00 0.00 3 parse_int [80] ----------------------------------------------- 0.00 0.00 1/2 CreateDataDirLockFile [109] 0.00 0.00 1/2 CreateSocketLockFile [115] [81] 0.0 0.00 0.00 2 CreateLockFile [81] 0.00 0.00 2/4 on_proc_exit [73] ----------------------------------------------- 0.00 0.00 1/2 PostmasterMain [153] 0.00 0.00 1/2 CreateOptsFile [112] [82] 0.0 0.00 0.00 2 FindExec [82] 0.00 0.00 2/2 ValidateBinary [92] ----------------------------------------------- 0.00 0.00 2/2 GUC_yy_create_buffer [123] [83] 0.0 0.00 0.00 2 GUC_yy_flex_alloc [83] ----------------------------------------------- 0.00 0.00 2/2 GUC_yy_init_buffer [86] [84] 0.0 0.00 0.00 2 GUC_yy_flush_buffer [84] 0.00 0.00 1/3 GUC_yy_load_buffer_state [75] ----------------------------------------------- 0.00 0.00 2/2 GUC_yylex [36] [85] 0.0 0.00 0.00 2 GUC_yy_get_next_buffer [85] 0.00 0.00 1/3 GUC_yy_load_buffer_state [75] ----------------------------------------------- 0.00 0.00 1/2 GUC_yyrestart [125] 0.00 0.00 1/2 GUC_yy_create_buffer [123] [86] 0.0 0.00 0.00 2 GUC_yy_init_buffer [86] 0.00 0.00 2/2 GUC_yy_flush_buffer [84] ----------------------------------------------- 0.00 0.00 1/2 BootstrapMain [98] 0.00 0.00 1/2 PostmasterMain [153] [87] 0.0 0.00 0.00 2 IgnoreSystemIndexes [87] ----------------------------------------------- 0.00 0.00 1/2 XLogFlush [16] 0.00 0.00 1/2 CreateCheckPoint [108] [88] 0.0 0.00 0.00 2 LWLockConditionalAcquire [88] ----------------------------------------------- 0.00 0.00 1/2 CreateSharedMemoryAndSemaphores [114] 0.00 0.00 1/2 CreateLWLocks [111] [89] 0.0 0.00 0.00 2 LWLockShmemSize [89] 0.00 0.00 2/3 NumLWLocks [77] ----------------------------------------------- 0.00 0.00 1/2 CreateSharedMemoryAndSemaphores [114] 0.00 0.00 1/2 SIBufferInit [164] [90] 0.0 0.00 0.00 2 SInvalShmemSize [90] ----------------------------------------------- 0.00 0.00 2/2 PostmasterMain [153] [91] 0.0 0.00 0.00 2 StreamServerPort [91] 0.00 0.00 1/1 CreateSocketLockFile [115] 0.00 0.00 1/4 on_proc_exit [73] ----------------------------------------------- 0.00 0.00 2/2 FindExec [82] [92] 0.0 0.00 0.00 2 ValidateBinary [92] ----------------------------------------------- 0.00 0.00 1/2 BootstrapMain [98] 0.00 0.00 1/2 checkDataDir [182] [93] 0.0 0.00 0.00 2 ValidatePgVersion [93] 0.00 0.00 2/7 AllocateFile [65] 0.00 0.00 2/6 FreeFile [66] ----------------------------------------------- 0.00 0.00 1/2 BootstrapMain [98] 0.00 0.00 1/2 PostmasterMain [153] [94] 0.0 0.00 0.00 2 XLOGPathInit [94] ----------------------------------------------- 0.00 0.00 1/2 load_hba [190] 0.00 0.00 1/2 load_ident [192] [95] 0.0 0.00 0.00 2 tokenize_file [95] 0.00 0.00 249/249 next_token [12] 0.00 0.00 16/16 nconc [54] 0.00 0.00 16/16 lappend [52] 0.00 0.00 13/13 MemoryContextStrdup [58] 0.00 0.00 3/3 lconsi [79] ----------------------------------------------- 0.00 0.00 1/1 shmem_exit [209] [96] 0.0 0.00 0.00 1 AbortBufferIO [96] ----------------------------------------------- 0.00 0.00 1/1 BootstrapMain [98] [97] 0.0 0.00 0.00 1 BaseInit [97] 0.00 0.00 1/1 InitCommunication [133] 0.00 0.00 1/1 DebugFileOpen [118] 0.00 0.00 1/1 smgrinit [211] 0.00 0.00 1/1 InitBufferPoolAccess [132] ----------------------------------------------- 0.00 0.00 1/1 SSDataBase [78] [98] 0.0 0.00 0.00 1 BootstrapMain [98] 0.00 0.00 13/24 pqsignal [50] 0.00 0.00 1/4 SetConfigOption [71] 0.00 0.00 1/2 ValidatePgVersion [93] 0.00 0.00 1/2 IgnoreSystemIndexes [87] 0.00 0.00 1/2 XLOGPathInit [94] 0.00 0.00 1/1 InitLocalBuffer [137] 0.00 0.00 1/1 BaseInit [97] 0.00 0.00 1/1 ZeroProcSemaphore [179] 0.00 0.00 1/1 InitDummyProcess [134] 0.00 0.00 1/1 CreateDummyCaches [110] 0.00 0.00 1/1 CreateCheckPoint [108] 0.00 0.00 1/1 SetRedoRecPtr [167] 0.00 0.00 1/1 proc_exit [205] ----------------------------------------------- 0.00 0.00 1/1 CreateSharedMemoryAndSemaphores [114] [99] 0.0 0.00 0.00 1 BufferShmemSize [99] 0.00 0.00 2/5 hash_estimate_size [68] ----------------------------------------------- 0.00 0.00 1/1 FlushBufferPool [121] [100] 0.0 0.00 0.00 1 BufferSync [100] 0.00 0.00 1500/2000 LWLockAcquire [3] 0.00 0.00 1500/2002 LWLockRelease [2] 0.00 0.00 238/238 PinBuffer [18] 0.00 0.00 238/238 StartBufferIO [20] 0.00 0.00 238/238 RelationNodeCacheGetRelation [19] 0.00 0.00 238/239 XLogFlush [16] 0.00 0.00 238/238 smgrblindwrt [25] 0.00 0.00 238/238 TerminateBufferIO [21] ----------------------------------------------- 0.00 0.00 1/1 WriteCLOGPage [61] [101] 0.0 0.00 0.00 1 CLOGPhysicalWritePage [101] 0.00 0.00 1/243 BasicOpenFile [14] ----------------------------------------------- 0.00 0.00 1/1 CreateSharedMemoryAndSemaphores [114] [102] 0.0 0.00 0.00 1 CLOGShmemInit [102] 0.00 0.00 8/2056 LWLockAssign [1] 0.00 0.00 1/59 ShmemAlloc [43] 0.00 0.00 1/12 ShmemInitStruct [59] ----------------------------------------------- 0.00 0.00 1/1 CreateSharedMemoryAndSemaphores [114] [103] 0.0 0.00 0.00 1 CLOGShmemSize [103] ----------------------------------------------- 0.00 0.00 1/1 CreateCheckPoint [108] [104] 0.0 0.00 0.00 1 CheckPointCLOG [104] 0.00 0.00 8/8 WriteCLOGPage [61] 0.00 0.00 2/2002 LWLockRelease [2] 0.00 0.00 1/2000 LWLockAcquire [3] ----------------------------------------------- 0.00 0.00 1/1 ResetAllOptions [159] [105] 0.0 0.00 0.00 1 ClearDateCache [105] ----------------------------------------------- 0.00 0.00 1/1 ServerLoop [165] [106] 0.0 0.00 0.00 1 ClosePostmasterPorts [106] 0.00 0.00 2/234 StreamClose [27] ----------------------------------------------- 0.00 0.00 1/1 CreateDummyCaches [110] [107] 0.0 0.00 0.00 1 CreateCacheMemoryContext [107] 0.00 0.00 1/14 AllocSetContextCreate [55] ----------------------------------------------- 0.00 0.00 1/1 BootstrapMain [98] [108] 0.0 0.00 0.00 1 CreateCheckPoint [108] 0.00 0.00 5/2002 LWLockRelease [2] 0.00 0.00 4/2000 LWLockAcquire [3] 0.00 0.00 1/2 LWLockConditionalAcquire [88] 0.00 0.00 1/1 GetUndoRecPtr [129] 0.00 0.00 1/1 smgrsync [213] 0.00 0.00 1/1 FlushBufferPool [121] 0.00 0.00 1/1 CheckPointCLOG [104] 0.00 0.00 1/1 XLogInsert [177] 0.00 0.00 1/239 XLogFlush [16] 0.00 0.00 1/1 UpdateControlFile [172] 0.00 0.00 1/1 PreallocXlogFiles [154] ----------------------------------------------- 0.00 0.00 1/1 PostmasterMain [153] [109] 0.0 0.00 0.00 1 CreateDataDirLockFile [109] 0.00 0.00 1/2 CreateLockFile [81] ----------------------------------------------- 0.00 0.00 1/1 BootstrapMain [98] [110] 0.0 0.00 0.00 1 CreateDummyCaches [110] 0.00 0.00 3/8 hdefault [63] 0.00 0.00 3/8 hash_create [62] 0.00 0.00 2/3 MemoryContextSwitchTo [76] 0.00 0.00 1/1 CreateCacheMemoryContext [107] ----------------------------------------------- 0.00 0.00 1/1 reset_shared [206] [111] 0.0 0.00 0.00 1 CreateLWLocks [111] 0.00 0.00 1/3 NumLWLocks [77] 0.00 0.00 1/2 LWLockShmemSize [89] ----------------------------------------------- 0.00 0.00 1/1 PostmasterMain [153] [112] 0.0 0.00 0.00 1 CreateOptsFile [112] 0.00 0.00 1/2 FindExec [82] 0.00 0.00 1/319 MemoryContextAlloc [9] ----------------------------------------------- 0.00 0.00 1/1 CreateSharedMemoryAndSemaphores [114] [113] 0.0 0.00 0.00 1 CreateSharedInvalidationState [113] ----------------------------------------------- 0.00 0.00 1/1 reset_shared [206] [114] 0.0 0.00 0.00 1 CreateSharedMemoryAndSemaphores [114] 0.00 0.00 7/59 ShmemAlloc [43] 0.00 0.00 1/1 BufferShmemSize [99] 0.00 0.00 1/1 LockShmemSize [150] 0.00 0.00 1/1 XLOGShmemSize [174] 0.00 0.00 1/1 CLOGShmemSize [103] 0.00 0.00 1/2 LWLockShmemSize [89] 0.00 0.00 1/2 SInvalShmemSize [90] 0.00 0.00 1/1 FreeSpaceShmemSize [122] 0.00 0.00 1/1 IpcMemoryCreate [145] 0.00 0.00 1/1 CreateSpinlocks [116] 0.00 0.00 1/1 InitShmemAllocation [141] 0.00 0.00 1/1 InitShmemIndex [142] 0.00 0.00 1/1 CLOGShmemInit [102] 0.00 0.00 1/1 InitBufferPool [131] 0.00 0.00 1/1 InitLocks [139] 0.00 0.00 1/1 InitLockTable [138] 0.00 0.00 1/1 InitProcGlobal [140] 0.00 0.00 1/1 SIBufferInit [164] 0.00 0.00 1/1 CreateSharedInvalidationState [113] 0.00 0.00 1/1 InitFreeSpaceMap [136] ----------------------------------------------- 0.00 0.00 1/1 StreamServerPort [91] [115] 0.0 0.00 0.00 1 CreateSocketLockFile [115] 0.00 0.00 1/2 CreateLockFile [81] ----------------------------------------------- 0.00 0.00 1/1 CreateSharedMemoryAndSemaphores [114] [116] 0.0 0.00 0.00 1 CreateSpinlocks [116] ----------------------------------------------- 0.00 0.00 1/1 PostmasterMain [153] [117] 0.0 0.00 0.00 1 DLNewList [117] ----------------------------------------------- 0.00 0.00 1/1 BaseInit [97] [118] 0.0 0.00 0.00 1 DebugFileOpen [118] ----------------------------------------------- 0.00 0.00 1/1 shmem_exit [209] [119] 0.0 0.00 0.00 1 DummyProcKill [119] 0.00 0.00 1/1 LWLockReleaseAll [146] ----------------------------------------------- 0.00 0.00 1/1 PostmasterMain [153] [120] 0.0 0.00 0.00 1 EnableExceptionHandling [120] ----------------------------------------------- 0.00 0.00 1/1 CreateCheckPoint [108] [121] 0.0 0.00 0.00 1 FlushBufferPool [121] 0.00 0.00 476/476 LockBuffer [6] 0.00 0.00 238/238 UnpinBuffer [22] 0.00 0.00 1/1 BufferSync [100] ----------------------------------------------- 0.00 0.00 1/1 CreateSharedMemoryAndSemaphores [114] [122] 0.0 0.00 0.00 1 FreeSpaceShmemSize [122] 0.00 0.00 1/5 hash_estimate_size [68] ----------------------------------------------- 0.00 0.00 1/1 GUC_yylex [36] [123] 0.0 0.00 0.00 1 GUC_yy_create_buffer [123] 0.00 0.00 2/2 GUC_yy_flex_alloc [83] 0.00 0.00 1/2 GUC_yy_init_buffer [86] ----------------------------------------------- 0.00 0.00 1/1 GUC_yylex [36] [124] 0.0 0.00 0.00 1 GUC_yy_get_previous_state [124] ----------------------------------------------- 0.00 0.00 1/1 GUC_yylex [36] [125] 0.0 0.00 0.00 1 GUC_yyrestart [125] 0.00 0.00 1/2 GUC_yy_init_buffer [86] ----------------------------------------------- 0.00 0.00 1/1 GUC_yylex [36] [126] 0.0 0.00 0.00 1 GUC_yywrap [126] ----------------------------------------------- 0.00 0.00 1/1 XLogInsert [177] [127] 0.0 0.00 0.00 1 GetCurrentTransactionId [127] ----------------------------------------------- 0.00 0.00 1/1 reaper [3444] [128] 0.0 0.00 0.00 1 GetRedoRecPtr [128] ----------------------------------------------- 0.00 0.00 1/1 CreateCheckPoint [108] [129] 0.0 0.00 0.00 1 GetUndoRecPtr [129] 0.00 0.00 1/2000 LWLockAcquire [3] 0.00 0.00 1/2002 LWLockRelease [2] ----------------------------------------------- 0.00 0.00 1/1 InitBufferPool [131] [130] 0.0 0.00 0.00 1 InitBufTable [130] 0.00 0.00 1/5 ShmemInitHash [67] ----------------------------------------------- 0.00 0.00 1/1 CreateSharedMemoryAndSemaphores [114] [131] 0.0 0.00 0.00 1 InitBufferPool [131] 0.00 0.00 2048/2056 LWLockAssign [1] 0.00 0.00 2/59 ShmemAlloc [43] 0.00 0.00 2/12 ShmemInitStruct [59] 0.00 0.00 1/2000 LWLockAcquire [3] 0.00 0.00 1/1 InitBufTable [130] 0.00 0.00 1/1 InitFreeList [135] 0.00 0.00 1/2002 LWLockRelease [2] ----------------------------------------------- 0.00 0.00 1/1 BaseInit [97] [132] 0.0 0.00 0.00 1 InitBufferPoolAccess [132] 0.00 0.00 1/5 on_shmem_exit [70] ----------------------------------------------- 0.00 0.00 1/1 BaseInit [97] [133] 0.0 0.00 0.00 1 InitCommunication [133] ----------------------------------------------- 0.00 0.00 1/1 BootstrapMain [98] [134] 0.0 0.00 0.00 1 InitDummyProcess [134] 0.00 0.00 1/1 SHMQueueElemInit [162] 0.00 0.00 1/1 SHMQueueInit [163] 0.00 0.00 1/5 on_shmem_exit [70] ----------------------------------------------- 0.00 0.00 1/1 InitBufferPool [131] [135] 0.0 0.00 0.00 1 InitFreeList [135] ----------------------------------------------- 0.00 0.00 1/1 CreateSharedMemoryAndSemaphores [114] [136] 0.0 0.00 0.00 1 InitFreeSpaceMap [136] 0.00 0.00 1/5 ShmemInitHash [67] ----------------------------------------------- 0.00 0.00 1/1 BootstrapMain [98] [137] 0.0 0.00 0.00 1 InitLocalBuffer [137] ----------------------------------------------- 0.00 0.00 1/1 CreateSharedMemoryAndSemaphores [114] [138] 0.0 0.00 0.00 1 InitLockTable [138] 0.00 0.00 1/1 LockMethodTableInit [148] 0.00 0.00 1/1 LockMethodTableRename [149] ----------------------------------------------- 0.00 0.00 1/1 CreateSharedMemoryAndSemaphores [114] [139] 0.0 0.00 0.00 1 InitLocks [139] ----------------------------------------------- 0.00 0.00 1/1 CreateSharedMemoryAndSemaphores [114] [140] 0.0 0.00 0.00 1 InitProcGlobal [140] 0.00 0.00 33/33 IpcSemaphoreCreate [47] 0.00 0.00 1/59 ShmemAlloc [43] 0.00 0.00 1/12 ShmemInitStruct [59] 0.00 0.00 1/5 on_shmem_exit [70] ----------------------------------------------- 0.00 0.00 1/1 CreateSharedMemoryAndSemaphores [114] [141] 0.0 0.00 0.00 1 InitShmemAllocation [141] ----------------------------------------------- 0.00 0.00 1/1 CreateSharedMemoryAndSemaphores [114] [142] 0.0 0.00 0.00 1 InitShmemIndex [142] 0.00 0.00 1/5 ShmemInitHash [67] 0.00 0.00 1/250 hash_search [11] 0.00 0.00 1/2002 LWLockRelease [2] ----------------------------------------------- 0.00 0.00 1/1 IpcMemoryCreate [145] [143] 0.0 0.00 0.00 1 InternalIpcMemoryCreate [143] 0.00 0.00 2/5 on_shmem_exit [70] 0.00 0.00 1/1 RecordSharedMemoryInLockFile [157] ----------------------------------------------- 0.00 0.00 1/1 reset_shared [206] [144] 0.0 0.00 0.00 1 IpcInitKeyAssignment [144] ----------------------------------------------- 0.00 0.00 1/1 CreateSharedMemoryAndSemaphores [114] [145] 0.0 0.00 0.00 1 IpcMemoryCreate [145] 0.00 0.00 1/1 InternalIpcMemoryCreate [143] ----------------------------------------------- 0.00 0.00 1/1 DummyProcKill [119] [146] 0.0 0.00 0.00 1 LWLockReleaseAll [146] ----------------------------------------------- 0.00 0.00 1/1 LockMethodTableInit [148] [147] 0.0 0.00 0.00 1 LockMethodInit [147] ----------------------------------------------- 0.00 0.00 1/1 InitLockTable [138] [148] 0.0 0.00 0.00 1 LockMethodTableInit [148] 0.00 0.00 2/319 MemoryContextAlloc [9] 0.00 0.00 2/5 ShmemInitHash [67] 0.00 0.00 1/2000 LWLockAcquire [3] 0.00 0.00 1/59 ShmemAlloc [43] 0.00 0.00 1/12 ShmemInitStruct [59] 0.00 0.00 1/1 LockMethodInit [147] 0.00 0.00 1/2002 LWLockRelease [2] 0.00 0.00 1/243 pfree [15] ----------------------------------------------- 0.00 0.00 1/1 InitLockTable [138] [149] 0.0 0.00 0.00 1 LockMethodTableRename [149] ----------------------------------------------- 0.00 0.00 1/1 CreateSharedMemoryAndSemaphores [114] [150] 0.0 0.00 0.00 1 LockShmemSize [150] 0.00 0.00 2/5 hash_estimate_size [68] ----------------------------------------------- 0.00 0.00 1/1 PostmasterMain [153] [151] 0.0 0.00 0.00 1 MemoryContextInit [151] 0.00 0.00 2/14 AllocSetContextCreate [55] ----------------------------------------------- 0.00 0.00 1/1 reset_shared [206] [152] 0.0 0.00 0.00 1 PMSignalInit [152] ----------------------------------------------- 0.00 0.00 1/1 main [2822] [153] 0.0 0.00 0.00 1 PostmasterMain [153] 0.00 0.00 11/24 pqsignal [50] 0.00 0.00 3/4 SetConfigOption [71] 0.00 0.00 2/2 StreamServerPort [91] 0.00 0.00 1/1 EnableExceptionHandling [120] 0.00 0.00 1/1 MemoryContextInit [151] 0.00 0.00 1/14 AllocSetContextCreate [55] 0.00 0.00 1/3 MemoryContextSwitchTo [76] 0.00 0.00 1/1 ResetAllOptions [159] 0.00 0.00 1/1 checkDataDir [182] 0.00 0.00 1/1 SetDataDir [166] 0.00 0.00 1/1 free_name_value_list [186] 0.00 0.00 1/1 ProcessConfigFile [155] 0.00 0.00 1/2 IgnoreSystemIndexes [87] 0.00 0.00 1/2 FindExec [82] 0.00 0.00 1/1 CreateDataDirLockFile [109] 0.00 0.00 1/1 RemovePgTempFiles [158] 0.00 0.00 1/2 XLOGPathInit [94] 0.00 0.00 1/1 reset_shared [206] 0.00 0.00 1/1 DLNewList [117] 0.00 0.00 1/1 CreateOptsFile [112] 0.00 0.00 1/1 pqinitmask [204] 0.00 0.00 1/1 load_ident [192] 0.00 0.00 1/1 load_hba_and_ident [191] 0.00 0.00 1/1 load_password_cache [193] 0.00 0.00 1/3 SSDataBase [78] 0.00 0.00 1/1 ServerLoop [165] ----------------------------------------------- 0.00 0.00 1/1 CreateCheckPoint [108] [154] 0.0 0.00 0.00 1 PreallocXlogFiles [154] 0.00 0.00 1/1 XLogFileInit [175] ----------------------------------------------- 0.00 0.00 1/1 PostmasterMain [153] [155] 0.0 0.00 0.00 1 ProcessConfigFile [155] 0.00 0.00 187/187 GUC_yylex [36] 0.00 0.00 1/7 AllocateFile [65] 0.00 0.00 1/6 FreeFile [66] ----------------------------------------------- 0.00 0.00 1/1 XLOGShmemInit [173] [156] 0.0 0.00 0.00 1 ReadControlFile [156] 0.00 0.00 1/243 BasicOpenFile [14] ----------------------------------------------- 0.00 0.00 1/1 InternalIpcMemoryCreate [143] [157] 0.0 0.00 0.00 1 RecordSharedMemoryInLockFile [157] ----------------------------------------------- 0.00 0.00 1/1 PostmasterMain [153] [158] 0.0 0.00 0.00 1 RemovePgTempFiles [158] ----------------------------------------------- 0.00 0.00 1/1 PostmasterMain [153] [159] 0.0 0.00 0.00 1 ResetAllOptions [159] 0.00 0.00 1/1 ClearDateCache [105] 0.00 0.00 1/1 assign_xlog_sync_method [181] 0.00 0.00 1/1 assign_defaultxactisolevel [180] ----------------------------------------------- 0.00 0.00 1/1 ShutdownBufferPoolAccess [169] [160] 0.0 0.00 0.00 1 ResetBufferPool [160] 0.00 0.00 1/1 ResetLocalBufferPool [161] ----------------------------------------------- 0.00 0.00 1/1 ResetBufferPool [160] [161] 0.0 0.00 0.00 1 ResetLocalBufferPool [161] ----------------------------------------------- 0.00 0.00 1/1 InitDummyProcess [134] [162] 0.0 0.00 0.00 1 SHMQueueElemInit [162] ----------------------------------------------- 0.00 0.00 1/1 InitDummyProcess [134] [163] 0.0 0.00 0.00 1 SHMQueueInit [163] ----------------------------------------------- 0.00 0.00 1/1 CreateSharedMemoryAndSemaphores [114] [164] 0.0 0.00 0.00 1 SIBufferInit [164] 0.00 0.00 1/2 SInvalShmemSize [90] ----------------------------------------------- 0.00 0.00 1/1 PostmasterMain [153] [165] 0.0 0.00 0.00 1 ServerLoop [165] 0.00 0.00 232/232 ConnCreate [31] 0.00 0.00 232/232 BackendStartup [30] 0.00 0.00 232/234 StreamClose [27] 0.00 0.00 232/232 ConnFree [32] 0.00 0.00 2/3 SSDataBase [78] 0.00 0.00 1/1 initMasks [187] 0.00 0.00 1/1 init_ps_display [188] 0.00 0.00 1/1 ClosePostmasterPorts [106] 0.00 0.00 1/1 TouchSocketLockFile [170] ----------------------------------------------- 0.00 0.00 1/1 PostmasterMain [153] [166] 0.0 0.00 0.00 1 SetDataDir [166] ----------------------------------------------- 0.00 0.00 1/1 BootstrapMain [98] [167] 0.0 0.00 0.00 1 SetRedoRecPtr [167] ----------------------------------------------- 0.00 0.00 1/1 reaper [3444] [168] 0.0 0.00 0.00 1 SetThisStartUpID [168] ----------------------------------------------- 0.00 0.00 1/1 shmem_exit [209] [169] 0.0 0.00 0.00 1 ShutdownBufferPoolAccess [169] 0.00 0.00 1/1 UnlockBuffers [171] 0.00 0.00 1/1 smgrabort [210] 0.00 0.00 1/1 ResetBufferPool [160] ----------------------------------------------- 0.00 0.00 1/1 ServerLoop [165] [170] 0.0 0.00 0.00 1 TouchSocketLockFile [170] ----------------------------------------------- 0.00 0.00 1/1 ShutdownBufferPoolAccess [169] [171] 0.0 0.00 0.00 1 UnlockBuffers [171] ----------------------------------------------- 0.00 0.00 1/1 CreateCheckPoint [108] [172] 0.0 0.00 0.00 1 UpdateControlFile [172] 0.00 0.00 1/243 BasicOpenFile [14] 0.00 0.00 1/1 pg_fsync [200] ----------------------------------------------- 0.00 0.00 1/1 reset_shared [206] [173] 0.0 0.00 0.00 1 XLOGShmemInit [173] 0.00 0.00 2/59 ShmemAlloc [43] 0.00 0.00 2/12 ShmemInitStruct [59] 0.00 0.00 1/1 ReadControlFile [156] ----------------------------------------------- 0.00 0.00 1/1 CreateSharedMemoryAndSemaphores [114] [174] 0.0 0.00 0.00 1 XLOGShmemSize [174] ----------------------------------------------- 0.00 0.00 1/1 PreallocXlogFiles [154] [175] 0.0 0.00 0.00 1 XLogFileInit [175] 0.00 0.00 1/243 BasicOpenFile [14] ----------------------------------------------- 0.00 0.00 1/1 XLogWrite [178] [176] 0.0 0.00 0.00 1 XLogFileOpen [176] 0.00 0.00 1/243 BasicOpenFile [14] ----------------------------------------------- 0.00 0.00 1/1 CreateCheckPoint [108] [177] 0.0 0.00 0.00 1 XLogInsert [177] 0.00 0.00 1/2000 LWLockAcquire [3] 0.00 0.00 1/1 GetCurrentTransactionId [127] 0.00 0.00 1/2002 LWLockRelease [2] ----------------------------------------------- 0.00 0.00 1/1 XLogFlush [16] [178] 0.0 0.00 0.00 1 XLogWrite [178] 0.00 0.00 1/1 XLogFileOpen [176] 0.00 0.00 1/1 issue_xlog_fsync [189] ----------------------------------------------- 0.00 0.00 1/1 BootstrapMain [98] [179] 0.0 0.00 0.00 1 ZeroProcSemaphore [179] ----------------------------------------------- 0.00 0.00 1/1 ResetAllOptions [159] [180] 0.0 0.00 0.00 1 assign_defaultxactisolevel [180] ----------------------------------------------- 0.00 0.00 1/1 ResetAllOptions [159] [181] 0.0 0.00 0.00 1 assign_xlog_sync_method [181] ----------------------------------------------- 0.00 0.00 1/1 PostmasterMain [153] [182] 0.0 0.00 0.00 1 checkDataDir [182] 0.00 0.00 1/2 ValidatePgVersion [93] 0.00 0.00 1/7 AllocateFile [65] 0.00 0.00 1/6 FreeFile [66] ----------------------------------------------- 0.00 0.00 1/1 crypt_openpwdfile [184] [183] 0.0 0.00 0.00 1 crypt_getpwdfilename [183] 0.00 0.00 1/319 MemoryContextAlloc [9] ----------------------------------------------- 0.00 0.00 1/1 load_password_cache [193] [184] 0.0 0.00 0.00 1 crypt_openpwdfile [184] 0.00 0.00 1/1 crypt_getpwdfilename [183] 0.00 0.00 1/7 AllocateFile [65] 0.00 0.00 1/243 pfree [15] ----------------------------------------------- 0.00 0.00 1/1 hash_search [11] [185] 0.0 0.00 0.00 1 element_alloc [185] ----------------------------------------------- 0.00 0.00 1/1 PostmasterMain [153] [186] 0.0 0.00 0.00 1 free_name_value_list [186] ----------------------------------------------- 0.00 0.00 1/1 ServerLoop [165] [187] 0.0 0.00 0.00 1 initMasks [187] ----------------------------------------------- 0.00 0.00 1/1 ServerLoop [165] [188] 0.0 0.00 0.00 1 init_ps_display [188] ----------------------------------------------- 0.00 0.00 1/1 XLogWrite [178] [189] 0.0 0.00 0.00 1 issue_xlog_fsync [189] 0.00 0.00 1/1 pg_fdatasync [199] ----------------------------------------------- 0.00 0.00 1/1 load_hba_and_ident [191] [190] 0.0 0.00 0.00 1 load_hba [190] 0.00 0.00 170/205 read_to_eol [35] 0.00 0.00 2/319 MemoryContextAlloc [9] 0.00 0.00 2/243 pfree [15] 0.00 0.00 1/7 AllocateFile [65] 0.00 0.00 1/2 tokenize_file [95] 0.00 0.00 1/6 FreeFile [66] ----------------------------------------------- 0.00 0.00 1/1 PostmasterMain [153] [191] 0.0 0.00 0.00 1 load_hba_and_ident [191] 0.00 0.00 1/1 load_hba [190] ----------------------------------------------- 0.00 0.00 1/1 PostmasterMain [153] [192] 0.0 0.00 0.00 1 load_ident [192] 0.00 0.00 35/205 read_to_eol [35] 0.00 0.00 1/319 MemoryContextAlloc [9] 0.00 0.00 1/7 AllocateFile [65] 0.00 0.00 1/2 tokenize_file [95] 0.00 0.00 1/6 FreeFile [66] 0.00 0.00 1/243 pfree [15] ----------------------------------------------- 0.00 0.00 1/1 PostmasterMain [153] [193] 0.0 0.00 0.00 1 load_password_cache [193] 0.00 0.00 1/1 crypt_openpwdfile [184] ----------------------------------------------- 0.00 0.00 1/1 smgrabort [210] [194] 0.0 0.00 0.00 1 mdabort [194] ----------------------------------------------- 0.00 0.00 1/1 smgrinit [211] [195] 0.0 0.00 0.00 1 mdinit [195] 0.00 0.00 1/14 AllocSetContextCreate [55] 0.00 0.00 1/319 MemoryContextAlloc [9] ----------------------------------------------- 0.00 0.00 1/1 smgrsync [213] [196] 0.0 0.00 0.00 1 mdsync [196] ----------------------------------------------- 0.00 0.00 1/1 SSDataBase [78] [197] 0.0 0.00 0.00 1 on_exit_reset [197] ----------------------------------------------- 0.00 0.00 1/1 set_config_option [74] [198] 0.0 0.00 0.00 1 parse_bool [198] ----------------------------------------------- 0.00 0.00 1/1 issue_xlog_fsync [189] [199] 0.0 0.00 0.00 1 pg_fdatasync [199] ----------------------------------------------- 0.00 0.00 1/1 UpdateControlFile [172] [200] 0.0 0.00 0.00 1 pg_fsync [200] ----------------------------------------------- 0.00 0.00 1/1 SSDataBase [78] [201] 0.0 0.00 0.00 1 pgstat_close_sockets [201] ----------------------------------------------- 0.00 0.00 1/1 main [2822] [202] 0.0 0.00 0.00 1 pgstat_init [202] ----------------------------------------------- 0.00 0.00 1/1 main [2822] [203] 0.0 0.00 0.00 1 pgstat_start [203] ----------------------------------------------- 0.00 0.00 1/1 PostmasterMain [153] [204] 0.0 0.00 0.00 1 pqinitmask [204] ----------------------------------------------- 0.00 0.00 1/1 BootstrapMain [98] [205] 0.0 0.00 0.00 1 proc_exit [205] 0.00 0.00 1/1 shmem_exit [209] 0.00 0.00 1/1 smgrshutdown [212] ----------------------------------------------- 0.00 0.00 1/1 PostmasterMain [153] [206] 0.0 0.00 0.00 1 reset_shared [206] 0.00 0.00 1/1 IpcInitKeyAssignment [144] 0.00 0.00 1/59 ShmemAlloc [43] 0.00 0.00 1/1 PMSignalInit [152] 0.00 0.00 1/1 XLOGShmemInit [173] 0.00 0.00 1/1 CreateLWLocks [111] 0.00 0.00 1/1 CreateSharedMemoryAndSemaphores [114] ----------------------------------------------- 0.00 0.00 1/1 main [2822] [207] 0.0 0.00 0.00 1 save_ps_display_args [207] ----------------------------------------------- 0.00 0.00 1/1 SSDataBase [78] [208] 0.0 0.00 0.00 1 set_ps_display [208] ----------------------------------------------- 0.00 0.00 1/1 proc_exit [205] [209] 0.0 0.00 0.00 1 shmem_exit [209] 0.00 0.00 1/1 ShutdownBufferPoolAccess [169] 0.00 0.00 1/1 AbortBufferIO [96] 0.00 0.00 1/1 DummyProcKill [119] ----------------------------------------------- 0.00 0.00 1/1 ShutdownBufferPoolAccess [169] [210] 0.0 0.00 0.00 1 smgrabort [210] 0.00 0.00 1/1 mdabort [194] ----------------------------------------------- 0.00 0.00 1/1 BaseInit [97] [211] 0.0 0.00 0.00 1 smgrinit [211] 0.00 0.00 1/1 mdinit [195] 0.00 0.00 1/4 on_proc_exit [73] ----------------------------------------------- 0.00 0.00 1/1 proc_exit [205] [212] 0.0 0.00 0.00 1 smgrshutdown [212] ----------------------------------------------- 0.00 0.00 1/1 CreateCheckPoint [108] [213] 0.0 0.00 0.00 1 smgrsync [213] 0.00 0.00 1/1 mdsync [196] ----------------------------------------------- 0.00 0.00 238/238 mdblindwrt [23] [4052] 0.0 0.00 0.00 238 _mdfd_blind_getseg [4052] 0.00 0.00 238/238 relpath [24] 0.00 0.00 238/243 BasicOpenFile [14] 0.00 0.00 238/243 pfree [15] ----------------------------------------------- This table describes the call tree of the program, and was sorted by the total amount of time spent in each function and its children. Each entry in this table consists of several lines. The line with the index number at the left hand margin lists the current function. The lines above it list the functions that called this function, and the lines below it list the functions this one called. This line lists: index A unique number given to each element of the table. Index numbers are sorted numerically. The index number is printed next to every function name so it is easier to look up where the function in the table. % time This is the percentage of the `total' time that was spent in this function and its children. Note that due to different viewpoints, functions excluded by options, etc, these numbers will NOT add up to 100%. self This is the total amount of time spent in this function. children This is the total amount of time propagated into this function by its children. called This is the number of times the function was called. If the function called itself recursively, the number only includes non-recursive calls, and is followed by a `+' and the number of recursive calls. name The name of the current function. The index number is printed after it. If the function is a member of a cycle, the cycle number is printed between the function's name and the index number. For the function's parents, the fields have the following meanings: self This is the amount of time that was propagated directly from the function into this parent. children This is the amount of time that was propagated from the function's children into this parent. called This is the number of times this parent called the function `/' the total number of times the function was called. Recursive calls to the function are not included in the number after the `/'. name This is the name of the parent. The parent's index number is printed after it. If the parent is a member of a cycle, the cycle number is printed between the name and the index number. If the parents of the function cannot be determined, the word `' is printed in the `name' field, and all the other fields are blank. For the function's children, the fields have the following meanings: self This is the amount of time that was propagated directly from the child into the function. children This is the amount of time that was propagated from the child's children to the function. called This is the number of times the function called this child `/' the total number of times the child was called. Recursive calls by the child are not listed in the number after the `/'. name This is the name of the child. The child's index number is printed after it. If the child is a member of a cycle, the cycle number is printed between the name and the index number. If there are any cycles (circles) in the call graph, there is an entry for the cycle-as-a-whole. This entry shows who called the cycle (as parents) and the members of the cycle (as children.) The `+' recursive calls entry shows the number of function calls that were internal to the cycle, and the calls entry for each member shows, for that member, how many times it was called from other members of the cycle. Index by function name [96] AbortBufferIO [141] InitShmemAllocation [178] XLogWrite (gmon-start.c) [17] AddBufferToFreelist (gmon-start.c) [142] InitShmemIndex [179] ZeroProcSemaphore (gmon-start.c) [8] AllocSetAlloc (gmon-start.c) [143] InternalIpcMemoryCreate (gmon-start.c) [4052] _mdfd_blind_getseg (gmon-start.c) [55] AllocSetContextCreate [46] InternalIpcSemaphoreCreate (gmon-start.c) [180] assign_defaultxactisolevel (gmon-start.c) [13] AllocSetFree (gmon-start.c) [144] IpcInitKeyAssignment [181] assign_xlog_sync_method [56] AllocSetInit (gmon-start.c) [145] IpcMemoryCreate [10] call_hash (gmon-start.c) [65] AllocateFile [47] IpcSemaphoreCreate [182] checkDataDir (gmon-start.c) [30] BackendStartup (gmon-start.c) [48] IpcSemaphoreUnlock [183] crypt_getpwdfilename [97] BaseInit [3] LWLockAcquire [184] crypt_openpwdfile (gmon-start.c) [14] BasicOpenFile [1] LWLockAssign [185] element_alloc (gmon-start.c) [98] BootstrapMain [88] LWLockConditionalAcquire [72] find_option (gmon-start.c) [99] BufferShmemSize [2] LWLockRelease [186] free_name_value_list (gmon-start.c) [100] BufferSync [146] LWLockReleaseAll [62] hash_create [101] CLOGPhysicalWritePage (gmon-start.c) [89] LWLockShmemSize [68] hash_estimate_size [102] CLOGShmemInit [6] LockBuffer [11] hash_search [103] CLOGShmemSize [147] LockMethodInit (gmon-start.c) [69] hash_select_dirsize [7] CharRemap (gmon-start.c) [148] LockMethodTableInit [63] hdefault (gmon-start.c) [104] CheckPointCLOG [149] LockMethodTableRename [187] initMasks (gmon-start.c) [38] CleanupProc (gmon-start.c) [150] LockShmemSize [64] init_htab (gmon-start.c) [105] ClearDateCache [9] MemoryContextAlloc [188] init_ps_display [106] ClosePostmasterPorts [57] MemoryContextCreate [5] isblank (gmon-start.c) [31] ConnCreate (gmon-start.c) [151] MemoryContextInit [189] issue_xlog_fsync (gmon-start.c) [32] ConnFree (gmon-start.c) [58] MemoryContextStrdup [52] lappend [107] CreateCacheMemoryContext [76] MemoryContextSwitchTo [53] lcons [108] CreateCheckPoint [77] NumLWLocks [79] lconsi [109] CreateDataDirLockFile [152] PMSignalInit [190] load_hba (gmon-start.c) [110] CreateDummyCaches [18] PinBuffer [191] load_hba_and_ident [111] CreateLWLocks [153] PostmasterMain [192] load_ident (gmon-start.c) [81] CreateLockFile (gmon-start.c) [4] PostmasterRandom (gmon-start.c) [193] load_password_cache [112] CreateOptsFile (gmon-start.c) [154] PreallocXlogFiles (gmon-start.c) [194] mdabort [113] CreateSharedInvalidationState [155] ProcessConfigFile [23] mdblindwrt [114] CreateSharedMemoryAndSemaphores [33] RandomSalt (gmon-start.c) [195] mdinit [115] CreateSocketLockFile [156] ReadControlFile (gmon-start.c) [196] mdsync [116] CreateSpinlocks [157] RecordSharedMemoryInLockFile [45] my_log2 [28] DLAddHead [19] RelationNodeCacheGetRelation [54] nconc [39] DLFreeElem [158] RemovePgTempFiles [51] newNode [29] DLNewElem [159] ResetAllOptions [12] next_token (gmon-start.c) [117] DLNewList [160] ResetBufferPool [197] on_exit_reset [40] DLRemove [161] ResetLocalBufferPool [73] on_proc_exit [118] DebugFileOpen [162] SHMQueueElemInit [70] on_shmem_exit [119] DummyProcKill (gmon-start.c) [163] SHMQueueInit [198] parse_bool (gmon-start.c) [49] DynaHashAlloc (gmon-start.c) [164] SIBufferInit [80] parse_int (gmon-start.c) [120] EnableExceptionHandling [90] SInvalShmemSize [15] pfree [82] FindExec [78] SSDataBase (gmon-start.c) [199] pg_fdatasync [121] FlushBufferPool [165] ServerLoop (gmon-start.c) [200] pg_fsync [66] FreeFile [71] SetConfigOption [41] pgstat_beterm [122] FreeSpaceShmemSize [166] SetDataDir [201] pgstat_close_sockets [123] GUC_yy_create_buffer [167] SetRedoRecPtr [202] pgstat_init [83] GUC_yy_flex_alloc (gmon-start.c) [168] SetThisStartUpID [37] pgstat_ispgstat [84] GUC_yy_flush_buffer [43] ShmemAlloc [42] pgstat_send (gmon-start.c) [85] GUC_yy_get_next_buffer (gmon-start.c) [67] ShmemInitHash [203] pgstat_start [124] GUC_yy_get_previous_state (gmon-start.c) [59] ShmemInitStruct [204] pqinitmask [86] GUC_yy_init_buffer [169] ShutdownBufferPoolAccess (gmon-start.c) [50] pqsignal [75] GUC_yy_load_buffer_state [20] StartBufferIO (gmon-start.c) [205] proc_exit [36] GUC_yylex [27] StreamClose [35] read_to_eol (gmon-start.c) [125] GUC_yyrestart [34] StreamConnection [24] relpath [126] GUC_yywrap [91] StreamServerPort [206] reset_shared (gmon-start.c) [127] GetCurrentTransactionId [21] TerminateBufferIO (gmon-start.c) [207] save_ps_display_args [128] GetRedoRecPtr [170] TouchSocketLockFile [44] seg_alloc (gmon-start.c) [129] GetUndoRecPtr [171] UnlockBuffers [74] set_config_option [87] IgnoreSystemIndexes [22] UnpinBuffer [208] set_ps_display [130] InitBufTable [172] UpdateControlFile [209] shmem_exit [131] InitBufferPool [92] ValidateBinary (gmon-start.c) [210] smgrabort [132] InitBufferPoolAccess [93] ValidatePgVersion [25] smgrblindwrt [133] InitCommunication (gmon-start.c) [61] WriteCLOGPage (gmon-start.c) [211] smgrinit [134] InitDummyProcess [94] XLOGPathInit [212] smgrshutdown (gmon-start.c) [135] InitFreeList [173] XLOGShmemInit [213] smgrsync [136] InitFreeSpaceMap [174] XLOGShmemSize [60] string_hash [137] InitLocalBuffer [175] XLogFileInit (gmon-start.c) [26] tag_hash [138] InitLockTable [176] XLogFileOpen (gmon-start.c) [95] tokenize_file (gmon-start.c) [139] InitLocks [16] XLogFlush [140] InitProcGlobal [177] XLogInsert