QUERY PLAN --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- [ + { + "Plan": { + "Node Type": "Nested Loop", + "Parallel Aware": false, + "Async Capable": false, + "Join Type": "Anti", + "Startup Cost": 10692.49, + "Total Cost": 375675.13, + "Plan Rows": 360, + "Plan Width": 199, + "Actual Startup Time": 60.959, + "Actual Total Time": 7695.760, + "Actual Rows": 527, + "Actual Loops": 1, + "Output": ["t.triggerid", "t.priority", "t.manual_close", "t.expression", "t.comments"], + "Inner Unique": false, + "Shared Hit Blocks": 71646, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "Plans": [ + { + "Node Type": "Bitmap Heap Scan", + "Parent Relationship": "Outer", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "triggers", + "Schema": "public", + "Alias": "t", + "Startup Cost": 10691.35, + "Total Cost": 349282.97, + "Plan Rows": 461, + "Plan Width": 199, + "Actual Startup Time": 60.751, + "Actual Total Time": 7670.537, + "Actual Rows": 532, + "Actual Loops": 1, + "Output": ["t.triggerid", "t.priority", "t.manual_close", "t.expression", "t.comments"], + "Recheck Cond": "(((t.triggerid = ANY ('{263757,264074,279390,281574,506394,506474,506912,510757,517007,555658,562022,562023,562024,562025,562295,562299,762455,771628,779222,779282,779350,779592,779773,781162,781866,820276,821137,827723,858611,872508,884159,884164,884169,884174,884239,922535,922586,922630,922641,922680,922731,951037,955606,955610,964808,965115,973490,1030950,1050140,1050835,1050915,1051079,1051082,1064839,1064855,1064860,1064861,1067262,1069463,1076105,1076106,1076754,1076755,1089126,1095255,1095257,1095259,1095261,1095263,1095265,1104640,1109680,1128243,1128244,1142913,1146278,1174017,1179136,1181463,1199792,1199794,1199802,1199871,1202942,1218838,1226155,1226279,1226341,1246871,1246895,1247471,1247499,1247527,1247555,1247798,1250198,1250481,1250493,1252421,1252549,1252561,1252570,1262674,1262946,1263002,1263030,1263065,1263086,1263170,1263198,1263226,1264639,1269818,1275088,1280444,1280801,1280811,1280829,1280857,1280859,1280879,1280907,1280963,1281065,1281070,1281903,1284192,1284353,1284681,1285504,1285665,1285832,1285993,1286060,1286160,1286321,1289025,1289035,1289053,1289294,1291145,1294254,1294283,1295238,1295566,1295894,1296222,1296874,1297205,1297507,1298023,1298224,1299250,1299748,1300653,1300713,1300890,1301224,1304205,1304703,1307493,1308056,1308135,1310532,1310563,1310611,1310896,1315356,1315854,1316173,1316275,1316417,1316431,1316432,1316456,1316516,1316598,1316628,1316661,1316677,1316718,1316780,1316797,1316822,1316844,1316845,1316879,1316896,1316906,1316908,1317083,1317117,1317125,1317128,1317156,1317193,1317230,1317241,1317255,1317268,1358136,1358216,1358735,1358890,1359153,1359850,1361740,1368531,1370147,1371105,1372721,1374610,1378015,1378252,1378607,1378697,1378827,1378864,1378972,1379011,1380389,1380393,1383153,1383570,1383614,1383831,1385423,1411623,1414197,1417856,1418438,1418460,1418743,1418851,1420430,1421012,1421034,1421317,1421425,1421801,1422774,1423004,1423586,1423608,1423891,1424576,1424577,1424578,1425384,1438780,1445915,1453637,1456798,1463933,1466563,1467104,1468002,1468004,1468007,1468019,1468023,1468057,1468061,1468063,1468071,1468149,1468153,1468155,1468196,1468205,1468231,1468281,1468285,1468291,1468302,1468307,1468319,1468385,1468389,1468393,1468396,1468419,1468436,1468521,1468522,1468524,1468526,1468545,1468551,1468583,1468601,1468602,1468632,1468638,1468643,1468654,1468670,1468689,1468711,1468712,1468717,1468719,1468724,1468732,1468734,1468735,1468736,1468743,1468756,1468764,1468766,1468768,1468770,1468771,1468775,1468777,1468783,1468785,1468786,1468787,1468788,1468794,1468801,1468823,1468827,1468832,1468837,1468842,1468849,1468853,1468854,1468860,1468869,1468872,1468873,1468875,1468877,1468879,1468880,1468883,1468887,1468890,1468895,1468896,1468898,1468899,1468901,1468904,1468906,1468911,1468933,1468947,1468990,1468994,1468996,1469005,1469013,1469017,1469025,1469028,1469029,1469039,1469047,1469049,1469053,1469054,1469055,1469059,1469064,1469068,1469073,1469077,1469079,1469083,1469087,1469088,1469091,1469095,1469099,1469101,1469102,1469106,1469119,1469121,1469124,1469125,1469140,1469151,1469153,1469157,1469161,1469162,1469165,1469168,1469184,1469194,1469214,1469229,1469247,1469253,1469256,1469264,1469279,1469282,1469287,1469290,1469292,1469299,1469302,1469306,1469307,1469311,1469327,1469334,1469335,1469345,1469346,1469351,1469353,1469361,1469364,1469365,1469371,1469373,1469378,1469382,1469386,1469387,1469389,1469394,1469404,1469409,1469411,1469413,1469421,1469425,1469429,1469430,1469442,1469443,1469450,1469451,1469455,1469481,1469489,1469495,1469503,1469507,1469563,1469567,1469569,1469570,1469571,1469572,1469573,1469575,1469577,1469585,1469593,1469617,1469618,1469619,1469631,1469669,1469732,1469733,1469744,1469758,1469763,1469765,1469778,1469788,1469800,1469822,1469861,1469867,1469869,1469887,1469895,1469910,1469911,1469912,1469925,1469930,1469937,1469991,1470047,1470051,1470062,1470063,1470064,1470192,1470247,1470270,1470287,1470357,1470424,1470425,1470426,1470464,1470509,1470510,1470511,1470517,1470539,1470544,1470548,1470558,1470564,1470565,1470567,1470589,1470606,1478697,1478699,1479470,1479699,1479839,1480056,1480065,1480419,1480697,1480911,1480967,1480981,1480989,1481020,1481025,1481050,1481062,1481164,1481187,1481200,1481233,1481257,1481272,1481277,1481291,1481296,1481309,1481311,1481338,1481342,1481345,1481353,1481355,1481379,1481433,1481471,1481502,1481548,1481553,1481556,1481567,1481575,1481582,1481612,1481639,1481641,1481642,1481644,1481647,1481659,1481679,1481683,1481721,1481741,1481771,1481778,1481780,1481782,1481785,1481837,1481846,1481851,1481862,1481886,1481934,1481936,1481938,1481955,1481969,1481977,1481980,1481987,1481989,1481993,1482012,1482028,1482032,1482048,1482101,1482102,1482104,1482112,1482131,1482158,1482210,1482224,1482407,1482476,1482622,1482885,1482922,1482926,1482984,1483014,1483025,1483080,1483089,1483105,1483177,1483212,1483230,1483275,1483374,1484128,1484165,1484420,1484774,1485034,1485314,1485320,1485464,1485527,1485556,1485564,1485773,1486137,1486366,1486548,1486647,1486648,1486717,1486798,1486836,1486848,1486942,1486958,1487006,1487079,1487164,1487942,1487973,1488029,1488041,1488042,1488044,1488046,1488048,1488051,1488052,1488053,1488096,1488097,1488098,1488185,1488395,1488786,1488800,1489303,1489360,1489361,1495439,1496496,1496508,1497192,1497441,1497904,1497977,1498011,1498201,1498442,1498634,1498851,1498868,1498968,1499068,1499080,1499493,1499764,1500013,1500160,1500192,1500252,1500257,1500260,1500261,1500262,1500269,1500271,1500272,1510649,1510651,1524994,1525247,1525473,1525492,1525515,1525535,1525551,1525589,1525608,1525631,1525632,1525635,1525654,1525677,1525696,1525715,1525869,1525888,1525908,1525945,1525964,1525983,1526002,1526021,1526040,1528050,1528063,1565783,1566761,1568014,1568018,1568041,1568051,1568225,1568227,1570119,1574359,1610413,1614467,1619036,1619639,1619696,1619860,1619953,1620046,1620103,1620160,1621857,1621956,1622151,1622465,1622585,1622745,1622762,1622772,1622774,1622983,1623022,1623134,1623272,1623276,1623277,1623289,1623305,1623308,1623335,1623347,1623352,1623376,1623391,1623399,1623426,1623432,1623462,1623469,1623471,1623485,1623487,1623506,1623515,1623522,1623532,1623543,1623546,1623547,1623553,1623571,1623573,1623575,1623578,1623599,1623616,1623620,1623631,1623634,1623637,1623659,1623669,1623673,1623677,1623692,1623703,1623709,1623713,1623741,1623743,1623754,1623766,1623776,1623792,1623795,1623797,1623806,1623818,1623833,1623839,1623895,1623897,1623898,1623907,1623912,1623937,1623942,1623946,1623950,1623954,1623955,1623957,1623958,1623959,1623960,1623961,1623962,1623993,1624010,1624020,1624022,1624073,1624075,1624078,1624126,1624160,1624179,1624195,1624197,1624200,1624208,1624221,1624231,1624239,1624242,1624251,1624255,1624258,1624263,1624267,1624270,1624286,1624291,1624307,1624308,1624321,1624322,1624331,1624339,1624343,1624344,1624355,1624356,1624369,1624371,1624382,1624390,1624399,1624423,1624426,1624430,1624435,1624442,1624443,1624446,1624451,1624454,1624480,1626807,1626864,1626921,1626992,1627049,1627061,1627089,1627103,1627162,1627544,1627545,1627546,1627547,1627548,1628446,1628617,1628861,1629211,1629392,1629396,1629449,1629453,1629506,1629510,1629563,1629567,1630853,1630943,1630986,1631041,1636050,1636052,1636057,1636072,1636074,1636079,1636094,1636096,1636101,1636116,1636118,1636123,1636138,1636140,1636145,1636160,1636162,1636167,1636182,1636184,1636189,1636204,1636206,1636211,1682036,1682042,1682098,1688120,1739350,1786447,1786459,1786583,1786600,1788080,1788142,1788204,1788400,1788401,1788421,1790092,1790954,1793352}'::bigint[])) OR (t.triggerid = ANY ('{1794047,1794056,1794271,1794272,1796462,1797989,1798672,1798729,1798786,1799380,1799788,1799789,1799819,1799820,1799850,1799851,1799881,1799882,1799912,1799913,1799943,1799944,1799974,1799975,1803975,1803992}'::bigint[]))) AND (t.flags = ANY ('{0,4}'::integer[])))",+ "Rows Removed by Index Recheck": 0, + "Filter": "((t.status = 0) AND (NOT (SubPlan 1)))", + "Rows Removed by Filter": 436, + "Exact Heap Blocks": 700, + "Lossy Heap Blocks": 0, + "Shared Hit Blocks": 58329, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "Plans": [ + { + "Node Type": "BitmapAnd", + "Parent Relationship": "Outer", + "Parallel Aware": false, + "Async Capable": false, + "Startup Cost": 10688.98, + "Total Cost": 10688.98, + "Plan Rows": 936, + "Plan Width": 0, + "Actual Startup Time": 41.571, + "Actual Total Time": 41.575, + "Actual Rows": 0, + "Actual Loops": 1, + "Shared Hit Blocks": 4049, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "Plans": [ + { + "Node Type": "BitmapOr", + "Parent Relationship": "Member", + "Parallel Aware": false, + "Async Capable": false, + "Startup Cost": 3831.91, + "Total Cost": 3831.91, + "Plan Rows": 976, + "Plan Width": 0, + "Actual Startup Time": 5.812, + "Actual Total Time": 5.813, + "Actual Rows": 0, + "Actual Loops": 1, + "Shared Hit Blocks": 2928, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "Plans": [ + { + "Node Type": "Bitmap Index Scan", + "Parent Relationship": "Member", + "Parallel Aware": false, + "Async Capable": false, + "Index Name": "triggers_pkey", + "Startup Cost": 0.00, + "Total Cost": 3716.50, + "Plan Rows": 950, + "Plan Width": 0, + "Actual Startup Time": 5.643, + "Actual Total Time": 5.643, + "Actual Rows": 950, + "Actual Loops": 1, + "Index Cond": "(t.triggerid = ANY ('{263757,264074,279390,281574,506394,506474,506912,510757,517007,555658,562022,562023,562024,562025,562295,562299,762455,771628,779222,779282,779350,779592,779773,781162,781866,820276,821137,827723,858611,872508,884159,884164,884169,884174,884239,922535,922586,922630,922641,922680,922731,951037,955606,955610,964808,965115,973490,1030950,1050140,1050835,1050915,1051079,1051082,1064839,1064855,1064860,1064861,1067262,1069463,1076105,1076106,1076754,1076755,1089126,1095255,1095257,1095259,1095261,1095263,1095265,1104640,1109680,1128243,1128244,1142913,1146278,1174017,1179136,1181463,1199792,1199794,1199802,1199871,1202942,1218838,1226155,1226279,1226341,1246871,1246895,1247471,1247499,1247527,1247555,1247798,1250198,1250481,1250493,1252421,1252549,1252561,1252570,1262674,1262946,1263002,1263030,1263065,1263086,1263170,1263198,1263226,1264639,1269818,1275088,1280444,1280801,1280811,1280829,1280857,1280859,1280879,1280907,1280963,1281065,1281070,1281903,1284192,1284353,1284681,1285504,1285665,1285832,1285993,1286060,1286160,1286321,1289025,1289035,1289053,1289294,1291145,1294254,1294283,1295238,1295566,1295894,1296222,1296874,1297205,1297507,1298023,1298224,1299250,1299748,1300653,1300713,1300890,1301224,1304205,1304703,1307493,1308056,1308135,1310532,1310563,1310611,1310896,1315356,1315854,1316173,1316275,1316417,1316431,1316432,1316456,1316516,1316598,1316628,1316661,1316677,1316718,1316780,1316797,1316822,1316844,1316845,1316879,1316896,1316906,1316908,1317083,1317117,1317125,1317128,1317156,1317193,1317230,1317241,1317255,1317268,1358136,1358216,1358735,1358890,1359153,1359850,1361740,1368531,1370147,1371105,1372721,1374610,1378015,1378252,1378607,1378697,1378827,1378864,1378972,1379011,1380389,1380393,1383153,1383570,1383614,1383831,1385423,1411623,1414197,1417856,1418438,1418460,1418743,1418851,1420430,1421012,1421034,1421317,1421425,1421801,1422774,1423004,1423586,1423608,1423891,1424576,1424577,1424578,1425384,1438780,1445915,1453637,1456798,1463933,1466563,1467104,1468002,1468004,1468007,1468019,1468023,1468057,1468061,1468063,1468071,1468149,1468153,1468155,1468196,1468205,1468231,1468281,1468285,1468291,1468302,1468307,1468319,1468385,1468389,1468393,1468396,1468419,1468436,1468521,1468522,1468524,1468526,1468545,1468551,1468583,1468601,1468602,1468632,1468638,1468643,1468654,1468670,1468689,1468711,1468712,1468717,1468719,1468724,1468732,1468734,1468735,1468736,1468743,1468756,1468764,1468766,1468768,1468770,1468771,1468775,1468777,1468783,1468785,1468786,1468787,1468788,1468794,1468801,1468823,1468827,1468832,1468837,1468842,1468849,1468853,1468854,1468860,1468869,1468872,1468873,1468875,1468877,1468879,1468880,1468883,1468887,1468890,1468895,1468896,1468898,1468899,1468901,1468904,1468906,1468911,1468933,1468947,1468990,1468994,1468996,1469005,1469013,1469017,1469025,1469028,1469029,1469039,1469047,1469049,1469053,1469054,1469055,1469059,1469064,1469068,1469073,1469077,1469079,1469083,1469087,1469088,1469091,1469095,1469099,1469101,1469102,1469106,1469119,1469121,1469124,1469125,1469140,1469151,1469153,1469157,1469161,1469162,1469165,1469168,1469184,1469194,1469214,1469229,1469247,1469253,1469256,1469264,1469279,1469282,1469287,1469290,1469292,1469299,1469302,1469306,1469307,1469311,1469327,1469334,1469335,1469345,1469346,1469351,1469353,1469361,1469364,1469365,1469371,1469373,1469378,1469382,1469386,1469387,1469389,1469394,1469404,1469409,1469411,1469413,1469421,1469425,1469429,1469430,1469442,1469443,1469450,1469451,1469455,1469481,1469489,1469495,1469503,1469507,1469563,1469567,1469569,1469570,1469571,1469572,1469573,1469575,1469577,1469585,1469593,1469617,1469618,1469619,1469631,1469669,1469732,1469733,1469744,1469758,1469763,1469765,1469778,1469788,1469800,1469822,1469861,1469867,1469869,1469887,1469895,1469910,1469911,1469912,1469925,1469930,1469937,1469991,1470047,1470051,1470062,1470063,1470064,1470192,1470247,1470270,1470287,1470357,1470424,1470425,1470426,1470464,1470509,1470510,1470511,1470517,1470539,1470544,1470548,1470558,1470564,1470565,1470567,1470589,1470606,1478697,1478699,1479470,1479699,1479839,1480056,1480065,1480419,1480697,1480911,1480967,1480981,1480989,1481020,1481025,1481050,1481062,1481164,1481187,1481200,1481233,1481257,1481272,1481277,1481291,1481296,1481309,1481311,1481338,1481342,1481345,1481353,1481355,1481379,1481433,1481471,1481502,1481548,1481553,1481556,1481567,1481575,1481582,1481612,1481639,1481641,1481642,1481644,1481647,1481659,1481679,1481683,1481721,1481741,1481771,1481778,1481780,1481782,1481785,1481837,1481846,1481851,1481862,1481886,1481934,1481936,1481938,1481955,1481969,1481977,1481980,1481987,1481989,1481993,1482012,1482028,1482032,1482048,1482101,1482102,1482104,1482112,1482131,1482158,1482210,1482224,1482407,1482476,1482622,1482885,1482922,1482926,1482984,1483014,1483025,1483080,1483089,1483105,1483177,1483212,1483230,1483275,1483374,1484128,1484165,1484420,1484774,1485034,1485314,1485320,1485464,1485527,1485556,1485564,1485773,1486137,1486366,1486548,1486647,1486648,1486717,1486798,1486836,1486848,1486942,1486958,1487006,1487079,1487164,1487942,1487973,1488029,1488041,1488042,1488044,1488046,1488048,1488051,1488052,1488053,1488096,1488097,1488098,1488185,1488395,1488786,1488800,1489303,1489360,1489361,1495439,1496496,1496508,1497192,1497441,1497904,1497977,1498011,1498201,1498442,1498634,1498851,1498868,1498968,1499068,1499080,1499493,1499764,1500013,1500160,1500192,1500252,1500257,1500260,1500261,1500262,1500269,1500271,1500272,1510649,1510651,1524994,1525247,1525473,1525492,1525515,1525535,1525551,1525589,1525608,1525631,1525632,1525635,1525654,1525677,1525696,1525715,1525869,1525888,1525908,1525945,1525964,1525983,1526002,1526021,1526040,1528050,1528063,1565783,1566761,1568014,1568018,1568041,1568051,1568225,1568227,1570119,1574359,1610413,1614467,1619036,1619639,1619696,1619860,1619953,1620046,1620103,1620160,1621857,1621956,1622151,1622465,1622585,1622745,1622762,1622772,1622774,1622983,1623022,1623134,1623272,1623276,1623277,1623289,1623305,1623308,1623335,1623347,1623352,1623376,1623391,1623399,1623426,1623432,1623462,1623469,1623471,1623485,1623487,1623506,1623515,1623522,1623532,1623543,1623546,1623547,1623553,1623571,1623573,1623575,1623578,1623599,1623616,1623620,1623631,1623634,1623637,1623659,1623669,1623673,1623677,1623692,1623703,1623709,1623713,1623741,1623743,1623754,1623766,1623776,1623792,1623795,1623797,1623806,1623818,1623833,1623839,1623895,1623897,1623898,1623907,1623912,1623937,1623942,1623946,1623950,1623954,1623955,1623957,1623958,1623959,1623960,1623961,1623962,1623993,1624010,1624020,1624022,1624073,1624075,1624078,1624126,1624160,1624179,1624195,1624197,1624200,1624208,1624221,1624231,1624239,1624242,1624251,1624255,1624258,1624263,1624267,1624270,1624286,1624291,1624307,1624308,1624321,1624322,1624331,1624339,1624343,1624344,1624355,1624356,1624369,1624371,1624382,1624390,1624399,1624423,1624426,1624430,1624435,1624442,1624443,1624446,1624451,1624454,1624480,1626807,1626864,1626921,1626992,1627049,1627061,1627089,1627103,1627162,1627544,1627545,1627546,1627547,1627548,1628446,1628617,1628861,1629211,1629392,1629396,1629449,1629453,1629506,1629510,1629563,1629567,1630853,1630943,1630986,1631041,1636050,1636052,1636057,1636072,1636074,1636079,1636094,1636096,1636101,1636116,1636118,1636123,1636138,1636140,1636145,1636160,1636162,1636167,1636182,1636184,1636189,1636204,1636206,1636211,1682036,1682042,1682098,1688120,1739350,1786447,1786459,1786583,1786600,1788080,1788142,1788204,1788400,1788401,1788421,1790092,1790954,1793352}'::bigint[]))", + "Shared Hit Blocks": 2850, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0 + }, + { + "Node Type": "Bitmap Index Scan", + "Parent Relationship": "Member", + "Parallel Aware": false, + "Async Capable": false, + "Index Name": "triggers_pkey", + "Startup Cost": 0.00, + "Total Cost": 115.18, + "Plan Rows": 26, + "Plan Width": 0, + "Actual Startup Time": 0.167, + "Actual Total Time": 0.167, + "Actual Rows": 26, + "Actual Loops": 1, + "Index Cond": "(t.triggerid = ANY ('{1794047,1794056,1794271,1794272,1796462,1797989,1798672,1798729,1798786,1799380,1799788,1799789,1799819,1799820,1799850,1799851,1799881,1799882,1799912,1799913,1799943,1799944,1799974,1799975,1803975,1803992}'::bigint[]))", + "Shared Hit Blocks": 78, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0 + } + ] + }, + { + "Node Type": "Bitmap Index Scan", + "Parent Relationship": "Member", + "Parallel Aware": false, + "Async Capable": false, + "Index Name": "triggers_flags_idx", + "Startup Cost": 0.00, + "Total Cost": 6856.70, + "Plan Rows": 502914, + "Plan Width": 0, + "Actual Startup Time": 35.466, + "Actual Total Time": 35.466, + "Actual Rows": 505221, + "Actual Loops": 1, + "Index Cond": "(t.flags = ANY ('{0,4}'::integer[]))", + "Shared Hit Blocks": 1121, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0 + } + ] + }, + { + "Node Type": "Aggregate", + "Strategy": "Sorted", + "Partial Mode": "Simple", + "Parent Relationship": "SubPlan", + "Subplan Name": "SubPlan 1", + "Parallel Aware": false, + "Async Capable": false, + "Startup Cost": 1.14, + "Total Cost": 5713.81, + "Plan Rows": 16, + "Plan Width": 40, + "Actual Startup Time": 7.913, + "Actual Total Time": 7.913, + "Actual Rows": 0, + "Actual Loops": 962, + "Output": ["NULL::text", "i_1.hostid"], + "Group Key": ["i_1.hostid"], + "Filter": "((max(r.permission) < 2) OR (min(r.permission) IS NULL) OR (min(r.permission) = 0))", + "Rows Removed by Filter": 1, + "Shared Hit Blocks": 53580, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "Plans": [ + { + "Node Type": "Nested Loop", + "Parent Relationship": "Outer", + "Parallel Aware": false, + "Async Capable": false, + "Join Type": "Left", + "Startup Cost": 1.14, + "Total Cost": 5712.80, + "Plan Rows": 45, + "Plan Width": 12, + "Actual Startup Time": 3.547, + "Actual Total Time": 7.908, + "Actual Rows": 4, + "Actual Loops": 962, + "Output": ["i_1.hostid", "r.permission"], + "Inner Unique": false, + "Join Filter": "(r.id = hgg.groupid)", + "Rows Removed by Join Filter": 3, + "Shared Hit Blocks": 53580, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "Plans": [ + { + "Node Type": "Nested Loop", + "Parent Relationship": "Outer", + "Parallel Aware": false, + "Async Capable": false, + "Join Type": "Inner", + "Startup Cost": 1.14, + "Total Cost": 5710.11, + "Plan Rows": 45, + "Plan Width": 16, + "Actual Startup Time": 3.545, + "Actual Total Time": 7.904, + "Actual Rows": 4, + "Actual Loops": 962, + "Output": ["i_1.hostid", "hgg.groupid"], + "Inner Unique": false, + "Join Filter": "(i_1.hostid = hgg.hostid)", + "Rows Removed by Join Filter": 31740, + "Shared Hit Blocks": 53579, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "Plans": [ + { + "Node Type": "Index Only Scan", + "Parent Relationship": "Outer", + "Parallel Aware": false, + "Async Capable": false, + "Scan Direction": "Forward", + "Index Name": "hosts_groups_1", + "Relation Name": "hosts_groups", + "Schema": "public", + "Alias": "hgg", + "Startup Cost": 0.29, + "Total Cost": 282.05, + "Plan Rows": 8651, + "Plan Width": 16, + "Actual Startup Time": 0.010, + "Actual Total Time": 1.275, + "Actual Rows": 8651, + "Actual Loops": 962, + "Output": ["hgg.hostid", "hgg.groupid"], + "Heap Fetches": 0, + "Shared Hit Blocks": 35595, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0 + }, + { + "Node Type": "Materialize", + "Parent Relationship": "Inner", + "Parallel Aware": false, + "Async Capable": false, + "Startup Cost": 0.85, + "Total Cost": 367.32, + "Plan Rows": 39, + "Plan Width": 8, + "Actual Startup Time": 0.000, + "Actual Total Time": 0.000, + "Actual Rows": 4, + "Actual Loops": 8322262, + "Output": ["i_1.hostid"], + "Shared Hit Blocks": 17984, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "Plans": [ + { + "Node Type": "Nested Loop", + "Parent Relationship": "Outer", + "Parallel Aware": false, + "Async Capable": false, + "Join Type": "Inner", + "Startup Cost": 0.85, + "Total Cost": 367.13, + "Plan Rows": 39, + "Plan Width": 8, + "Actual Startup Time": 0.042, + "Actual Total Time": 0.051, + "Actual Rows": 4, + "Actual Loops": 962, + "Output": ["i_1.hostid"], + "Inner Unique": true, + "Shared Hit Blocks": 17984, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "Plans": [ + { + "Node Type": "Index Scan", + "Parent Relationship": "Outer", + "Parallel Aware": false, + "Async Capable": false, + "Scan Direction": "Forward", + "Index Name": "functions_1", + "Relation Name": "functions", + "Schema": "public", + "Alias": "f_1", + "Startup Cost": 0.43, + "Total Cost": 37.97, + "Plan Rows": 39, + "Plan Width": 8, + "Actual Startup Time": 0.018, + "Actual Total Time": 0.019, + "Actual Rows": 4, + "Actual Loops": 962, + "Output": ["f_1.functionid", "f_1.itemid", "f_1.triggerid", "f_1.name", "f_1.parameter"], + "Index Cond": "(f_1.triggerid = t.triggerid)", + "Rows Removed by Index Recheck": 0, + "Shared Hit Blocks": 3864, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0 + }, + { + "Node Type": "Index Scan", + "Parent Relationship": "Inner", + "Parallel Aware": false, + "Async Capable": false, + "Scan Direction": "Forward", + "Index Name": "items_pkey", + "Relation Name": "items", + "Schema": "public", + "Alias": "i_1", + "Startup Cost": 0.42, + "Total Cost": 8.44, + "Plan Rows": 1, + "Plan Width": 16, + "Actual Startup Time": 0.007, + "Actual Total Time": 0.007, + "Actual Rows": 1, + "Actual Loops": 3530, + "Output": ["i_1.hostid", "i_1.itemid"], + "Index Cond": "(i_1.itemid = f_1.itemid)", + "Rows Removed by Index Recheck": 0, + "Shared Hit Blocks": 14120, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0 + } + ] + } + ] + } + ] + }, + { + "Node Type": "Materialize", + "Parent Relationship": "Inner", + "Parallel Aware": false, + "Async Capable": false, + "Startup Cost": 0.00, + "Total Cost": 2.02, + "Plan Rows": 1, + "Plan Width": 12, + "Actual Startup Time": 0.000, + "Actual Total Time": 0.000, + "Actual Rows": 1, + "Actual Loops": 4194, + "Output": ["r.permission", "r.id"], + "Shared Hit Blocks": 1, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "Plans": [ + { + "Node Type": "Seq Scan", + "Parent Relationship": "Outer", + "Parallel Aware": false, + "Async Capable": false, + "Relation Name": "rights", + "Schema": "public", + "Alias": "r", + "Startup Cost": 0.00, + "Total Cost": 2.01, + "Plan Rows": 1, + "Plan Width": 12, + "Actual Startup Time": 0.021, + "Actual Total Time": 0.023, + "Actual Rows": 1, + "Actual Loops": 1, + "Output": ["r.permission", "r.id"], + "Filter": "(r.groupid = 30)", + "Rows Removed by Filter": 80, + "Shared Hit Blocks": 1, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0 + } + ] + } + ] + } + ] + } + ] + }, + { + "Node Type": "Nested Loop", + "Parent Relationship": "Inner", + "Parallel Aware": false, + "Async Capable": false, + "Join Type": "Inner", + "Startup Cost": 1.14, + "Total Cost": 69.70, + "Plan Rows": 11, + "Plan Width": 8, + "Actual Startup Time": 0.045, + "Actual Total Time": 0.045, + "Actual Rows": 0, + "Actual Loops": 532, + "Output": ["f.triggerid"], + "Inner Unique": true, + "Shared Hit Blocks": 13317, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "Plans": [ + { + "Node Type": "Nested Loop", + "Parent Relationship": "Outer", + "Parallel Aware": false, + "Async Capable": false, + "Join Type": "Inner", + "Startup Cost": 0.85, + "Total Cost": 57.16, + "Plan Rows": 39, + "Plan Width": 20, + "Actual Startup Time": 0.021, + "Actual Total Time": 0.027, + "Actual Rows": 3, + "Actual Loops": 532, + "Output": ["f.triggerid", "i.hostid", "i.status"], + "Inner Unique": true, + "Shared Hit Blocks": 8523, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0, + "Plans": [ + { + "Node Type": "Index Scan", + "Parent Relationship": "Outer", + "Parallel Aware": false, + "Async Capable": false, + "Scan Direction": "Forward", + "Index Name": "functions_1", + "Relation Name": "functions", + "Schema": "public", + "Alias": "f", + "Startup Cost": 0.43, + "Total Cost": 38.34, + "Plan Rows": 39, + "Plan Width": 16, + "Actual Startup Time": 0.009, + "Actual Total Time": 0.010, + "Actual Rows": 3, + "Actual Loops": 532, + "Output": ["f.functionid", "f.itemid", "f.triggerid", "f.name", "f.parameter"], + "Index Cond": "(f.triggerid = t.triggerid)", + "Rows Removed by Index Recheck": 0, + "Shared Hit Blocks": 2131, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0 + }, + { + "Node Type": "Index Scan", + "Parent Relationship": "Inner", + "Parallel Aware": false, + "Async Capable": false, + "Scan Direction": "Forward", + "Index Name": "items_pkey", + "Relation Name": "items", + "Schema": "public", + "Alias": "i", + "Startup Cost": 0.42, + "Total Cost": 0.48, + "Plan Rows": 1, + "Plan Width": 20, + "Actual Startup Time": 0.004, + "Actual Total Time": 0.004, + "Actual Rows": 1, + "Actual Loops": 1598, + "Output": ["i.itemid", "i.hostid", "i.status"], + "Index Cond": "(i.itemid = f.itemid)", + "Rows Removed by Index Recheck": 0, + "Shared Hit Blocks": 6392, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0 + } + ] + }, + { + "Node Type": "Index Scan", + "Parent Relationship": "Inner", + "Parallel Aware": false, + "Async Capable": false, + "Scan Direction": "Forward", + "Index Name": "hosts_pkey", + "Relation Name": "hosts", + "Schema": "public", + "Alias": "h", + "Startup Cost": 0.28, + "Total Cost": 0.31, + "Plan Rows": 1, + "Plan Width": 12, + "Actual Startup Time": 0.005, + "Actual Total Time": 0.005, + "Actual Rows": 0, + "Actual Loops": 1598, + "Output": ["h.hostid", "h.status"], + "Index Cond": "(h.hostid = i.hostid)", + "Rows Removed by Index Recheck": 0, + "Filter": "((i.status <> 0) OR (h.status <> 0))", + "Rows Removed by Filter": 1, + "Shared Hit Blocks": 4794, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0 + } + ] + } + ] + }, + "Query Identifier": -295411597952694320, + "Planning": { + "Shared Hit Blocks": 939, + "Shared Read Blocks": 0, + "Shared Dirtied Blocks": 0, + "Shared Written Blocks": 0, + "Local Hit Blocks": 0, + "Local Read Blocks": 0, + "Local Dirtied Blocks": 0, + "Local Written Blocks": 0, + "Temp Read Blocks": 0, + "Temp Written Blocks": 0 + }, + "Planning Time": 8.443, + "Triggers": [ + ], + "Execution Time": 7696.545 + } + ] (1 row)