feiyun0112
Honored Contributor

you can get time from metrics

"metrics": {
        "total_time_ms": 1000,
        "read_bytes": 1024,
        "rows_produced_count": 100000,
        "compilation_time_ms": 1000,
        "execution_time_ms": 1000,
        "read_remote_bytes": 1024,
        "write_remote_bytes": 1024,
        "read_cache_bytes": 1024,
        "spill_to_disk_bytes": 1024,
        "task_total_time_ms": 100000,
        "read_files_count": 1,
        "read_partitions_count": 1,
        "photon_total_time_ms": 1000,
        "rows_read_count": 10000,
        "result_fetch_time_ms": 100000,
        "network_sent_bytes": 1024,
        "result_from_cache": false,
        "pruned_bytes": 1024,
        "pruned_files_count": 1,
        "provisioning_queue_start_timestamp": 1595357087200,
        "overloading_queue_start_timestamp": 1595357087200,
        "query_compilation_start_timestamp": 1595357087200,
        "metadata_time_ms": 0,
        "planning_time_ms": 0,
        "query_execution_time_ms": 0,
        "planning_phases": [
          {}
        ]
      },