explain.depesz.com

PostgreSQL's explain analyze made readable

Result: blRc : 10

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

Sort (cost=132.07..132.32 rows=100 width=1,768) (actual rows= loops=)

  • Sort Key: a.logdateserver
2.          

CTE v_osversion_data

3. 0.000 0.000 ↓ 0.0

GroupAggregate (cost=25.17..25.30 rows=1 width=476) (actual rows= loops=)

  • Group Key: _dblink_phonebinary_common_1.model, _dblink_phonebinary_common_1.product_code, _dblink_phonebinary_common_1.sw_version
4. 0.000 0.000 ↓ 0.0

Sort (cost=25.17..25.19 rows=10 width=530) (actual rows= loops=)

  • Sort Key: _dblink_phonebinary_common_1.model, _dblink_phonebinary_common_1.product_code, _dblink_phonebinary_common_1.sw_version
5. 0.000 0.000 ↓ 0.0

Foreign Scan on _dblink_phonebinary_common_1 (cost=15.00..25.00 rows=10 width=530) (actual rows= loops=)

  • Remote Query: SELECT NULL, sw_version, NULL, NULL, NULL, NULL, product_code, model, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
6. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=80.32..103.44 rows=100 width=1,768) (actual rows= loops=)

  • Join Filter: (a.accessmode = (b.accessmode)::bpchar)
7. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=65.32..75.66 rows=10 width=1,578) (actual rows= loops=)

  • Hash Cond: (((a.model)::text = (f.model)::text) AND ((a.localcode)::bpchar = f.product_code) AND ((a.updateversion)::text = f.sw_version))
8. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=65.29..75.50 rows=10 width=1,546) (actual rows= loops=)

  • Hash Cond: (((a.model)::text = (e.model)::text) AND ((a.localcode)::bpchar = e.product_code) AND ((a.currentversion)::text = e.sw_version))
9. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=65.25..75.34 rows=10 width=1,514) (actual rows= loops=)

  • Hash Cond: (a.clientapp = d.appcode)
10. 0.000 0.000 ↓ 0.0

Hash Left Join (cost=40.12..50.17 rows=10 width=1,464) (actual rows= loops=)

  • Hash Cond: (a.upgrademode = (c.upgrademode)::bpchar)
11. 0.000 0.000 ↓ 0.0

Foreign Scan on _dblink_fusclientlog_2 a (cost=15.00..25.00 rows=10 width=1,394) (actual rows= loops=)

  • Filter: ((logdateserver >= to_timestamp(concat('2019-10-26', '-', '090000000000'), 'YYYY-MM-DD-HH24MISSFF6'::text)) AND (resultcode <> ALL ('{K,L,M,N,O
  • Remote Query: SELECT model, imeinum, buyercode, localcode, currentversion, updateversion, webdltime, phonedltime, totaldltime, NULL, logdateserver, NUL
12. 0.000 0.000 ↓ 0.0

Hash (cost=25.00..25.00 rows=10 width=86) (actual rows= loops=)

13. 0.000 0.000 ↓ 0.0

Foreign Scan on _dblink_fusclientupgrademode_4 c (cost=15.00..25.00 rows=10 width=86) (actual rows= loops=)

  • Remote Query: SELECT upgrademode, description FROM fusclientupgrademode
14. 0.000 0.000 ↓ 0.0

Hash (cost=25.00..25.00 rows=10 width=66) (actual rows= loops=)

15. 0.000 0.000 ↓ 0.0

Foreign Scan on _dblink_fusclientapp_5 d (cost=15.00..25.00 rows=10 width=66) (actual rows= loops=)

  • Remote Query: SELECT appname, NULL, appcode FROM fusclientapp
16. 0.000 0.000 ↓ 0.0

Hash (cost=0.02..0.02 rows=1 width=158) (actual rows= loops=)

17. 0.000 0.000 ↓ 0.0

CTE Scan on v_osversion_data e (cost=0.00..0.02 rows=1 width=158) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Hash (cost=0.02..0.02 rows=1 width=158) (actual rows= loops=)

19. 0.000 0.000 ↓ 0.0

CTE Scan on v_osversion_data f (cost=0.00..0.02 rows=1 width=158) (actual rows= loops=)

20. 0.000 0.000 ↓ 0.0

Materialize (cost=15.00..25.05 rows=10 width=86) (actual rows= loops=)

21. 0.000 0.000 ↓ 0.0

Foreign Scan on _dblink_fusclientaccessmode_3 b (cost=15.00..25.00 rows=10 width=86) (actual rows= loops=)

  • Remote Query: SELECT accessmode, description FROM fusclientaccessmode WHERE ((accessmode)::bpchar = '2')