explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ujha

Settings
# exclusive inclusive rows x rows loops node
1. 975.407 1,000.015 ↑ 1.1 39,999 1

Gather (cost=19,793.85..96,234.64 rows=45,012 width=93) (actual time=44.215..1,000.015 rows=39,999 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.000 24.608 ↑ 1.4 13,333 3

Parallel Bitmap Heap Scan on pre_ocorrencia (cost=18,793.85..90,733.44 rows=18,755 width=93) (actual time=10.763..24.608 rows=13,333 loops=3)

  • Recheck Cond: (((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'EXCESSO_RPM'::text) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone)) OR ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'BANGUELA'::text) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone)) OR ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'DISTRACAO_MOTORISTA'::text) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone)) OR ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'CURVA_BRUSCA'::text) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone)) OR ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'EXCESSO_VELOCIDADE_BAIXO'::text) AND (velocidade >= 40) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone)) OR ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'EXCESSO_VELOCIDADE_MEDIO'::text) AND (velocidade >= 60) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone)) OR ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'EXCESSO_VELOCIDADE_ALTO'::text) AND (velocidade >= 70) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone)) OR ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'DISTANCIA_PERIGOSA'::text) AND (velocidade >= 50) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone)) OR ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'FADIGA_MOTORISTA'::text) AND (velocidade >= 40) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone)) OR ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'ACELERACAO_BRUSCA'::text) AND (velocidade >= 40) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone)) OR ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'FREADA_BRUSCA'::text) AND (velocidade >= 40) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone)) OR ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'EXCESSO_VELOCIDADE_POR_VIA_ALTO'::text) AND (velocidade >= 80) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone)) OR ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'EXCESSO_VELOCIDADE_POR_VIA_BAIXO'::text) AND (velocidade >= 40) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone)) OR ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'EXCESSO_VELOCIDADE_POR_VIA_MEDIO'::text) AND (velocidade >= 50) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone)))
  • Filter: ((((tipo_alerta)::text = 'EXCESSO_RPM'::text) AND (velocidade >= 0)) OR (((tipo_alerta)::text = 'BANGUELA'::text) AND (velocidade >= 0)) OR (((tipo_alerta)::text = 'DISTRACAO_MOTORISTA'::text) AND (velocidade >= 0)) OR (((tipo_alerta)::text = 'CURVA_BRUSCA'::text) AND (velocidade >= 0)) OR (((tipo_alerta)::text = 'EXCESSO_VELOCIDADE_BAIXO'::text) AND (velocidade >= 40)) OR (((tipo_alerta)::text = 'EXCESSO_VELOCIDADE_MEDIO'::text) AND (velocidade >= 60)) OR (((tipo_alerta)::text = 'EXCESSO_VELOCIDADE_ALTO'::text) AND (velocidade >= 70)) OR (((tipo_alerta)::text = 'DISTANCIA_PERIGOSA'::text) AND (velocidade >= 50)) OR (((tipo_alerta)::text = 'FADIGA_MOTORISTA'::text) AND (velocidade >= 40)) OR (((tipo_alerta)::text = 'ACELERACAO_BRUSCA'::text) AND (velocidade >= 40)) OR (((tipo_alerta)::text = 'FREADA_BRUSCA'::text) AND (velocidade >= 40)) OR (((tipo_alerta)::text = 'EXCESSO_VELOCIDADE_POR_VIA_ALTO'::text) AND (velocidade >= 80)) OR (((tipo_alerta)::text = 'EXCESSO_VELOCIDADE_POR_VIA_BAIXO'::text) AND (velocidade >= 40)) OR (((tipo_alerta)::text = 'EXCESSO_VELOCIDADE_POR_VIA_MEDIO'::text) AND (velocidade >= 50)))
  • Heap Blocks: exact=9132
3. 0.012 30.212 ↓ 0.0 0 1

BitmapOr (cost=18,793.85..18,793.85 rows=50,306 width=0) (actual time=30.212..30.212 rows=0 loops=1)

4. 8.519 8.519 ↑ 1.2 32,737 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_dthr (cost=0.00..1,808.72 rows=37,815 width=0) (actual time=8.519..8.519 rows=32,737 loops=1)

  • Index Cond: ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'EXCESSO_RPM'::text) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone))
5. 1.832 1.832 ↑ 1.3 4,886 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_dthr (cost=0.00..1,333.70 rows=6,264 width=0) (actual time=1.832..1.832 rows=4,886 loops=1)

  • Index Cond: ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'BANGUELA'::text) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone))
6. 1.167 1.167 ↓ 10.5 2,073 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_dthr (cost=0.00..1,243.61 rows=198 width=0) (actual time=1.167..1.167 rows=2,073 loops=1)

  • Index Cond: ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'DISTRACAO_MOTORISTA'::text) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone))
7. 0.727 0.727 ↑ 3.7 53 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_dthr (cost=0.00..1,243.61 rows=198 width=0) (actual time=0.727..0.727 rows=53 loops=1)

  • Index Cond: ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'CURVA_BRUSCA'::text) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone))
