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
  • NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, osversion, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL FROM phonebinary_common
  • NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL FROM fusclientlog WHERE ((imeinum)::text <> 'WEBDL') AND ((imeinum)::text NOT LIKE '%£ø%') AND (totaldltime <= 21600) AND (totaldltime >= 0) AND (webdltime <= 21600) AND (webdltime >= 0) AND (phonedltime <= 21600) AND (phonedltime >= 0) AND (accessmode = '2')
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,P,Q}'::bpchar[])) AND (logdateserver < ((to_timestamp(concat('2019-10-26', '-', '090000000000'), 'YYYY-MM-DD-HH24MISSFF6'::text))::timestamp without time zone + 1)))
  • Remote Query: SELECT model, imeinum, buyercode, localcode, currentversion, updateversion, webdltime, phonedltime, totaldltime, NULL, logdateserver, NULL, NULL, NULL, NULL, upgrademode, clientapp, clientversion, NULL, agentversion, NULL, pluginversion, resultcode, accessmode, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL, NULL,
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')