explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rnvW

Settings
# exclusive inclusive rows x rows loops node
1. 0.217 11.002 ↓ 0.0 0 1

Hash Join (cost=167,912.93..1,299,490.38 rows=10,003,330 width=4) (actual time=11.002..11.002 rows=0 loops=1)

  • Hash Cond: (f.dim_repair_order_id = fll_3.dim_repair_order_id)
2. 8.444 8.444 ↑ 10,003,330.0 1 1

Remote Subquery Scan on all (pr_era_pgxl2_data,pr_era_pgxl3_data) (cost=100.00..1,235,457.59 rows=10,003,330 width=8) (actual time=8.444..8.444 rows=1 loops=1)

3. 0.002 2.341 ↓ 0.0 0 1

Hash (cost=167,596.89..167,596.89 rows=25,283 width=8) (actual time=2.341..2.341 rows=0 loops=1)

  • Buckets: 32,768 Batches: 1 Memory Usage: 256kB
4. 0.172 2.339 ↓ 0.0 0 1

HashAggregate (cost=167,091.23..167,344.06 rows=25,283 width=8) (actual time=2.339..2.339 rows=0 loops=1)

  • Group Key: fll_3.dim_repair_order_id
5. 2.167 2.167 ↓ 0.0 0 1

Remote Subquery Scan on all (pr_era_pgxl2_data,pr_era_pgxl3_data) (cost=100.34..166,698.02 rows=157,285 width=8) (actual time=2.167..2.167 rows=0 loops=1)