explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XMiM

Settings
# exclusive inclusive rows x rows loops node
1. 3.768 585.013 ↓ 1.5 353 1

GroupAggregate (cost=3,436.77..3,441.61 rows=231 width=20) (actual time=579.227..585.013 rows=353 loops=1)

  • Group Key: fk_usuario
2. 7.770 581.245 ↓ 150.6 38,090 1

Sort (cost=3,436.77..3,437.40 rows=253 width=12) (actual time=579.193..581.245 rows=38,090 loops=1)

  • Sort Key: fk_usuario
  • Sort Method: quicksort Memory: 3322kB
3. 573.475 573.475 ↓ 150.6 38,090 1

Index Scan using idx_rastramento_detalhamento_data_hora_ocorrencia on "RastreamentoDetalhamento" (cost=0.56..3,426.67 rows=253 width=12) (actual time=0.124..573.475 rows=38,090 loops=1)

  • Index Cond: ((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))
  • Filter: (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: 89772
Planning time : 1.003 ms