zabbix=# EXPLAIN (ANALYZE, COSTS, VERBOSE, BUFFERS, FORMAT JSON) SELECT DISTINCT p.eventid,p.objectid,p.clock,p.ns,p.name,p.severity FROM problem p,functions f,items i,hosts_groups hg WHERE p.source='0' AND p.object='0' AND NOT EXISTS (SELECT NULL FROM functions f,items i,hosts_groups hgg LEFT JOIN rights r ON r.id=hgg.groupid AND r.groupid=24 WHERE p.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hgg.hostid GROUP BY i.hostid HAVING MAX(permission)<2 OR MIN(permission) IS NULL OR MIN(permission)=0) AND  p.objectid=f.triggerid AND f.itemid=i.itemid AND i.hostid=hg.hostid AND hg.groupid IN (55,56,769) AND p.severity IN (0,2,3,4,5) AND NOT EXISTS (SELECT NULL FROM event_suppress es WHERE es.eventid=p.eventid) AND (p.r_eventid IS NULL OR p.r_clock>1720523786) ORDER BY p.eventid DESC LIMIT 1501;

 [                                                                                                                                                                                                                         
   {                                                                                                                                                                                                                       
     "Plan": {                                                                                                                                                                                                             
       "Node Type": "Limit",                                                                                                                                                                                               
       "Parallel Aware": false,                                                                                                                                                                                            
       "Startup Cost": 23978818.91,                                                                                                                                                                                        
       "Total Cost": 23978845.17,                                                                                                                                                                                          
       "Plan Rows": 1501,                                                                                                                                                                                                  
       "Plan Width": 195,                                                                                                                                                                                                  
       "Actual Startup Time": 122533.502,                                                                                                                                                                                  
       "Actual Total Time": 122534.778,                                                                                                                                                                                    
       "Actual Rows": 1501,                                                                                                                                                                                                
       "Actual Loops": 1,                                                                                                                                                                                                  
       "Output": ["p.eventid", "p.objectid", "p.clock", "p.ns", "p.name", "p.severity"],                                                                                                                                   
       "Shared Hit Blocks": 179071730,                                                                                                                                                                                     
       "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": "Unique",                                                                                                                                                                                          
           "Parent Relationship": "Outer",                                                                                                                                                                                 
           "Parallel Aware": false,                                                                                                                                                                                        
           "Startup Cost": 23978818.91,                                                                                                                                                                                    
           "Total Cost": 23979738.71,                                                                                                                                                                                      
           "Plan Rows": 52560,                                                                                                                                                                                             
           "Plan Width": 195,                                                                                                                                                                                              
           "Actual Startup Time": 122533.501,                                                                                                                                                                              
           "Actual Total Time": 122534.685,                                                                                                                                                                                
           "Actual Rows": 1501,                                                                                                                                                                                            
           "Actual Loops": 1,                                                                                                                                                                                              
           "Output": ["p.eventid", "p.objectid", "p.clock", "p.ns", "p.name", "p.severity"],                                                                                                                               
           "Shared Hit Blocks": 179071730,                                                                                                                                                                                 
           "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": "Sort",                                                                                                                                                                                        
               "Parent Relationship": "Outer",                                                                                                                                                                             
               "Parallel Aware": false,                                                                                                                                                                                    
               "Startup Cost": 23978818.91,                                                                                                                                                                                
               "Total Cost": 23978950.31,                                                                                                                                                                                  
               "Plan Rows": 52560,                                                                                                                                                                                         
               "Plan Width": 195,                                                                                                                                                                                          
               "Actual Startup Time": 122533.491,                                                                                                                                                                          
               "Actual Total Time": 122534.000,                                                                                                                                                                            
               "Actual Rows": 3767,                                                                                                                                                                                        
               "Actual Loops": 1,                                                                                                                                                                                          
               "Output": ["p.eventid", "p.objectid", "p.clock", "p.ns", "p.name", "p.severity"],                                                                                                                           
               "Sort Key": ["p.eventid DESC", "p.objectid", "p.clock", "p.ns", "p.name", "p.severity"],                                                                                                                    
               "Sort Method": "quicksort",                                                                                                                                                                                 
               "Sort Space Used": 836,                                                                                                                                                                                     
               "Sort Space Type": "Memory",                                                                                                                                                                                
               "Shared Hit Blocks": 179071730,                                                                                                                                                                             
               "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,                                                                                                                                                                                
                   "Join Type": "Anti",                                                                                                                                                                                    
                   "Startup Cost": 1856.35,                                                                                                                                                                                
                   "Total Cost": 23974697.76,                                                                                                                                                                              
                   "Plan Rows": 52560,                                                                                                                                                                                     
                   "Plan Width": 195,                                                                                                                                                                                      
                   "Actual Startup Time": 284.367,                                                                                                                                                                         
                   "Actual Total Time": 122529.861,                                                                                                                                                                        
                   "Actual Rows": 4493,                                                                                                                                                                                    
                   "Actual Loops": 1,                                                                                                                                                                                      
                   "Output": ["p.eventid", "p.objectid", "p.clock", "p.ns", "p.name", "p.severity"],                                                                                                                       
                   "Inner Unique": false,                                                                                                                                                                                  
                   "Join Filter": "(es.eventid = p.eventid)",                                                                                                                                                              
                   "Rows Removed by Join Filter": 0,                                                                                                                                                                       
                   "Shared Hit Blocks": 179071724,                                                                                                                                                                         
                   "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": "Merge Join",                                                                                                                                                                          
                       "Parent Relationship": "Outer",                                                                                                                                                                     
                       "Parallel Aware": false,                                                                                                                                                                            
                       "Join Type": "Inner",                                                                                                                                                                               
                       "Startup Cost": 1856.35,                                                                                                                                                                            
                       "Total Cost": 23973908.36,                                                                                                                                                                          
                       "Plan Rows": 52560,                                                                                                                                                                                 
                       "Plan Width": 195,                                                                                                                                                                                  
                       "Actual Startup Time": 284.325,                                                                                                                                                                     
                       "Actual Total Time": 122528.553,                                                                                                                                                                    
                       "Actual Rows": 4493,                                                                                                                                                                                
                       "Actual Loops": 1,                                                                                                                                                                                  
                       "Output": ["p.eventid", "p.objectid", "p.clock", "p.ns", "p.name", "p.severity"],                                                                                                                   
                       "Inner Unique": false,                                                                                                                                                                              
                       "Merge Cond": "(f.triggerid = p.objectid)",                                                                                                                                                         
                       "Shared Hit Blocks": 179071723,                                                                                                                                                                     
                       "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": "Gather Merge",                                                                                                                                                                    
                           "Parent Relationship": "Outer",                                                                                                                                                                 
                           "Parallel Aware": false,                                                                                                                                                                        
                           "Startup Cost": 1001.18,                                                                                                                                                                        
                           "Total Cost": 261272.91,                                                                                                                                                                        
                           "Plan Rows": 26803,                                                                                                                                                                             
                           "Plan Width": 8,                                                                                                                                                                                
                           "Actual Startup Time": 283.427,                                                                                                                                                                 
                           "Actual Total Time": 444.145,                                                                                                                                                                   
                           "Actual Rows": 31943,                                                                                                                                                                           
                           "Actual Loops": 1,                                                                                                                                                                              
                           "Output": ["f.triggerid"],                                                                                                                                                                      
                           "Workers Planned": 3,                                                                                                                                                                           
                           "Workers Launched": 3,                                                                                                                                                                          
                           "Shared Hit Blocks": 6208887,                                                                                                                                                                   
                           "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,                                                                                                                                                                    
                               "Join Type": "Inner",                                                                                                                                                                       
                               "Startup Cost": 1.14,                                                                                                                                                                       
                               "Total Cost": 257123.52,                                                                                                                                                                    
                               "Plan Rows": 8646,                                                                                                                                                                          
                               "Plan Width": 8,                                                                                                                                                                            
                               "Actual Startup Time": 3.576,                                                                                                                                                               
                               "Actual Total Time": 1324.691,                                                                                                                                                              
                               "Actual Rows": 7986,                                                                                                                                                                        
                               "Actual Loops": 4,                                                                                                                                                                          
                               "Output": ["f.triggerid"],                                                                                                                                                                  
                               "Inner Unique": false,                                                                                                                                                                      
                               "Shared Hit Blocks": 6208887,                                                                                                                                                               
                               "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,                                                                                                                                                                   
                               "Workers": [                                                                                                                                                                                
                                 {                                                                                                                                                                                         
                                   "Worker Number": 0,                                                                                                                                                                     
                                   "Actual Startup Time": 0.528,                                                                                                                                                           
                                   "Actual Total Time": 1179.858,                                                                                                                                                          
                                   "Actual Rows": 8435,                                                                                                                                                                    
                                   "Actual Loops": 1,                                                                                                                                                                      
                                   "Shared Hit Blocks": 1394665,                                                                                                                                                           
                                   "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                                                                                                                                                                
                                 },                                                                                                                                                                                        
                                 {                                                                                                                                                                                         
                                   "Worker Number": 1,                                                                                                                                                                     
                                   "Actual Startup Time": 0.621,                                                                                                                                                           
                                   "Actual Total Time": 2364.637,                                                                                                                                                          
                                   "Actual Rows": 10794,                                                                                                                                                                   
                                   "Actual Loops": 1,                                                                                                                                                                      
                                   "Shared Hit Blocks": 2880320,                                                                                                                                                           
                                   "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                                                                                                                                                                
                                 },                                                                                                                                                                                        
                                 {                                                                                                                                                                                         
                                   "Worker Number": 2,                                                                                                                                                                     
                                   "Actual Startup Time": 0.636,                                                                                                                                                           
                                   "Actual Total Time": 1599.316,                                                                                                                                                          
                                   "Actual Rows": 10917,                                                                                                                                                                   
                                   "Actual Loops": 1,                                                                                                                                                                      
                                   "Shared Hit Blocks": 1783083,                                                                                                                                                           
                                   "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,                                                                                                                                                                
                                   "Join Type": "Inner",                                                                                                                                                                   
                                   "Startup Cost": 0.85,                                                                                                                                                                   
                                   "Total Cost": 167622.05,                                                                                                                                                                
                                   "Plan Rows": 262961,                                                                                                                                                                    
                                   "Plan Width": 16,                                                                                                                                                                       
                                   "Actual Startup Time": 0.113,                                                                                                                                                           
                                   "Actual Total Time": 813.036,                                                                                                                                                           
                                   "Actual Rows": 205091,                                                                                                                                                                  
                                   "Actual Loops": 4,                                                                                                                                                                      
                                   "Output": ["f.triggerid", "i.hostid"],                                                                                                                                                  
                                   "Inner Unique": true,                                                                                                                                                                   
                                   "Shared Hit Blocks": 3347065,                                                                                                                                                           
                                   "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,                                                                                                                                                               
                                   "Workers": [                                                                                                                                                                            
                                     {                                                                                                                                                                                     
                                       "Worker Number": 0,                                                                                                                                                                 
                                       "Actual Startup Time": 0.124,                                                                                                                                                       
                                       "Actual Total Time": 712.223,                                                                                                                                                       
                                       "Actual Rows": 185038,                                                                                                                                                              
                                       "Actual Loops": 1,                                                                                                                                                                  
                                       "Shared Hit Blocks": 758026,                                                                                                                                                        
                                       "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                                                                                                                                                            
                                     },                                                                                                                                                                                    
                                     {                                                                                                                                                                                     
                                       "Worker Number": 1,                                                                                                                                                                 
                                       "Actual Startup Time": 0.141,                                                                                                                                                       
                                       "Actual Total Time": 1442.040,                                                                                                                                                      
                                       "Actual Rows": 379486,                                                                                                                                                              
                                       "Actual Loops": 1,                                                                                                                                                                  
                                       "Shared Hit Blocks": 1543629,                                                                                                                                                       
                                       "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                                                                                                                                                            
                                     },                                                                                                                                                                                    
                                     {                                                                                                                                                                                     
                                       "Worker Number": 2,                                                                                                                                                                 
                                       "Actual Startup Time": 0.140,                                                                                                                                                       
                                       "Actual Total Time": 999.954,                                                                                                                                                       
                                       "Actual Rows": 235085,                                                                                                                                                              
                                       "Actual Loops": 1,                                                                                                                                                                  
                                       "Shared Hit Blocks": 960401,                                                                                                                                                        
                                       "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": true,                                                                                                                                                             
                                       "Scan Direction": "Forward",                                                                                                                                                        
                                       "Index Name": "functions_1",                                                                                                                                                        
                                       "Relation Name": "functions",                                                                                                                                                       
                                       "Schema": "public",                                                                                                                                                                 
                                       "Alias": "f",                                                                                                                                                                       
                                       "Startup Cost": 0.42,                                                                                                                                                               
                                       "Total Cost": 28969.46,                                                                                                                                                             
                                       "Plan Rows": 262961,                                                                                                                                                                
                                       "Plan Width": 16,                                                                                                                                                                   
                                       "Actual Startup Time": 0.040,                                                                                                                                                       
                                       "Actual Total Time": 97.571,                                                                                                                                                        
                                       "Actual Rows": 205091,                                                                                                                                                              
                                       "Actual Loops": 4,                                                                                                                                                                  
                                       "Output": ["f.functionid", "f.itemid", "f.triggerid", "f.name", "f.parameter"],                                                                                                     
                                       "Shared Hit Blocks": 65606,                                                                                                                                                         
                                       "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,                                                                                                                                                           
                                       "Workers": [                                                                                                                                                                        
                                         {                                                                                                                                                                                 
                                           "Worker Number": 0,                                                                                                                                                             
                                           "Actual Startup Time": 0.047,                                                                                                                                                   
                                           "Actual Total Time": 93.430,                                                                                                                                                    
                                           "Actual Rows": 185038,                                                                                                                                                          
                                           "Actual Loops": 1,                                                                                                                                                              
                                           "Shared Hit Blocks": 17873,                                                                                                                                                     
                                           "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                                                                                                                                                        
                                         },                                                                                                                                                                                
                                         {                                                                                                                                                                                 
                                           "Worker Number": 1,                                                                                                                                                             
                                           "Actual Startup Time": 0.050,                                                                                                                                                   
                                           "Actual Total Time": 165.888,                                                                                                                                                   
                                           "Actual Rows": 379486,                                                                                                                                                          
                                           "Actual Loops": 1,                                                                                                                                                              
                                           "Shared Hit Blocks": 25684,                                                                                                                                                     
                                           "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                                                                                                                                                        
                                         },                                                                                                                                                                                
                                         {                                                                                                                                                                                 
                                           "Worker Number": 2,                                                                                                                                                             
                                           "Actual Startup Time": 0.046,                                                                                                                                                   
                                           "Actual Total Time": 119.302,                                                                                                                                                   
                                           "Actual Rows": 235085,                                                                                                                                                          
                                           "Actual Loops": 1,                                                                                                                                                              
                                           "Shared Hit Blocks": 20060,                                                                                                                                                     
                                           "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,                                                                                                                                                            
                                       "Scan Direction": "Forward",                                                                                                                                                        
                                       "Index Name": "items_pkey",                                                                                                                                                         
                                       "Relation Name": "items",                                                                                                                                                           
                                       "Schema": "public",                                                                                                                                                                 
                                       "Alias": "i",                                                                                                                                                                       
                                       "Startup Cost": 0.42,                                                                                                                                                               
                                       "Total Cost": 0.53,                                                                                                                                                                 
                                       "Plan Rows": 1,                                                                                                                                                                     
                                       "Plan Width": 16,                                                                                                                                                                   
                                       "Actual Startup Time": 0.003,                                                                                                                                                       
                                       "Actual Total Time": 0.003,                                                                                                                                                         
                                       "Actual Rows": 1,                                                                                                                                                                   
                                       "Actual Loops": 820364,                                                                                                                                                             
                                       "Output": ["i.itemid", "i.hostid"],                                                                                                                                                 
                                       "Index Cond": "(i.itemid = f.itemid)",                                                                                                                                              
                                       "Rows Removed by Index Recheck": 0,                                                                                                                                                 
                                       "Shared Hit Blocks": 3281459,                                                                                                                                                       
                                       "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,                                                                                                                                                           
                                       "Workers": [                                                                                                                                                                        
                                         {                                                                                                                                                                                 
                                           "Worker Number": 0,                                                                                                                                                             
                                           "Actual Startup Time": 0.003,                                                                                                                                                   
                                           "Actual Total Time": 0.003,                                                                                                                                                     
                                           "Actual Rows": 1,                                                                                                                                                               
                                           "Actual Loops": 185038,                                                                                                                                                         
                                           "Shared Hit Blocks": 740153,                                                                                                                                                    
                                           "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                                                                                                                                                        
                                         },                                                                                                                                                                                
                                         {                                                                                                                                                                                 
                                           "Worker Number": 1,                                                                                                                                                             
                                           "Actual Startup Time": 0.003,                                                                                                                                                   
                                           "Actual Total Time": 0.003,                                                                                                                                                     
                                           "Actual Rows": 1,                                                                                                                                                               
                                           "Actual Loops": 379486,                                                                                                                                                         
                                           "Shared Hit Blocks": 1517945,                                                                                                                                                   
                                           "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                                                                                                                                                        
                                         },                                                                                                                                                                                
                                         {                                                                                                                                                                                 
                                           "Worker Number": 2,                                                                                                                                                             
                                           "Actual Startup Time": 0.003,                                                                                                                                                   
                                           "Actual Total Time": 0.003,                                                                                                                                                     
                                           "Actual Rows": 1,                                                                                                                                                               
                                           "Actual Loops": 235085,                                                                                                                                                         
                                           "Shared Hit Blocks": 940341,                                                                                                                                                    
                                           "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 Only Scan",                                                                                                                                                         
                                   "Parent Relationship": "Inner",                                                                                                                                                         
                                   "Parallel Aware": false,                                                                                                                                                                
                                   "Scan Direction": "Forward",                                                                                                                                                            
                                   "Index Name": "hosts_groups_1",                                                                                                                                                         
                                   "Relation Name": "hosts_groups",                                                                                                                                                        
                                   "Schema": "public",                                                                                                                                                                     
                                   "Alias": "hg",                                                                                                                                                                          
                                   "Startup Cost": 0.29,                                                                                                                                                                   
                                   "Total Cost": 0.33,                                                                                                                                                                     
                                   "Plan Rows": 1,                                                                                                                                                                         
                                   "Plan Width": 8,                                                                                                                                                                        
                                   "Actual Startup Time": 0.002,                                                                                                                                                           
                                   "Actual Total Time": 0.002,                                                                                                                                                             
                                   "Actual Rows": 0,                                                                                                                                                                       
                                   "Actual Loops": 820364,                                                                                                                                                                 
                                   "Output": ["hg.hostid", "hg.groupid"],                                                                                                                                                  
                                   "Index Cond": "(hg.hostid = i.hostid)",                                                                                                                                                 
                                   "Rows Removed by Index Recheck": 0,                                                                                                                                                     
                                   "Filter": "(hg.groupid = ANY ('{55,56,769}'::bigint[]))",                                                                                                                               
                                   "Rows Removed by Filter": 2,                                                                                                                                                            
                                   "Heap Fetches": 1536305,                                                                                                                                                                
                                   "Shared Hit Blocks": 2861822,                                                                                                                                                           
                                   "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,                                                                                                                                                               
                                   "Workers": [                                                                                                                                                                            
                                     {                                                                                                                                                                                     
                                       "Worker Number": 0,                                                                                                                                                                 
                                       "Actual Startup Time": 0.002,                                                                                                                                                       
                                       "Actual Total Time": 0.002,                                                                                                                                                         
                                       "Actual Rows": 0,                                                                                                                                                                   
                                       "Actual Loops": 185038,                                                                                                                                                             
                                       "Shared Hit Blocks": 636639,                                                                                                                                                        
                                       "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                                                                                                                                                            
                                     },                                                                                                                                                                                    
                                     {                                                                                                                                                                                     
                                       "Worker Number": 1,                                                                                                                                                                 
                                       "Actual Startup Time": 0.002,                                                                                                                                                       
                                       "Actual Total Time": 0.002,                                                                                                                                                         
                                       "Actual Rows": 0,                                                                                                                                                                   
                                       "Actual Loops": 379486,                                                                                                                                                             
                                       "Shared Hit Blocks": 1336691,                                                                                                                                                       
                                       "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                                                                                                                                                            
                                     },                                                                                                                                                                                    
                                     {                                                                                                                                                                                     
                                       "Worker Number": 2,                                                                                                                                                                 
                                       "Actual Startup Time": 0.002,                                                                                                                                                       
                                       "Actual Total Time": 0.002,                                                                                                                                                         
                                       "Actual Rows": 0,                                                                                                                                                                   
                                       "Actual Loops": 235085,                                                                                                                                                             
                                       "Shared Hit Blocks": 822682,                                                                                                                                                        
                                       "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,                                                                                                                                                                        
                           "Scan Direction": "Forward",                                                                                                                                                                    
                           "Index Name": "problem_1",                                                                                                                                                                      
                           "Relation Name": "problem",                                                                                                                                                                     
                           "Schema": "public",                                                                                                                                                                             
                           "Alias": "p",                                                                                                                                                                                   
                           "Startup Cost": 0.43,                                                                                                                                                                           
                           "Total Cost": 23711458.55,                                                                                                                                                                      
                           "Plan Rows": 936935,                                                                                                                                                                            
                           "Plan Width": 195,                                                                                                                                                                              
                           "Actual Startup Time": 0.433,                                                                                                                                                                   
                           "Actual Total Time": 122080.751,                                                                                                                                                                
                           "Actual Rows": 5531,                                                                                                                                                                            
                           "Actual Loops": 1,                                                                                                                                                                              
                           "Output": ["p.eventid", "p.source", "p.object", "p.objectid", "p.clock", "p.ns", "p.r_eventid", "p.r_clock", "p.r_ns", "p.correlationid", "p.userid", "p.name", "p.acknowledged", "p.severity"],
                           "Index Cond": "((p.source = 0) AND (p.object = 0))",                                                                                                                                            
                           "Rows Removed by Index Recheck": 0,                                                                                                                                                             
                           "Filter": "(((p.r_eventid IS NULL) OR (p.r_clock > 1720523786)) AND (p.severity = ANY ('{0,2,3,4,5}'::integer[])) AND (NOT (SubPlan 1)))",                                                      
                           "Rows Removed by Filter": 5228505,                                                                                                                                                              
                           "Shared Hit Blocks": 172862836,                                                                                                                                                                 
                           "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": "Aggregate",                                                                                                                                                                   
                               "Strategy": "Sorted",                                                                                                                                                                       
                               "Partial Mode": "Simple",                                                                                                                                                                   
                               "Parent Relationship": "SubPlan",                                                                                                                                                           
                               "Subplan Name": "SubPlan 1",                                                                                                                                                                
                               "Parallel Aware": false,                                                                                                                                                                    
                               "Startup Cost": 12.47,                                                                                                                                                                      
                               "Total Cost": 12.60,                                                                                                                                                                        
                               "Plan Rows": 2,                                                                                                                                                                             
                               "Plan Width": 40,                                                                                                                                                                           
                               "Actual Startup Time": 0.023,                                                                                                                                                               
                               "Actual Total Time": 0.023,                                                                                                                                                                 
                               "Actual Rows": 1,                                                                                                                                                                           
                               "Actual Loops": 5233298,                                                                                                                                                                    
                               "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": 0,                                                                                                                                                                
                               "Shared Hit Blocks": 172041979,                                                                                                                                                             
                               "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": "Sort",                                                                                                                                                                    
                                   "Parent Relationship": "Outer",                                                                                                                                                         
                                   "Parallel Aware": false,                                                                                                                                                                
                                   "Startup Cost": 12.47,                                                                                                                                                                  
                                   "Total Cost": 12.48,                                                                                                                                                                    
                                   "Plan Rows": 5,                                                                                                                                                                         
                                   "Plan Width": 12,                                                                                                                                                                       
                                   "Actual Startup Time": 0.022,                                                                                                                                                           
                                   "Actual Total Time": 0.022,                                                                                                                                                             
                                   "Actual Rows": 3,                                                                                                                                                                       
                                   "Actual Loops": 5233298,                                                                                                                                                                
                                   "Output": ["i_1.hostid", "r.permission"],                                                                                                                                               
                                   "Sort Key": ["i_1.hostid"],                                                                                                                                                             
                                   "Sort Method": "quicksort",                                                                                                                                                             
                                   "Sort Space Used": 25,                                                                                                                                                                  
                                   "Sort Space Type": "Memory",                                                                                                                                                            
                                   "Shared Hit Blocks": 172041979,                                                                                                                                                         
                                   "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,                                                                                                                                                            
                                       "Join Type": "Left",                                                                                                                                                                
                                       "Startup Cost": 1.42,                                                                                                                                                               
                                       "Total Cost": 12.41,                                                                                                                                                                
                                       "Plan Rows": 5,                                                                                                                                                                     
                                       "Plan Width": 12,                                                                                                                                                                   
                                       "Actual Startup Time": 0.012,                                                                                                                                                       
                                       "Actual Total Time": 0.021,                                                                                                                                                         
                                       "Actual Rows": 3,                                                                                                                                                                   
                                       "Actual Loops": 5233298,                                                                                                                                                            
                                       "Output": ["i_1.hostid", "r.permission"],                                                                                                                                           
                                       "Inner Unique": false,                                                                                                                                                              
                                       "Shared Hit Blocks": 172041979,                                                                                                                                                     
                                       "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,                                                                                                                                                        
                                           "Join Type": "Inner",                                                                                                                                                           
                                           "Startup Cost": 1.14,                                                                                                                                                           
                                           "Total Cost": 10.56,                                                                                                                                                            
                                           "Plan Rows": 5,                                                                                                                                                                 
                                           "Plan Width": 16,                                                                                                                                                               
                                           "Actual Startup Time": 0.006,                                                                                                                                                   
                                           "Actual Total Time": 0.009,                                                                                                                                                     
                                           "Actual Rows": 3,                                                                                                                                                               
                                           "Actual Loops": 5233298,                                                                                                                                                        
                                           "Output": ["i_1.hostid", "hgg.groupid"],                                                                                                                                        
                                           "Inner Unique": false,                                                                                                                                                          
                                           "Shared Hit Blocks": 70033984,                                                                                                                                                  
                                           "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,                                                                                                                                                    
                                               "Join Type": "Inner",                                                                                                                                                       
                                               "Startup Cost": 0.85,                                                                                                                                                       
                                               "Total Cost": 9.88,                                                                                                                                                         
                                               "Plan Rows": 2,                                                                                                                                                             
                                               "Plan Width": 8,                                                                                                                                                            
                                               "Actual Startup Time": 0.004,                                                                                                                                               
                                               "Actual Total Time": 0.005,                                                                                                                                                 
                                               "Actual Rows": 1,                                                                                                                                                           
                                               "Actual Loops": 5233298,                                                                                                                                                    
                                               "Output": ["i_1.hostid"],                                                                                                                                                   
                                               "Inner Unique": true,                                                                                                                                                       
                                               "Shared Hit Blocks": 44171889,                                                                                                                                              
                                               "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,                                                                                                                                                
                                                   "Scan Direction": "Forward",                                                                                                                                            
                                                   "Index Name": "functions_1",                                                                                                                                            
                                                   "Relation Name": "functions",                                                                                                                                           
                                                   "Schema": "public",                                                                                                                                                     
                                                   "Alias": "f_1",                                                                                                                                                         
                                                   "Startup Cost": 0.42,                                                                                                                                                   
                                                   "Total Cost": 3.99,                                                                                                                                                     
                                                   "Plan Rows": 2,                                                                                                                                                         
                                                   "Plan Width": 8,                                                                                                                                                        
                                                   "Actual Startup Time": 0.002,                                                                                                                                           
                                                   "Actual Total Time": 0.002,                                                                                                                                             
                                                   "Actual Rows": 1,                                                                                                                                                       
                                                   "Actual Loops": 5233298,                                                                                                                                                
                                                   "Output": ["f_1.functionid", "f_1.itemid", "f_1.triggerid", "f_1.name", "f_1.parameter"],                                                                               
                                                   "Index Cond": "(f_1.triggerid = p.objectid)",                                                                                                                           
                                                   "Rows Removed by Index Recheck": 0,                                                                                                                                     
                                                   "Shared Hit Blocks": 20952677,                                                                                                                                          
                                                   "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,                                                                                                                                                
                                                   "Scan Direction": "Forward",                                                                                                                                            
                                                   "Index Name": "items_pkey",                                                                                                                                             
                                                   "Relation Name": "items",                                                                                                                                               
                                                   "Schema": "public",                                                                                                                                                     
                                                   "Alias": "i_1",                                                                                                                                                         
                                                   "Startup Cost": 0.42,                                                                                                                                                   
                                                   "Total Cost": 2.94,                                                                                                                                                     
                                                   "Plan Rows": 1,                                                                                                                                                         
                                                   "Plan Width": 16,                                                                                                                                                       
                                                   "Actual Startup Time": 0.002,                                                                                                                                           
                                                   "Actual Total Time": 0.002,                                                                                                                                             
                                                   "Actual Rows": 1,                                                                                                                                                       
                                                   "Actual Loops": 5804803,                                                                                                                                                
                                                   "Output": ["i_1.hostid", "i_1.itemid"],                                                                                                                                 
                                                   "Index Cond": "(i_1.itemid = f_1.itemid)",                                                                                                                              
                                                   "Rows Removed by Index Recheck": 0,                                                                                                                                     
                                                   "Shared Hit Blocks": 23219212,                                                                                                                                          
                                                   "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 Only Scan",                                                                                                                                             
                                               "Parent Relationship": "Inner",                                                                                                                                             
                                               "Parallel Aware": false,                                                                                                                                                    
                                               "Scan Direction": "Forward",                                                                                                                                                
                                               "Index Name": "hosts_groups_1",                                                                                                                                             
                                               "Relation Name": "hosts_groups",                                                                                                                                            
                                               "Schema": "public",                                                                                                                                                         
                                               "Alias": "hgg",                                                                                                                                                             
                                               "Startup Cost": 0.29,                                                                                                                                                       
                                               "Total Cost": 0.32,                                                                                                                                                         
                                               "Plan Rows": 2,                                                                                                                                                             
                                               "Plan Width": 16,                                                                                                                                                           
                                               "Actual Startup Time": 0.002,                                                                                                                                               
                                               "Actual Total Time": 0.003,                                                                                                                                                 
                                               "Actual Rows": 3,                                                                                                                                                           
                                               "Actual Loops": 5804803,                                                                                                                                                    
                                               "Output": ["hgg.hostid", "hgg.groupid"],                                                                                                                                    
                                               "Index Cond": "(hgg.hostid = i_1.hostid)",                                                                                                                                  
                                               "Rows Removed by Index Recheck": 0,                                                                                                                                         
                                               "Heap Fetches": 15128613,                                                                                                                                                   
                                               "Shared Hit Blocks": 25862095,                                                                                                                                              
                                               "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,                                                                                                                                                        
                                           "Scan Direction": "Forward",                                                                                                                                                    
                                           "Index Name": "rights_2",                                                                                                                                                       
                                           "Relation Name": "rights",                                                                                                                                                      
                                           "Schema": "public",                                                                                                                                                             
                                           "Alias": "r",                                                                                                                                                                   
                                           "Startup Cost": 0.28,                                                                                                                                                           
                                           "Total Cost": 0.36,                                                                                                                                                             
                                           "Plan Rows": 1,                                                                                                                                                                 
                                           "Plan Width": 12,                                                                                                                                                               
                                           "Actual Startup Time": 0.004,                                                                                                                                                   
                                           "Actual Total Time": 0.004,                                                                                                                                                     
                                           "Actual Rows": 0,                                                                                                                                                               
                                           "Actual Loops": 16743713,                                                                                                                                                       
                                           "Output": ["r.rightid", "r.groupid", "r.permission", "r.id"],                                                                                                                   
                                           "Index Cond": "(r.id = hgg.groupid)",                                                                                                                                           
                                           "Rows Removed by Index Recheck": 0,                                                                                                                                             
                                           "Filter": "(r.groupid = 24)",                                                                                                                                                   
                                           "Rows Removed by Filter": 4,                                                                                                                                                    
                                           "Shared Hit Blocks": 102007995,                                                                                                                                                 
                                           "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,                                                                                                                                                                            
                       "Startup Cost": 0.00,                                                                                                                                                                               
                       "Total Cost": 1.00,                                                                                                                                                                                 
                       "Plan Rows": 1,                                                                                                                                                                                     
                       "Plan Width": 8,                                                                                                                                                                                    
                       "Actual Startup Time": 0.000,                                                                                                                                                                       
                       "Actual Total Time": 0.000,                                                                                                                                                                         
                       "Actual Rows": 0,                                                                                                                                                                                   
                       "Actual Loops": 4493,                                                                                                                                                                               
                       "Output": ["es.eventid"],                                                                                                                                                                           
                       "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,                                                                                                                                                                        
                           "Relation Name": "event_suppress",                                                                                                                                                              
                           "Schema": "public",                                                                                                                                                                             
                           "Alias": "es",                                                                                                                                                                                  
                           "Startup Cost": 0.00,                                                                                                                                                                           
                           "Total Cost": 1.00,                                                                                                                                                                             
                           "Plan Rows": 1,                                                                                                                                                                                 
                           "Plan Width": 8,                                                                                                                                                                                
                           "Actual Startup Time": 0.032,                                                                                                                                                                   
                           "Actual Total Time": 0.032,                                                                                                                                                                     
                           "Actual Rows": 0,                                                                                                                                                                               
                           "Actual Loops": 1,                                                                                                                                                                              
                           "Output": ["es.eventid"],                                                                                                                                                                       
                           "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                                                                                                                                                                        
                         }                                                                                                                                                                                                 
                       ]                                                                                                                                                                                                   
                     }                                                                                                                                                                                                     
                   ]                                                                                                                                                                                                       
                 }                                                                                                                                                                                                         
               ]                                                                                                                                                                                                           
             }                                                                                                                                                                                                             
           ]                                                                                                                                                                                                               
         }                                                                                                                                                                                                                 
       ]                                                                                                                                                                                                                   
     },                                                                                                                                                                                                                    
     "Planning Time": 11.629,                                                                                                                                                                                              
     "Triggers": [                                                                                                                                                                                                         
     ],                                                                                                                                                                                                                    
     "Execution Time": 122535.397                                                                                                                                                                                          
   }                                                                                                                                                                                                                       
 ]