explain.depesz.com

PostgreSQL's explain analyze made readable

Result: X8rO

Settings
# exclusive inclusive rows x rows loops node
1. 0.076 56.164 ↓ 0.0 0 1

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

  • Hash Cond: (f.dim_repair_order_id = fll_3.dim_repair_order_id)
2. 3.917 3.917 ↑ 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=3.917..3.917 rows=1 loops=1)

3. 0.000 52.171 ↓ 0.0 0 1

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

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

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

  • Group Key: fll_3.dim_repair_order_id
5. 52.014 52.014 ↓ 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=52.014..52.014 rows=0 loops=1)