#	exclusive	inclusive	rows x	rows	loops	node
1.	10079.765	10079.765	↑ 28.6	35	1	→ Function Scan on shortest_path (cost=0.00..10.00 rows=1000 width=16) (actual time=10079.743..10079.765 rows=35 loops=1)

                                                        QUERY PLAN                                                        
--------------------------------------------------------------------------------------------------------------------------
 Function Scan on shortest_path  (cost=0.00..10.00 rows=1000 width=16) (actual time=10079.743..10079.765 rows=35 loops=1)
 Total runtime: 10079.851 ms
(2 rows)

Per node type stats

node type	count	sum of times	% of query
Function Scan	1	10079.765 ms	100.0 %

Per table stats

Table name	Scan count	Total time	% of query
scan type	count	sum of times	% of table

explain.depesz.com

A tool for finding a real cause for slow queries.

Result: aHU

Colorize:

Columns visibility:

Per node type stats

Per table stats