explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hpmy

Settings
# exclusive inclusive rows x rows loops node
1. 0.175 0.714 ↓ 0.0 0 1

HashAggregate (cost=161,060.95..161,313.78 rows=25,283 width=8) (actual time=0.714..0.714 rows=0 loops=1)

  • Group Key: fll.dim_repair_order_id
2. 0.539 0.539 ↓ 0.0 0 1

Remote Subquery Scan on all (pr_era_pgxl2_data,pr_era_pgxl3_data) (cost=1,954.92..160,674.72 rows=154,492 width=8) (actual time=0.539..0.539 rows=0 loops=1)