explain.depesz.com

PostgreSQL's explain analyze made readable

Result: siUB

Settings
# exclusive inclusive rows x rows loops node
1. 0.049 3.109 ↓ 0.0 0 1

Hash Join (cost=1,568,770.63..2,700,348.07 rows=10,003,330 width=8) (actual time=3.109..3.109 rows=0 loops=1)

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

3. 0.000 1.327 ↓ 0.0 0 1

Hash (cost=1,568,454.59..1,568,454.59 rows=25,283 width=8) (actual time=1.327..1.327 rows=0 loops=1)

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

HashAggregate (cost=1,567,948.93..1,568,201.76 rows=25,283 width=8) (actual time=1.327..1.327 rows=0 loops=1)

  • Group Key: fll.dim_repair_order_id
5. 1.155 1.155 ↓ 0.0 0 1

Remote Subquery Scan on all (pr_era_pgxl2_data,pr_era_pgxl3_data) (cost=1,901.75..1,559,838.12 rows=3,244,323 width=8) (actual time=1.155..1.155 rows=0 loops=1)