explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M1X82

Settings
# exclusive inclusive rows x rows loops node
1. 35,218.938 35,218.938 ↑ 4.2 2,395,463 1

Remote Subquery Scan on all (pr_era_pgxl2_data,pr_era_pgxl3_data) (cost=1,702,356.55..2,945,216.64 rows=10,003,330 width=8) (actual time=28,287.339..35,218.938 rows=2,395,463 loops=1)

  • Output: f.fact_labor_line_id