  | 
			
				SoftTree Technologies 
				Technical Support Forums
			 | 
		 
		  | 
	 
	 
	
	
	
		
	
	
	
		| Author | 
		Message | 
	 
	
		
			gemisigo 
			 
			
  
			
			
				Joined: 11 Mar 2010 Posts: 2175
  | 
			 
			  
		 | 
		
			
				  [12.0.191 Pro] - Execution plain for Postgres | 
				     | 
			 
			
				Which options does SA use for EXPLAIN (options like ANALYZE, COSTS, etc.) on Postgres when hitting the Show Execution Plan button? Can that be configured somewhere?
  | 
			 
		  | 
	 
	
		| Fri Feb 11, 2022 6:30 am | 
		          | 
	 
	
		  | 
	 
	
		
			SysOp 
			Site Admin 
			
  
			
			
				Joined: 26 Nov 2006 Posts: 7992
  | 
			 
			  
		 | 
		
			
				   | 
				     | 
			 
			
				Internally that has to be based on "EXPLAIN statement"  without actual code execution. I don't believe it can be customized in the options.  Some automation is possible using macros to automatically execute EXPLAIN ANALYZE... with the selected text, or creating a custom plugin and adding it to the menus.
  | 
			 
		  | 
	 
	
		| Fri Feb 11, 2022 10:18 am | 
		          | 
	 
	
		  | 
	 
	
		 | 
	 
 
  
	 
	    
	   | 
	
You cannot post new topics in this forum You cannot reply to topics in this forum You cannot edit your posts in this forum You cannot delete your posts in this forum You cannot vote in polls in this forum
  | 
   
 
		 | 
	 
	  |