8. 2.142 2.142 ↓ 0.0 0 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_vel_dthr (cost=0.00..1,253.85 rows=139 width=0) (actual time=2.142..2.142 rows=0 loops=1)

  • Index Cond: ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'EXCESSO_VELOCIDADE_BAIXO'::text) AND (velocidade >= 40) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone))
9. 1.848 1.848 ↓ 0.0 0 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_vel_dthr (cost=0.00..1,249.07 rows=107 width=0) (actual time=1.848..1.848 rows=0 loops=1)

  • Index Cond: ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'EXCESSO_VELOCIDADE_MEDIO'::text) AND (velocidade >= 60) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone))
10. 2.086 2.086 ↓ 0.0 0 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_vel_dthr (cost=0.00..1,249.07 rows=93 width=0) (actual time=2.086..2.086 rows=0 loops=1)

  • Index Cond: ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'EXCESSO_VELOCIDADE_ALTO'::text) AND (velocidade >= 70) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone))
11. 2.052 2.052 ↑ 1.1 107 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_vel_dthr (cost=0.00..1,253.85 rows=123 width=0) (actual time=2.052..2.052 rows=107 loops=1)

  • Index Cond: ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'DISTANCIA_PERIGOSA'::text) AND (velocidade >= 50) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone))
12. 1.875 1.875 ↑ 17.4 8 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_vel_dthr (cost=0.00..1,253.85 rows=139 width=0) (actual time=1.875..1.875 rows=8 loops=1)

  • Index Cond: ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'FADIGA_MOTORISTA'::text) AND (velocidade >= 40) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone))
13. 1.524 1.524 ↑ 13.3 116 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_vel_dthr (cost=0.00..1,401.95 rows=1,548 width=0) (actual time=1.524..1.524 rows=116 loops=1)

  • Index Cond: ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'ACELERACAO_BRUSCA'::text) AND (velocidade >= 40) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone))
14. 1.439 1.439 ↑ 175.9 19 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_vel_dthr (cost=0.00..1,588.27 rows=3,342 width=0) (actual time=1.439..1.439 rows=19 loops=1)

  • Index Cond: ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'FREADA_BRUSCA'::text) AND (velocidade >= 40) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone))
15. 1.777 1.777 ↓ 0.0 0 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_vel_dthr (cost=0.00..1,249.07 rows=77 width=0) (actual time=1.777..1.777 rows=0 loops=1)

  • Index Cond: ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'EXCESSO_VELOCIDADE_POR_VIA_ALTO'::text) AND (velocidade >= 80) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone))
16. 1.638 1.638 ↓ 0.0 0 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_vel_dthr (cost=0.00..1,253.85 rows=139 width=0) (actual time=1.638..1.638 rows=0 loops=1)

  • Index Cond: ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'EXCESSO_VELOCIDADE_POR_VIA_BAIXO'::text) AND (velocidade >= 40) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone))
17. 1.574 1.574 ↓ 0.0 0 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_vel_dthr (cost=0.00..1,253.85 rows=123 width=0) (actual time=1.574..1.574 rows=0 loops=1)

  • Index Cond: ((veiculo_uo_id = ANY ('{287,288,326,399,400,420,421,482,842,874,875,876,877,882,885,886,888,889,890,892,894,895,899,900,903,904,905,906,907,908,909,923,924,931,932,933,936,937,938,952,953,954,955,956,957,958,959,960,961,962,964,965,967,968,969,970,972,973,977,980,985,987,988,990,993,995,999,1000,1001,1002,1006,1007,1008,1009,1010,1011,1012,1013,1014,1021,1022,1023,1024,1025,1026,1027,1028,1029,1030,1032,1037,1039,1040,1041,1042,1043,1044,1053,1054,1055,1056,1057,1058,1059,1060,1061,1062,1063,1065,1066,1067,1069,1070,1071,1072,1077,1078,1080,1084,1085,1086,1087,1088,1090,1091,1092,1093,1096,1097,1098,1101,1102,1104,1109,1110,1111,1112,1116,1120,1131,1134,1135,1136,1137,1139,1140,1141,1153,1158,1160,1161,1188,1193,1232,1236,1246,1256,1268,1281,1294,1295,1296,1297,1298,1299,1300,1301,1302,1303,1373,1382,2294,2296,2302,2315,2320,2345,2349,2372,2373,2376,2382,2392,2393,2394,2401,2420,2435,2486,2570,2594,2631,2636,2637,2671,2672,2706,2789,2790,2791,2792,2793,2794,2795,2801,2807,2808,2809,2810,2811,2813,2814,2815,2816,2817,2830,2885,2892,2895,2904,2961,2962,2970,3165,3204,3206,3395,3418,3419,3449,3547,3560,3567,3575,3579,3599,3601,3603,3604,3608,3626,3720,3726,3741,3747,3756,3758,3794,3800,3802,3804,3848,3991,4114,4175,4215,4259,4260,4261,4264,4305,4319,4324,4350,4351,4354,4358,4397,4398,4405,4410,4355,4355}'::bigint[])) AND ((tipo_alerta)::text = 'EXCESSO_VELOCIDADE_POR_VIA_MEDIO'::text) AND (velocidade >= 50) AND (datahora >= '2019-05-06 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-06 23:59:59-03'::timestamp with time zone))
Planning time : 1.827 ms
Execution time : 1,008.672 ms