DC2 - Details for Query 194

Details for Query 194

Submitted Time: 2025/11/19 10:49:05
Duration: 0.1 s
Succeeded Jobs: 297

Show the Stage ID and Task ID that corresponds to the max metric

digraph G { 0 [labelType="html" label=" CollectLimit "]; subgraph cluster1 { isCluster="true"; label="WholeStageCodegen (2)\n \nduration: 24 ms"; 2 [labelType="html" label=" Project "]; } 3 [labelType="html" label="Generate number of output rows: 4"]; subgraph cluster4 { isCluster="true"; label="WholeStageCodegen (1)\n \nduration: 39 ms"; 5 [labelType="html" label=" Project "]; } 6 [labelType="html" label="Scan json number of output rows: 1 number of files read: 1 metadata time: 0 ms size of files read: 2.4 KiB"]; 2->0; 3->2; 5->3; 6->5; }

CollectLimit 500

Project [b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578 AS layer_name#81586, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L AS nb_results#81596L, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.acces AS acces#81645, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.adresse AS adresse#81661, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.chien AS chien#81678, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.code_insee AS code_insee#81696L, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.commune AS commune#81715]

WholeStageCodegen (2)

Generate explode(6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607), [b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L], true, [6f36fa10-dfb6-4f10-9d27-8f673df15184#81619]

Project [layer_name#81567 AS b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, nb_results#81568L AS 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L, values#81571 AS 6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607]

WholeStageCodegen (1)

FileScan json [layer_name#81567,nb_results#81568L,values#81571] Batched: false, DataFilters: [], Format: JSON, Location: InMemoryFileIndex[file:/data/input/depot/json/execution/87C8FB84_80AE_4C66_BC5E_601B88DF691E/curr..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<layer_name:string,nb_results:bigint,values:array<struct<acces:string,adresse:string,ann_ou...

Details

== Parsed Logical Plan ==
GlobalLimit 500
+- LocalLimit 500
   +- Project [b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578 AS layer_name#81586, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L AS nb_results#81596L, dee84119-cc2e-468f-9c1e-0bfe0ac8fc72#81631 AS acces#81645, 41287eb1-8ede-49c3-94e1-a601aeaebad6#81646 AS adresse#81661, 9f6bc87d-bdbf-419d-ac40-f617e73af183#81662 AS chien#81678, b235fe1d-1a25-4cb7-9b17-c46d9fe05638#81679L AS code_insee#81696L, 2beaeec2-041d-4cf8-bb62-068a21e1afb3#81697 AS commune#81715]
      +- Project [fields#81566, layer_name#81567, nb_results#81568L, table_alias#81569, table_href#81570, values#81571, b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L, f5324355-d87e-4dc9-bf78-78f9b4e72af1#81597, 6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619, dee84119-cc2e-468f-9c1e-0bfe0ac8fc72#81631, 41287eb1-8ede-49c3-94e1-a601aeaebad6#81646, 9f6bc87d-bdbf-419d-ac40-f617e73af183#81662, b235fe1d-1a25-4cb7-9b17-c46d9fe05638#81679L, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.commune AS 2beaeec2-041d-4cf8-bb62-068a21e1afb3#81697]
         +- Project [fields#81566, layer_name#81567, nb_results#81568L, table_alias#81569, table_href#81570, values#81571, b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L, f5324355-d87e-4dc9-bf78-78f9b4e72af1#81597, 6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619, dee84119-cc2e-468f-9c1e-0bfe0ac8fc72#81631, 41287eb1-8ede-49c3-94e1-a601aeaebad6#81646, 9f6bc87d-bdbf-419d-ac40-f617e73af183#81662, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.code_insee AS b235fe1d-1a25-4cb7-9b17-c46d9fe05638#81679L]
            +- Project [fields#81566, layer_name#81567, nb_results#81568L, table_alias#81569, table_href#81570, values#81571, b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L, f5324355-d87e-4dc9-bf78-78f9b4e72af1#81597, 6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619, dee84119-cc2e-468f-9c1e-0bfe0ac8fc72#81631, 41287eb1-8ede-49c3-94e1-a601aeaebad6#81646, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.chien AS 9f6bc87d-bdbf-419d-ac40-f617e73af183#81662]
               +- Project [fields#81566, layer_name#81567, nb_results#81568L, table_alias#81569, table_href#81570, values#81571, b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L, f5324355-d87e-4dc9-bf78-78f9b4e72af1#81597, 6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619, dee84119-cc2e-468f-9c1e-0bfe0ac8fc72#81631, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.adresse AS 41287eb1-8ede-49c3-94e1-a601aeaebad6#81646]
                  +- Project [fields#81566, layer_name#81567, nb_results#81568L, table_alias#81569, table_href#81570, values#81571, b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L, f5324355-d87e-4dc9-bf78-78f9b4e72af1#81597, 6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.acces AS dee84119-cc2e-468f-9c1e-0bfe0ac8fc72#81631]
                     +- Project [fields#81566, layer_name#81567, nb_results#81568L, table_alias#81569, table_href#81570, values#81571, b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L, f5324355-d87e-4dc9-bf78-78f9b4e72af1#81597, 6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619]
                        +- Generate explode(6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607), true, [6f36fa10-dfb6-4f10-9d27-8f673df15184#81619]
                           +- Project [fields#81566, layer_name#81567, nb_results#81568L, table_alias#81569, table_href#81570, values#81571, b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L, f5324355-d87e-4dc9-bf78-78f9b4e72af1#81597, values#81571 AS 6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607]
                              +- Project [fields#81566, layer_name#81567, nb_results#81568L, table_alias#81569, table_href#81570, values#81571, b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L, values#81571 AS f5324355-d87e-4dc9-bf78-78f9b4e72af1#81597]
                                 +- Project [fields#81566, layer_name#81567, nb_results#81568L, table_alias#81569, table_href#81570, values#81571, b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, nb_results#81568L AS 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L]
                                    +- Project [fields#81566, layer_name#81567, nb_results#81568L, table_alias#81569, table_href#81570, values#81571, layer_name#81567 AS b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578]
                                       +- Relation[fields#81566,layer_name#81567,nb_results#81568L,table_alias#81569,table_href#81570,values#81571] json

== Analyzed Logical Plan ==
layer_name: string, nb_results: bigint, acces: string, adresse: string, chien: string, code_insee: bigint, commune: string
GlobalLimit 500
+- LocalLimit 500
   +- Project [b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578 AS layer_name#81586, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L AS nb_results#81596L, dee84119-cc2e-468f-9c1e-0bfe0ac8fc72#81631 AS acces#81645, 41287eb1-8ede-49c3-94e1-a601aeaebad6#81646 AS adresse#81661, 9f6bc87d-bdbf-419d-ac40-f617e73af183#81662 AS chien#81678, b235fe1d-1a25-4cb7-9b17-c46d9fe05638#81679L AS code_insee#81696L, 2beaeec2-041d-4cf8-bb62-068a21e1afb3#81697 AS commune#81715]
      +- Project [fields#81566, layer_name#81567, nb_results#81568L, table_alias#81569, table_href#81570, values#81571, b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L, f5324355-d87e-4dc9-bf78-78f9b4e72af1#81597, 6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619, dee84119-cc2e-468f-9c1e-0bfe0ac8fc72#81631, 41287eb1-8ede-49c3-94e1-a601aeaebad6#81646, 9f6bc87d-bdbf-419d-ac40-f617e73af183#81662, b235fe1d-1a25-4cb7-9b17-c46d9fe05638#81679L, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.commune AS 2beaeec2-041d-4cf8-bb62-068a21e1afb3#81697]
         +- Project [fields#81566, layer_name#81567, nb_results#81568L, table_alias#81569, table_href#81570, values#81571, b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L, f5324355-d87e-4dc9-bf78-78f9b4e72af1#81597, 6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619, dee84119-cc2e-468f-9c1e-0bfe0ac8fc72#81631, 41287eb1-8ede-49c3-94e1-a601aeaebad6#81646, 9f6bc87d-bdbf-419d-ac40-f617e73af183#81662, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.code_insee AS b235fe1d-1a25-4cb7-9b17-c46d9fe05638#81679L]
            +- Project [fields#81566, layer_name#81567, nb_results#81568L, table_alias#81569, table_href#81570, values#81571, b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L, f5324355-d87e-4dc9-bf78-78f9b4e72af1#81597, 6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619, dee84119-cc2e-468f-9c1e-0bfe0ac8fc72#81631, 41287eb1-8ede-49c3-94e1-a601aeaebad6#81646, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.chien AS 9f6bc87d-bdbf-419d-ac40-f617e73af183#81662]
               +- Project [fields#81566, layer_name#81567, nb_results#81568L, table_alias#81569, table_href#81570, values#81571, b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L, f5324355-d87e-4dc9-bf78-78f9b4e72af1#81597, 6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619, dee84119-cc2e-468f-9c1e-0bfe0ac8fc72#81631, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.adresse AS 41287eb1-8ede-49c3-94e1-a601aeaebad6#81646]
                  +- Project [fields#81566, layer_name#81567, nb_results#81568L, table_alias#81569, table_href#81570, values#81571, b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L, f5324355-d87e-4dc9-bf78-78f9b4e72af1#81597, 6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.acces AS dee84119-cc2e-468f-9c1e-0bfe0ac8fc72#81631]
                     +- Project [fields#81566, layer_name#81567, nb_results#81568L, table_alias#81569, table_href#81570, values#81571, b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L, f5324355-d87e-4dc9-bf78-78f9b4e72af1#81597, 6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619]
                        +- Generate explode(6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607), true, [6f36fa10-dfb6-4f10-9d27-8f673df15184#81619]
                           +- Project [fields#81566, layer_name#81567, nb_results#81568L, table_alias#81569, table_href#81570, values#81571, b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L, f5324355-d87e-4dc9-bf78-78f9b4e72af1#81597, values#81571 AS 6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607]
                              +- Project [fields#81566, layer_name#81567, nb_results#81568L, table_alias#81569, table_href#81570, values#81571, b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L, values#81571 AS f5324355-d87e-4dc9-bf78-78f9b4e72af1#81597]
                                 +- Project [fields#81566, layer_name#81567, nb_results#81568L, table_alias#81569, table_href#81570, values#81571, b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, nb_results#81568L AS 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L]
                                    +- Project [fields#81566, layer_name#81567, nb_results#81568L, table_alias#81569, table_href#81570, values#81571, layer_name#81567 AS b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578]
                                       +- Relation[fields#81566,layer_name#81567,nb_results#81568L,table_alias#81569,table_href#81570,values#81571] json

== Optimized Logical Plan ==
GlobalLimit 500
+- LocalLimit 500
   +- Project [b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578 AS layer_name#81586, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L AS nb_results#81596L, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.acces AS acces#81645, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.adresse AS adresse#81661, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.chien AS chien#81678, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.code_insee AS code_insee#81696L, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.commune AS commune#81715]
      +- Generate explode(6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607), [2], true, [6f36fa10-dfb6-4f10-9d27-8f673df15184#81619]
         +- Project [layer_name#81567 AS b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, nb_results#81568L AS 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L, values#81571 AS 6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607]
            +- Relation[fields#81566,layer_name#81567,nb_results#81568L,table_alias#81569,table_href#81570,values#81571] json

== Physical Plan ==
CollectLimit 500
+- *(2) Project [b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578 AS layer_name#81586, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L AS nb_results#81596L, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.acces AS acces#81645, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.adresse AS adresse#81661, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.chien AS chien#81678, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.code_insee AS code_insee#81696L, 6f36fa10-dfb6-4f10-9d27-8f673df15184#81619.commune AS commune#81715]
   +- Generate explode(6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607), [b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L], true, [6f36fa10-dfb6-4f10-9d27-8f673df15184#81619]
      +- *(1) Project [layer_name#81567 AS b0511af5-b0c8-41b7-a97f-7b19de4c5e28#81578, nb_results#81568L AS 21046651-ddc4-40d5-830b-caf62ebae2f5#81587L, values#81571 AS 6789ef0a-371e-40db-a8d1-5a3e10a4b79d#81607]
         +- FileScan json [layer_name#81567,nb_results#81568L,values#81571] Batched: false, DataFilters: [], Format: JSON, Location: InMemoryFileIndex[file:/data/input/depot/json/execution/87C8FB84_80AE_4C66_BC5E_601B88DF691E/curr..., PartitionFilters: [], PushedFilters: [], ReadSchema: struct<layer_name:string,nb_results:bigint,values:array<struct<acces:string,adresse:string,ann_ou...