explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sQts

Settings
# exclusive inclusive rows x rows loops node
1. 0.162 4.850 ↓ 0.0 0 1

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

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