explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6eYI

Settings
# exclusive inclusive rows x rows loops node
1. 0.178 6.935 ↓ 0.0 0 1

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

  • Group Key: fll.dim_repair_order_id
2. 6.757 6.757 ↓ 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=6.757..6.757 rows=0 loops=1)