explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xFmT

Settings
# exclusive inclusive rows x rows loops node
1. 2,571.673 5,830.992 ↓ 83.0 105,216 1

Nested Loop Left Join (cost=0.57..8,592.50 rows=1,268 width=16) (actual time=272.549..5,830.992 rows=105,216 loops=1)

2. 944.567 944.567 ↓ 105.2 105,216 1

Function Scan on generate_series d (cost=0.01..10.01 rows=1,000 width=8) (actual time=272.476..944.567 rows=105,216 loops=1)

3. 2,314.752 2,314.752 ↑ 1.0 1 105,216

Index Scan using profile_coeff_ff_series_pkey on profile_coeff_ff_series origin (cost=0.56..8.57 rows=1 width=16) (actual time=0.016..0.022 rows=1 loops=105,216)