explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hJ9c

Settings
# exclusive inclusive rows x rows loops node
1. 107.545 136.932 ↓ 1.1 15,507 3

Parallel Bitmap Heap Scan on pre_ocorrencia (cost=18,575.68..82,139.80 rows=13,744 width=93) (actual time=22.620..45.644 rows=15,507 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 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=1652
2. 0.011 29.387 ↓ 0.0 0 1

BitmapOr (cost=18,575.68..18,575.68 rows=36,865 width=0) (actual time=29.387..29.387 rows=0 loops=1)

3. 8.959 8.959 ↓ 1.4 38,178 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_dthr (cost=0.00..1,657.21 rows=27,712 width=0) (actual time=8.959..8.959 rows=38,178 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 23:59:59-03'::timestamp with time zone))
4. 3.340 3.340 ↓ 1.6 7,511 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_dthr (cost=0.00..1,309.13 rows=4,590 width=0) (actual time=3.340..3.340 rows=7,511 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 23:59:59-03'::timestamp with time zone))
5. 0.875 0.875 ↓ 3.5 502 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_dthr (cost=0.00..1,243.61 rows=145 width=0) (actual time=0.875..0.875 rows=502 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 23:59:59-03'::timestamp with time zone))
6. 0.783 0.783 ↑ 2.3 63 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_dthr (cost=0.00..1,243.61 rows=145 width=0) (actual time=0.783..0.783 rows=63 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 23:59:59-03'::timestamp with time zone))
7. 2.673 2.673 ↓ 0.0 0 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_vel_dthr (cost=0.00..1,253.85 rows=102 width=0) (actual time=2.673..2.673 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 23:59:59-03'::timestamp with time zone))
8. 1.720 1.720 ↓ 0.0 0 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_vel_dthr (cost=0.00..1,249.07 rows=78 width=0) (actual time=1.720..1.720 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 23:59:59-03'::timestamp with time zone))
9. 1.736 1.736 ↓ 0.0 0 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_vel_dthr (cost=0.00..1,249.07 rows=68 width=0) (actual time=1.736..1.736 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 23:59:59-03'::timestamp with time zone))
10. 1.208 1.208 ↓ 1.3 116 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_vel_dthr (cost=0.00..1,253.85 rows=90 width=0) (actual time=1.208..1.208 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 = 'DISTANCIA_PERIGOSA'::text) AND (velocidade >= 50) AND (datahora >= '2019-05-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 23:59:59-03'::timestamp with time zone))
11. 1.143 1.143 ↑ 25.5 4 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_vel_dthr (cost=0.00..1,253.85 rows=102 width=0) (actual time=1.143..1.143 rows=4 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 23:59:59-03'::timestamp with time zone))
12. 0.968 0.968 ↑ 8.5 134 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_vel_dthr (cost=0.00..1,401.95 rows=1,134 width=0) (actual time=0.968..0.968 rows=134 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 23:59:59-03'::timestamp with time zone))
13. 0.891 0.891 ↑ 204.1 12 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_vel_dthr (cost=0.00..1,588.27 rows=2,449 width=0) (actual time=0.891..0.891 rows=12 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 23:59:59-03'::timestamp with time zone))
14. 1.732 1.732 ↓ 0.0 0 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_vel_dthr (cost=0.00..1,249.07 rows=57 width=0) (actual time=1.732..1.732 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 23:59:59-03'::timestamp with time zone))
15. 1.800 1.800 ↓ 0.0 0 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_vel_dthr (cost=0.00..1,253.85 rows=102 width=0) (actual time=1.800..1.800 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 23:59:59-03'::timestamp with time zone))
16. 1.548 1.548 ↓ 0.0 0 1

Bitmap Index Scan on idx_preocorrencia_tipo_uoveiculo_vel_dthr (cost=0.00..1,253.85 rows=90 width=0) (actual time=1.548..1.548 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-04 00:00:00-03'::timestamp with time zone) AND (datahora <= '2019-05-04 23:59:59-03'::timestamp with time zone))