explain.depesz.com

A tool for finding a real cause for slow queries.

Result: k1I

options
Did it help? Consider supporting us - Bitcoin address: 12v2hUztAk2LgzQ9H9LMwuU32urHMjZQnq
# exclusive inclusive rows x rows loops node
1. 6,050.521 6,050.521 ↓ 10,000.0 10,000,000 1

Function Scan on generate_series z (cost=0.00..22.50 rows=1,000 width=4) (actual time=1,091.010..6,050.521 rows=10,000,000 loops=1)

2.          

SubPlan (forFunction Scan)

3. 0.000 0.000 ↑ 1.0 1 10,000,000

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=10,000,000)

  • One-Time Filter: ((-1) < z.z)