# Result: OAyi

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

(cost=58,189.15..68,585.39 rows=186 width=220) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

(cost=58,189.15..59,055.23 rows=346,433 width=196) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

(cost=369.74..6,893.82 rows=346,433 width=196) (actual rows= loops=)

• Hash Cond: (com.commodity_code = comtrade_data_annual_refined.commodity_code)
4. 0.000 0.000 ↓ 0.0

Seq Scan on commodities com (cost=0.00..780.20 rows=36,520 width=64) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

(cost=346.03..346.03 rows=1,897 width=176) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

(cost=289.01..346.03 rows=1,897 width=176) (actual rows= loops=)

• Hash Cond: (reg.country_code = (842))
7. 0.000 0.000 ↓ 0.0

Seq Scan on region_countries reg (cost=0.00..30.40 rows=2,040 width=12) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

(cost=286.68..286.68 rows=186 width=172) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

(cost=281.03..286.68 rows=186 width=172) (actual rows= loops=)

• Hash Cond: (comtrade_data_annual_refined.partner_code = par.reporter_code)
10. 0.000 0.000 ↓ 0.0

(cost=145.92..151.07 rows=186 width=140) (actual rows= loops=)

• Hash Cond: ((842) = rep.reporter_code)
11. 0.000 0.000 ↓ 0.0

(cost=10.80..13.59 rows=186 width=140) (actual rows= loops=)

12. 0.000 0.000 ↓ 0.0

• Index Cond: ((year = '2018'::text) AND (reporter_code = 842))
13. 0.000 0.000 ↓ 0.0

(cost=132.61..132.61 rows=200 width=36) (actual rows= loops=)

14. 0.000 0.000 ↓ 0.0

Subquery Scan on rep (cost=129.61..132.61 rows=200 width=36) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

(cost=129.61..130.61 rows=200 width=68) (actual rows= loops=)

16. 0.000 0.000 ↓ 0.0

(cost=129.61..130.11 rows=200 width=68) (actual rows= loops=)

• Sort Key: (COALESCE(reporters.reporter_code, partners.partner_code))
17. 0.000 0.000 ↓ 0.0

(cost=119.97..121.97 rows=200 width=68) (actual rows= loops=)

• Group Key: COALESCE(reporters.reporter_code, partners.partner_code)
18. 0.000 0.000 ↓ 0.0

WindowAgg (cost=87.94..106.24 rows=915 width=136) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

(cost=87.94..90.23 rows=915 width=123) (actual rows= loops=)

• Sort Key: (COALESCE(reporters.reporter, partners.partner))
20. 0.000 0.000 ↓ 0.0

(cost=9.97..42.94 rows=915 width=123) (actual rows= loops=)

• Hash Cond: (reporters.reporter_code = partners.partner_code)
21. 0.000 0.000 ↓ 0.0

Seq Scan on reporters (cost=0.00..18.50 rows=850 width=68) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

(cost=6.10..6.10 rows=310 width=19) (actual rows= loops=)

23. 0.000 0.000 ↓ 0.0

Seq Scan on partners (cost=0.00..6.10 rows=310 width=19) (actual rows= loops=)

24. 0.000 0.000 ↓ 0.0

(cost=132.61..132.61 rows=200 width=36) (actual rows= loops=)

25. 0.000 0.000 ↓ 0.0

Subquery Scan on par (cost=129.61..132.61 rows=200 width=36) (actual rows= loops=)

26. 0.000 0.000 ↓ 0.0

(cost=129.61..130.61 rows=200 width=68) (actual rows= loops=)

27. 0.000 0.000 ↓ 0.0

(cost=129.61..130.11 rows=200 width=68) (actual rows= loops=)

• Sort Key: (COALESCE(reporters_1.reporter_code, partners_1.partner_code))
28. 0.000 0.000 ↓ 0.0

(cost=119.97..121.97 rows=200 width=68) (actual rows= loops=)

• Group Key: COALESCE(reporters_1.reporter_code, partners_1.partner_code)
29. 0.000 0.000 ↓ 0.0

WindowAgg (cost=87.94..106.24 rows=915 width=136) (actual rows= loops=)

30. 0.000 0.000 ↓ 0.0

(cost=87.94..90.23 rows=915 width=123) (actual rows= loops=)

• Sort Key: (COALESCE(reporters_1.reporter, partners_1.partner))
31. 0.000 0.000 ↓ 0.0

(cost=9.97..42.94 rows=915 width=123) (actual rows= loops=)

• Hash Cond: (reporters_1.reporter_code = partners_1.partner_code)
32. 0.000 0.000 ↓ 0.0

Seq Scan on reporters reporters_1 (cost=0.00..18.50 rows=850 width=68) (actual rows= loops=)

33. 0.000 0.000 ↓ 0.0

(cost=6.10..6.10 rows=310 width=19) (actual rows= loops=)

34. 0.000 0.000 ↓ 0.0

Seq Scan on partners partners_1 (cost=0.00..6.10 rows=310 width=19) (actual rows= loops=)
{"ft_lang_label":"__label__en","ft_lang_prob":0.51312786,"math_prob":0.9964872,"size":3696,"snap":"2020-34-2020-40","text_gpt3_token_len":1637,"char_repetition_ratio":0.3317985,"word_repetition_ratio":0.46387833,"special_character_ratio":0.61498916,"punctuation_ratio":0.27555987,"nsfw_num_words":0,"has_unicode_error":false,"math_prob_llama3":0.983395,"pos_list":[0],"im_url_duplicate_count":[null],"WARC_HEADER":"{\"WARC-Type\":\"response\",\"WARC-Date\":\"2020-09-25T15:56:28Z\",\"WARC-Record-ID\":\"<urn:uuid:adbcca00-d3c0-4a28-997b-8eb8f15c4899>\",\"Content-Length\":\"70897\",\"Content-Type\":\"application/http; msgtype=response\",\"WARC-Warcinfo-ID\":\"<urn:uuid:72223400-4b43-4b73-8f37-0c9580309bc7>\",\"WARC-Concurrent-To\":\"<urn:uuid:711bd1e9-3564-4872-bdbc-d5f080200407>\",\"WARC-IP-Address\":\"88.198.49.178\",\"WARC-Target-URI\":\"https://explain.depesz.com/s/OAyi\",\"WARC-Payload-Digest\":\"sha1:3GH4GO4WXYYVM2E7RO4HE3JPIZKM2KW6\",\"WARC-Block-Digest\":\"sha1:33E5TIZDKMZMAC33HKPSPXVFCU36M6M4\",\"WARC-Identified-Payload-Type\":\"text/html\",\"warc_filename\":\"/cc_download/warc_2020/CC-MAIN-2020-40/CC-MAIN-2020-40_segments_1600400227524.63_warc_CC-MAIN-20200925150904-20200925180904-00214.warc.gz\"}"}