explain.depesz.com

PostgreSQL's explain analyze made readable

Result: MX54

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 0.130 ↑ 1.0 10 1

Limit (cost=100.00..101.15 rows=10 width=4) (actual time=0.126..0.130 rows=10 loops=1)

  • Output: 1
2. 0.127 0.127 ↑ 1.0 10 1

Remote Subquery Scan on all (pr_era_pgxl2_data,pr_era_pgxl3_data) (cost=100.00..101.15 rows=10 width=4) (actual time=0.125..0.127 rows=10 loops=1)

  • Output: 1