explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1lN

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Group (cost=249,304.36..249,334.66 rows=2,424 width=39) (actual rows= loops=)

  • Group Key: rs.reseller_company_raw_id, rcr.vat_num, rcr.reseller_company_id, rcr.name
2. 0.000 0.000 ↓ 0.0

Sort (cost=249,304.36..249,310.42 rows=2,424 width=39) (actual rows= loops=)

  • Sort Key: rs.reseller_company_raw_id, rcr.vat_num, rcr.reseller_company_id, rcr.name
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=100.57..249,168.09 rows=2,424 width=39) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Seq Scan on reseller_company_raw_pre rs (cost=0.00..35.23 rows=2,423 width=4) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Foreign Scan on reseller_company_raw_fdw rcr (cost=100.57..102.81 rows=1 width=38) (actual rows= loops=)