explain.depesz.com

PostgreSQL's explain analyze made readable

Result: w7Qc

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 77,716.673 ↑ 3.8 353 1

Finalize GroupAggregate (cost=8,658,593.70..8,659,316.63 rows=1,340 width=20) (actual time=77,712.093..77,716.673 rows=353 loops=1)

  • Group Key: fk_usuario
2. 0.000 77,720.403 ↑ 3.1 1,743 1

Gather Merge (cost=8,658,593.70..8,659,263.03 rows=5,360 width=20) (actual time=77,712.059..77,720.403 rows=1,743 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 12.195 388,561.995 ↑ 3.8 349 5

Partial GroupAggregate (cost=8,657,593.64..8,657,624.54 rows=1,340 width=20) (actual time=77,709.062..77,712.399 rows=349 loops=5)

  • Group Key: fk_usuario
4. 34.930 388,549.800 ↓ 4.4 7,618 5

Sort (cost=8,657,593.64..8,657,598.02 rows=1,750 width=12) (actual time=77,709.043..77,709.960 rows=7,618 loops=5)

  • Sort Key: fk_usuario
  • Sort Method: quicksort Memory: 537kB
5. 388,514.870 388,514.870 ↓ 4.4 7,618 5

Parallel Seq Scan on "RastreamentoDetalhamento" (cost=0.00..8,657,499.38 rows=1,750 width=12) (actual time=29,947.487..77,702.974 rows=7,618 loops=5)

  • Filter: ((data_hora_ocorrencia >= '2019-10-02 00:00:00-03'::timestamp with time zone) AND (data_hora_ocorrencia <= '2019-10-02 23:59:00-03'::timestamp with time zone) AND (fk_usuario = ANY ('{293,177,223,219,341,295,297,446,296,442,432,431,429,434,445,550,549,461,451,449,601,576,809,668,643,726,822,983,813,943,674,929,713,806,996,1000,1068,963,837,1091,799,1134,1114,1082,1299,597,881,1363,1106,1521,1370,1300,1343,1200,1655,1474,1629,1635,1642,1637,1614,1512,1617,1137,1786,1855,1813,1383,1435,1401,1971,2087,1372,1751,1746,1745,1657,1756,599,1744,1830,2092,1791,1755,1719,2100,1923,1892,1838,2161,2148,2123,2185,1851,2207,1764,2246,2257,2376,1274,2360,1849,2305,2464,2388,2349,2437,2486,2802,2476,2593,2788,2793,2609,2612,3003,2684,1901,2171,2621,2806,2552,1843,2613,2583,2709,2569,2537,2648,2653,2730,1680,2244,1890,2669,2061,2651,2492,1960,2737,1799,2783,2573,1740,2336,2607,2717,2683,2553,2979,2981,2857,2830,2807,3142,3025,2891,2957,2964,3288,3000,3289,3356,3019,3398,2963,1301,2866,2804,3244,3238,2685,2923,2834,2211,3355,2452,3291,2954,2972,2875,3351,3328,2944,2879,2943,3227,2642,3354,2766,3321,3480,2528,3392,3390,1991,3304,2869,3468,3490,3452,2940,3470,3286,2967,3465,3012,2858,3512,3617,3310,2428,3424,2996,3234,2921,3327,3047,3556,3036,3645,2251,3724,3986,4012,3985,3980,3549,4095,4152,3232,3667,3774,3837,4132,3229,3767,3721,3769,3783,3768,3813,3125,2876,1816,4004,2887,3644,4206,3842,4028,2865,3800,2889,3851,3975,2955,3002,3826,2313,3681,4077,2314,4006,3384,3656,4023,4212,3494,3711,3400,2359,4021,4069,3828,3836,3998,3316,3630,2677,4109,3722,3856,3730,2969,3593,4207,3806,2176,4147,1135,4317,4384,3466,3186,4470,3847,4426,3585,4319,4169,3679,4311,4294,4211,4262,757,4226,3825,4167,4307,4299,4409,4332,4222,1340,2724,4325,4333,3729,3208,4218,3743,4326,4371,4598,3976,4710,2327,4694,3052,4679,4701,4681,4698,4717,4714,4715,4116,4330,4331,4683,4527,4208,4263,4675,4203,4555,4537,4302,3997,4320,4536,4730,4718,4538,4561,4428,4351,2715,4641,4531,4624,4381,4619,4510,4615,4586,4587,4888,4840,4882,4838,3305,4841,4244,4879,4894,4803,4909,4908,4883,4774,4481,4137,4692,4842,2670,4558,4608,4686,4350,4891,5085,4777,3782,5096,4868,4870,4362,4915,4423,4877,4906,4790,4899,4973,4363,3495,3492,4977,5045,3714,5001,4791,5078,3615,5046,5073,5137,4957,5075,4542,5133,3194,5014,4553,5268,3633,4751}'::integer[])))
  • Rows Removed by Filter: 11273682
Planning time : 1.156 ms