#	exclusive	inclusive	rows x	rows	loops	node
1.	6050.521	6050.521	↓ 10000.0	10000000	1	→ Function Scan on generate_series z (cost=0.00..22.50 rows=1000 width=4) (actual time=1091.010..6050.521 rows=10000000 loops=1)
2.						SubPlan (forFunction Scan)
3.	0.000	0.000	↑ 1.0	1	10000000	→ Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=10000000) One-Time Filter: ((-1) < z.z)

 Function Scan on generate_series z  (cost=0.00..22.50 rows=1000 width=4) (actual time=1091.010..6050.521 rows=10000000 loops=1)
   SubPlan 1
     ->  Result  (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=10000000)
           One-Time Filter: ((-1) < z.z)

Per node type stats

node type	count	sum of times	% of query
Function Scan	1	6050.521 ms	100.0 %
Result	1	0.000 ms	0.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: k1I

Colorize:

Columns visibility:

Per node type stats

Per table stats