perf-report.txt

text/plain

Filename: perf-report.txt
Type: text/plain
Part: 0
Message: Re: Problem with declarative partitioning and COPY FROM
-   91.70%     4.59%  postgres         postgres                    [.] RelationBuildPartitionDesc
   - 87.10% RelationBuildPartitionDesc
      - 59.36% stringToNode
         - 59.28% nodeRead
            - 58.85% parseNodeString
               - 56.15% _readPartitionBoundSpec
                  - 50.00% nodeRead
                     - 46.86% nodeRead
                        - 46.27% parseNodeString
                           - 40.95% _readPartitionRangeDatum
                              - 35.72% nodeRead
                                 - 34.69% parseNodeString
                                    - 33.34% _readConst
                                         20.44% pg_strtok
                                       - 9.88% readDatum
                                            5.65% pg_strtok
                                          - 3.01% atoi
                                               2.83% __GI_____strtoll_l_internal
                                       - 1.00% MemoryContextAllocZeroAligned
                                            AllocSetAlloc
                                       - 0.60% atoi
                                            0.57% __GI_____strtoll_l_internal
                                         0.55% __GI_____strtoull_l_internal
                                      0.80% pg_strtok
                                   0.55% pg_strtok
                                3.76% pg_strtok
                              - 1.18% MemoryContextAllocZeroAligned
                                   AllocSetAlloc
                             2.31% pg_strtok
                             0.70% __memcmp_sse4_1
                     - 1.40% lappend
                        - new_list
                           - 1.16% palloc
                                0.98% AllocSetAlloc
                       0.90% pg_strtok
                    4.41% pg_strtok
                  - 1.55% MemoryContextAllocZeroAligned
                     - AllocSetAlloc
                        - 0.78% malloc
                           - _int_malloc
                              - 0.60% page_fault
                                 - 0.60% do_page_fault
                                    - 0.58% __do_page_fault
                                         0.52% handle_mm_fault
                 1.21% pg_strtok
      - 7.00% SearchSysCache
         - 6.84% SearchCatCache
              0.76% heap_getsysattr
      - 5.31% make_one_range_bound
         - 2.33% palloc0
              1.47% AllocSetAlloc
           0.91% list_head
      - 4.75% SysCacheGetAttr
           nocachegetattr
      - 4.02% find_inheritance_children
         - 3.34% systable_getnext
            - 3.27% index_getnext
               - 2.11% index_fetch_heap
                    0.88% LockBuffer
                    0.82% heap_hot_search_buffer
               - 1.04% index_getnext_tid
                  - 0.92% btgettuple
                     - _bt_next
                        - _bt_steppage
                           - 0.72% _bt_readpage
                                0.57% _bt_checkkeys
      - 3.63% text_to_cstring
           2.08% __memmove_avx_unaligned_erms
         - 1.29% palloc
            - AllocSetAlloc
               - 0.83% malloc
                  - _int_malloc
                     - 0.63% page_fault
                        - 0.63% do_page_fault
                           - 0.62% __do_page_fault
                                0.57% handle_mm_fault
      - 1.02% qsort_arg
         - 0.88% qsort_partition_rbound_cmp
              0.69% partition_rbound_cmp
        0.50% lappend
   - 4.59% _start
        __libc_start_main
        startup_hacks
        PostmasterMain
        ServerLoop
        BackendStartup
        ExitPostmaster
        PostgresMain
        exec_simple_query
        PortalRun
        PortalRunMulti
        PortalRunUtility
        ProcessUtility
        standard_ProcessUtility
        ProcessUtilitySlow
        ExecDropStmt
        RemoveObjects
        performMultipleDeletions
        deleteObjectsInList
        deleteOneObject
        doDeletion
        heap_drop_with_catalog
        heap_open
        relation_open
        RelationIdGetRelation
        RelationBuildDesc
        RelationBuildPartitionDesc