explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6if0

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 140.423 ↑ 38.5 52 1

Append (cost=0.00..20.00 rows=2,000 width=32) (actual time=117.697..140.423 rows=52 loops=1)

2. 117.716 117.716 ↑ 37.0 27 1

Function Scan on dblink t (cost=0.00..10.00 rows=1,000 width=32) (actual time=117.695..117.716 rows=27 loops=1)

3. 22.701 22.701 ↑ 40.0 25 1

Function Scan on dblink t_1 (cost=0.00..10.00 rows=1,000 width=32) (actual time=22.700..22.701 rows=25 loops=1)

Planning time : 0.045 ms