explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 48Z8

Settings
# exclusive inclusive rows x rows loops node
1. 4,436,259.881 4,490,331.092 ↓ 851,416.0 851,416 1

Subquery Scan on q (cost=7,190,067.38..7,214,342.22 rows=1 width=796) (actual time=50,293.185..4,490,331.092 rows=851,416 loops=1)

2. 23,028.064 23,028.064 ↓ 53.2 678,520 1

Subquery Scan on f_1 (cost=3,591,574.33..3,593,764.25 rows=12,757 width=682) (actual time=21,626.454..23,028.064 rows=678,520 loops=1)

3. 10,820.793 10,820.793 ↓ 13.7 1,774,052 1

Append (cost=1,540,510.43..3,586,619.30 rows=129,820 width=994) (actual time=5,514.048..10,820.793 rows=1,774,052 loops=1)

4. 20,222.354 20,222.354 ↓ 53.2 678,520 1

Subquery Scan on f_2 (cost=3,591,574.33..3,593,764.25 rows=12,757 width=604) (actual time=18,819.957..20,222.354 rows=678,520 loops=1)