Hit rate 75% · 565986 hits / 188224 misses · 7413 MB read from stores · 1522 MB on disk · 0 writes dropped
| Name | Calls | Total µs | Avg µs | % runtime |
|---|
| postgres_query | 9239 | 276668536 | 29945.72313 | 0.278414 |
| resolve_pending_variables_at_spacetime | 16 | 29041 | 1815.0625 | 0.000029 |
| postgres_acquire_connection | 9239 | 9236 | 0.999675 | 0.000009 |
| ts_request_series | 60 | 245984 | 4099.733333 | 0.000248 |
| dr_check_cache_for_var_grid | 60 | 56 | 0.933333 | 0 |
| dr_postgres_query_var_grid_info | 60 | 245643 | 4094.05 | 0.000247 |
| ds_get_data_from_cache | 2241 | 4309 | 1.922802 | 0.000004 |
| dr_query_postgres_for_maps | 866 | 36553451 | 42209.527714 | 0.036784 |
| dr_postgres_query_maps | 700 | 29231356 | 41759.08 | 0.029416 |
| inflight_handle_wait | 166 | 7178090 | 43241.506024 | 0.007223 |
| dr_postgres_query_maps_min_altitude_path | 532 | 19582746 | 36809.672932 | 0.019706 |
| dr_postgres_query_maps_nearest_altitude_path | 158 | 9599418 | 60755.810127 | 0.00966 |
| ds_wait_for_varmap_fetch | 1487 | 35143233 | 23633.64694 | 0.035365 |
| ds_fetch_data_url | 1292 | 303386676 | 234819.408669 | 0.305301 |
| blockstore_read_range | 187829 | 9526767015 | 50720.426638 | 9.586884 |
| ds_request_varmap | 1487 | 372195 | 250.29926 | 0.000375 |
| image_load_from_memory | 1487 | 10865039 | 7306.683927 | 0.010934 |
| ds_handle_fetch_varmap | 1487 | 367119192 | 246885.804976 | 0.369436 |
| ds_fetch_varmap | 1487 | 367112926 | 246881.591123 | 0.36943 |
| mappack_fetch_chunk | 209 | 61990135 | 296603.516746 | 0.062381 |
| ds_fetch_range | 203 | 58057897 | 285999.492611 | 0.058424 |
| mappack_read_head | 6 | 1129970 | 188328.333333 | 0.001137 |
| field_render_region | 158 | 46679750 | 295441.455696 | 0.046974 |
| parser | 515 | 459803 | 892.821359 | 0.000463 |
| load_column | 579014 | 16553181939 | 28588.569428 | 16.657638 |
| buffer_manager get | 5297750 | 33132593692 | 6254.087809 | 33.341672 |
| variable_map_get | 20 | 28837 | 1441.85 | 0.000029 |
| buffer_manager load_frame | 1697755 | 33139747558 | 19519.7467 | 33.348871 |
| resolver_query_map | 20 | 28806 | 1440.3 | 0.000029 |
| make_column | 396433 | 3872370 | 9.768031 | 0.003897 |
| resolver_query_maps | 20 | 28783 | 1439.15 | 0.000029 |
| read column bin | 51080 | 121487171 | 2378.370615 | 0.122254 |
| resolver_collect_maps | 178 | 35145682 | 197447.651685 | 0.035367 |
| read compact run bin | 345357 | 2551551639 | 7388.156716 | 2.567653 |
| resolver_request_maps | 812 | 35501084 | 43720.546798 | 0.035725 |
| mappack_select_tiles | 6 | 1143697 | 190616.166667 | 0.001151 |
| dr_check_cache_for_maps | 487 | 394 | 0.809035 | 0 |
| deserialize column | 396437 | 5831423 | 14.709583 | 0.005868 |
| load_seek_file | 349966 | 5371739429 | 15349.318017 | 5.405637 |
| eventstore_backfill_run_bytes | 1 | 19792 | 19792 | 0.00002 |
| eventstore_load | 1 | 20536 | 20536 | 0.000021 |
| plan_materialize_rasters | 158 | 46664941 | 295347.727848 | 0.046959 |
| resolve_variables_over_grids | 158 | 46664465 | 295344.71519 | 0.046959 |
| variable_maps_collect | 158 | 35146122 | 222443.810127 | 0.035368 |
| create_temporary_map | 142 | 130308 | 917.661972 | 0.000131 |
| prime_reproj_grids | 158 | 97480 | 616.962025 | 0.000098 |
| create_output_img | 142 | 5142 | 36.211268 | 0.000005 |
| variable_maps_request | 158 | 11281336 | 71400.860759 | 0.011353 |
| build_reproj_grid | 4 | 97387 | 24346.75 | 0.000098 |
| copy_extents_reprojected_bilinear | 4 | 10097 | 2524.25 | 0.00001 |
| copy_extents_bilinear | 1567 | 107540 | 68.627951 | 0.000108 |
| normalize_weighted_image | 142 | 5679 | 39.992958 | 0.000006 |
| variable_tree_load_ontologies | 5 | 54372 | 10874.4 | 0.000055 |
| variable_tree_load | 5 | 216918 | 43383.6 | 0.000218 |
| resolve_containing_map | 20 | 28862 | 1443.1 | 0.000029 |
| analyze | 16 | 29150 | 1821.875 | 0.000029 |
| create_response | 1245 | 6896 | 5.538956 | 0.000007 |
| json_write_string | 16 | 545 | 34.0625 | 0.000001 |
| datacache_run_eviction | 27 | 2641 | 97.814815 | 0.000003 |
| eventstore_backfill_run_event_spans | 1 | 17860 | 17860 | 0.000018 |
| resolve_variable_info | 220 | 2354 | 10.7 | 0.000002 |
| dr_has_cache_for_maps | 46 | 34 | 0.73913 | 0 |
| field_evaluate_sampled_series | 62 | 27023846 | 435868.483871 | 0.027194 |
| shepherd_evaluate_plan | 84 | 248455611 | 2957804.892857 | 0.250023 |
| shepherd_keyframes_for_segments | 6 | 168285091 | 28047515.166667 | 0.169347 |
| ontology segments | 77 | 33648 | 436.987013 | 0.000034 |
| paths prefetch indices | 6 | 532751 | 88791.833333 | 0.000536 |
| shepherd_request_index | 1657325 | 5403311 | 3.26026 | 0.005437 |
| shepherd_handle_index_fetch | 1656564 | 832928800 | 502.805083 | 0.838185 |
| paths collect entities | 6 | 165192491 | 27532081.833333 | 0.166235 |
| paths scan entities | 27600 | 165164759 | 5984.230399 | 0.166207 |
| paths sort entities | 6 | 54842 | 9140.333333 | 0.000055 |
| plan prefetch indices | 78 | 33834548 | 433776.25641 | 0.034048 |
| phase2_find_candidates | 4 | 2447920 | 611980 | 0.002463 |
| paths scan run | 13850 | 2375747 | 171.534079 | 0.002391 |
| paths thin tracks | 4 | 20776 | 5194 | 0.000021 |
| shepherd_evaluate_segment | 146532 | 46181322 | 315.162026 | 0.046473 |
| paths build results | 4 | 34719 | 8679.75 | 0.000035 |
| query columns | 446 | 36400290 | 81615 | 0.03663 |
| entity limit | 299 | 4636481 | 15506.625418 | 0.004666 |
| conditions | 446 | 73 | 0.163677 | 0 |
| time filter | 211 | 364517 | 1727.56872 | 0.000367 |
| shepherd_handle_column_fetch | 1574 | 17050781 | 10832.770648 | 0.017158 |
| materialize_results | 158 | 53499 | 338.601266 | 0.000054 |
| prep results | 158 | 225 | 1.424051 | 0 |
| materialize | 158 | 1969650 | 12466.139241 | 0.001982 |
| gather_column | 158 | 48765 | 308.639241 | 0.000049 |
| write_image_to_png_stream | 159 | 174027 | 1094.509434 | 0.000175 |
| image_create | 301 | 495 | 1.644518 | 0 |
| extent filter | 446 | 36028912 | 80782.313901 | 0.036256 |
| gather indices | 446 | 4870 | 10.919283 | 0.000005 |
| build_status_snapshot | 23 | 582644 | 25332.347826 | 0.000586 |
| status_inflight_fetches | 24 | 51 | 2.125 | 0 |
| logger | 5001 | 125773 | 25.14957 | 0.000127 |
| data_prefetch | 1 | 0 | 0 | 0 |
| handle_fetch | 1656582 | 1214836281 | 733.339057 | 1.222502 |
| status_postgres_query_stats | 23 | 424 | 18.434783 | 0 |
| init_worker | 42 | 205701 | 4897.642857 | 0.000207 |
| handle_work | 2183 | 19428292265 | 8899813.222629 | 19.550892 |
| varmap_fastpath_try_evaluate_region_nan | 16 | 2570 | 160.625 | 0.000003 |
| varmap_fastpath_try_evaluate_region | 142 | 9 | 0.06338 | 0 |
| serve_geometry | 14 | 8951058 | 639361.285714 | 0.009008 |
| evaluate_geometry | 14 | 8808475 | 629176.785714 | 0.008864 |
| serialize_results | 165 | 196244 | 1189.357576 | 0.000197 |
| dataregistry_get_geometry | 14 | 8808421 | 629172.928571 | 0.008864 |
| serialize_result_table | 84 | 275349 | 3277.964286 | 0.000277 |
| ds_wait_for_geometry_fetch | 13 | 7585670 | 583513.076923 | 0.007634 |
| ds_request_geometry | 13 | 126 | 9.692308 | 0 |
| sanitize rows | 1 | 1 | 1 | 0 |
| ds_handle_fetch_geometry | 13 | 7895294 | 607330.307692 | 0.007945 |
| sanitize paths | 83 | 22048 | 265.638554 | 0.000022 |
| serve_entities | 81 | 80650882 | 995689.901235 | 0.08116 |
| serve_tile | 158 | 46846237 | 296495.170886 | 0.047142 |
| list_dhash | 158 | 1366 | 8.64557 | 0.000001 |
| serve_paths | 6 | 168469329 | 28078221.5 | 0.169532 |
| serve_table | 1 | 64324 | 64324 | 0.000065 |
| serve_unified_dopesheet | 188 | 18911834713 | 100594865.494681 | 19.031175 |
| shepherd_event_time_buckets_ontology | 83 | 16226063262 | 195494738.096386 | 16.328455 |
| timescale_event_time_buckets_ontology | 77 | 7992 | 103.792208 | 0.000008 |
| dr_postgres_get_timeseries_dopesheet | 57 | 189518 | 3324.877193 | 0.000191 |
| dr_postgres_get_geometry_dopesheet | 11 | 34886 | 3171.454545 | 0.000035 |
| availability_query | 18 | 2258024 | 125445.777778 | 0.002272 |
| dr_postgres_get_variable_dopesheet | 57 | 3055702 | 53608.807018 | 0.003075 |
| shepherd_event_time_buckets | 18 | 2679677233 | 148870957.388889 | 2.696587 |
| http_handle_request_in_worker | 2183 | 19398667298 | 8886242.463582 | 19.52108 |
| http_handle_request | 2182 | 19090000405 | 8748854.447754 | 19.210465 |
| http_clean_up | 2007 | 558 | 0.278027 | 0.000001 |
| http_send_response | 2007 | 1893573 | 943.484305 | 0.001906 |
| endpoint_stats_add_sample | 2007 | 2577 | 1.284006 | 0.000003 |
| usage_stats_record | 1245 | 8356525 | 6712.068273 | 0.008409 |
| query_log_flush | 2007 | 1858 | 0.92576 | 0.000002 |
| explain_log_flush | 2007 | 4220 | 2.102641 | 0.000004 |
| free_request | 2007 | 13644 | 6.798206 | 0.000014 |
| http_handle_request_in_worker_statistics | 2007 | 818 | 0.407573 | 0.000001 |
| serve_instance_storage | 123 | 118963441 | 967182.447154 | 0.119714 |
| serve_tstable | 6 | 27049891 | 4508315.166667 | 0.027221 |
| evaluate_tstable_plan | 6 | 27046440 | 4507740 | 0.027217 |
| fill_tstable_result | 6 | 30 | 5 | 0 |
| field_sample_series | 64 | 27024803 | 422262.546875 | 0.027195 |
| root | 23 | 604844 | 26297.565217 | 0.000609 |
| serve_version | 1 | 8 | 8 | 0 |
| serve_variable_schema | 4 | 239 | 59.75 | 0 |
| serve_variable_info | 1 | 26 | 26 | 0 |
| serve_operator_list | 6 | 225 | 37.5 | 0 |
| serve_function_list | 7 | 10222 | 1460.285714 | 0.00001 |
| serve_variable_list | 284 | 1185685 | 4174.947183 | 0.001193 |
| serve_dataset_list | 137 | 1378931 | 10065.189781 | 0.001388 |
| compression_middleware | 2003 | 21924983 | 10946.072391 | 0.022063 |
| serve_eval | 3 | 324 | 108 | 0 |
| Hash | Query | Location | Count | Min µs | Max µs | Mean µs | Stddev µs |
|---|
475ade56 | LoadOntologicalColumns | modality/events/postgres.jai:552 | 9 | 1398 | 5418 | 2401.777778 | 1184.095412 |
d580edaa | QueryGridMinAltitude | resolvers/postgres.jai:682 | 60 | 1672 | 26647 | 4083.033333 | 6023.520031 |
a33a026f | LoadAllRunMetadata | modality/events/postgres.jai:339 | 2 | 2818 | 57707 | 30262.5 | 38812.384113 |
d925b6fc | UsageRollupPrune | resolvers/postgres.jai:2184 | 28 | 1246 | 3554 | 1908.5 | 380.968211 |
| | resolvers/postgres.jai:3535 | 11 | 2029 | 11027 | 3157.636364 | 2673.759461 |
| | resolvers/postgres.jai:3485 | 8 | 1698 | 17999 | 5027.125 | 5884.695852 |
| | resolvers/postgres.jai:2686 | 123 | 103191 | 174990 | 118125.609756 | 12446.062178 |
| | resolvers/postgres.jai:55 | 1 | 1420 | 1420 | 1420 | 0 |
| | ontology/catalog.jai:447 | 5 | 2452 | 6302 | 3400.6 | 1628.142746 |
| | ontology/catalog.jai:485 | 5 | 3494 | 7907 | 4716.2 | 1877.612234 |
904106ea | OntologySources | ontology/sources.jai:41 | 241 | 1040 | 5761 | 1894.340249 | 572.041432 |
b4f0fa02 | EngineHeartbeatPrune | resolvers/postgres.jai:2566 | 331 | 994 | 7561 | 1646.501511 | 633.905793 |
c65d5618 | UsageVariablePrune | resolvers/postgres.jai:2381 | 28 | 983 | 3113 | 1507.5 | 349.210379 |
| | resolvers/postgres.jai:31 | 1 | 2356491 | 2356491 | 2356491 | 0 |
b5c5cb48 | GetSources | resolvers/postgres.jai:296 | 137 | 2349 | 28781 | 4820.642336 | 2754.56154 |
d257976a | QueryMapsWithNearestAltitude | resolvers/postgres.jai:561 | 158 | 2286 | 316106 | 60739.044304 | 46356.786491 |
e086f07a | SaveOntologicalIndices | modality/events/postgres.jai:628 | 1 | 24125 | 24125 | 24125 | 0 |
| | resolvers/postgres.jai:3390 | 57 | 1784 | 780643 | 53587.070175 | 142873.178946 |
2543e259 | LoadOntologyConformance | ontology/catalog.jai:513 | 5 | 1410 | 5421 | 2301.8 | 1745.182569 |
f3c9bc60 | QueryMapsWithMinAltitude | resolvers/postgres.jai:555 | 532 | 9868 | 135783 | 36798.176692 | 26812.163147 |
aec9b30b | UsageRollupUpsert | resolvers/postgres.jai:2165 | 60 | 3076 | 31063 | 10309.083333 | 8734.835107 |
0973cac4 | LoadAllIndexMetadata | modality/events/postgres.jai:357 | 2 | 4175 | 824559 | 414367 | 580099.089577 |
| | resolvers/postgres.jai:2686 | 123 | 121212 | 229016 | 143338.747967 | 20359.270309 |
e9eb3860 | UnsizedRuns | modality/events/postgres.jai:762 | 1 | 19775 | 19775 | 19775 | 0 |
| | modality/events/timescale/shapes.jai:43 | 4 | 1907 | 10021 | 4416.25 | 3844.392572 |
c108f25b | UsageVariableUpsert | resolvers/postgres.jai:2369 | 4 | 3395 | 4265 | 3643 | 417.662543 |
| | ontology/catalog.jai:165 | 1 | 1481 | 1481 | 1481 | 0 |
2b56381a | UnspannedRuns | modality/events/postgres.jai:696 | 1 | 17839 | 17839 | 17839 | 0 |
| | resolvers/postgres.jai:4267 | 1 | 1825 | 1825 | 1825 | 0 |
4b9f47ee | LoadOntologicalIndices | modality/events/postgres.jai:655 | 10 | 1105 | 5230 | 2139 | 1558.367379 |
| | server/status_snapshot.jai:560 | 23 | 17552 | 43250 | 25099.217391 | 7533.615599 |
| | availability/postgres.jai:461 | 14 | 2326 | 7640 | 3577.785714 | 1467.77462 |
2861a6fd | EngineHeartbeatUpsert | resolvers/postgres.jai:2542 | 6615 | 3173 | 52574 | 17843.725019 | 8662.411521 |
| | resolvers/postgres.jai:2686 | 123 | 55003 | 131990 | 70022.788618 | 14636.064135 |
| | resolvers/postgres.jai:2041 | 1 | 1666 | 1666 | 1666 | 0 |
86cf446a | CheckTable | resolvers/postgres.jai:4219 | 10 | 2779 | 5664 | 3851.4 | 1102.89651 |
62967339 | LoadVariableTree | resolvers/variables.jai:680 | 5 | 39066 | 47115 | 42008.8 | 3629.883428 |
3be4cc38 | LoadSegments | modality/events/postgres.jai:55 | 1 | 17074 | 17074 | 17074 | 0 |
| | resolvers/postgres.jai:3650 | 57 | 1333 | 10866 | 3305.912281 | 2358.310323 |
| | resolvers/postgres.jai:2686 | 123 | 32711 | 66082 | 39416.03252 | 6273.823269 |
| | availability/postgres.jai:177 | 71 | 1407 | 6040 | 2324.084507 | 741.117009 |
| | resolvers/postgres.jai:2686 | 123 | 268816 | 422560 | 304153.463415 | 29716.295882 |
| | resolvers/postgres.jai:2686 | 123 | 254121 | 420926 | 291636.569106 | 32836.09279 |