Comment le réseau électrique français a géré un mois d’hiver somme toute « normal » en janvier 2017

Depuis l’automne RTE (Réseaux de Transport d’Electricité, en charge de l’équilibre du réseau) s’inquiétait d’une fragilisation de nos moyens de production en raison de l’arrêt de plusieurs réacteurs, imposé par l’Autorité de Sureté Nucléaire (ASN). Début janvier Météo France annonçait l’arrivée d’une vague de froid et, le 18 janvier 2017, Madame Ségolène Royal affirmait : "Aujourd'hui, avec les très bonnes conditions météorologiques, les énergies renouvelables, l'éolien et le solaire, vont produire l'équivalent de huit réacteurs nucléaires, huit gigawatts", laissant entendre que les énergies renouvelables allaient assurer la stabilité du réseau. Vérité ou intox ?

C'est ce que Jean-Pierre Pervès a voulu mettre en évidence dans son étude : Comment le réseau électrique français a géré un mois d’hiver somme toute « normal » en janvier 2017.
Télécharger cette étude en pdf http://www.sauvonsleclimat.org/images/articles/pdf_files/etudes/Note_JPP_janvier-2017.pdf

Informations supplémentaires

Profil d'information

Application 0.003 seconds (+0.003); 0.20 MB (+0.20) - afterLoad
Application 0.036 seconds (+0.033); 0.65 MB (+0.45) - afterInitialise
Application 0.840 seconds (+0.804); 57.45 MB (+56.80) - afterRoute
Application 0.910 seconds (+0.070); 57.84 MB (+0.39) - afterDispatch
Application 1.841 seconds (+0.931); 64.24 MB (+6.40) - afterRender

Occupation de la mémoire

64.27 MB (67,392,800 Bytes)

20 requêtes exécutées

  1. SELECT `data`
      FROM `jos_session`
      WHERE `session_id` = 'bff283cfda64860fca614ad1ffcff689'
  2. DELETE
      FROM `jos_session`
      WHERE `time` < 1566360505
  3. SELECT `session_id`
      FROM `jos_session`
      WHERE `session_id` = 'bff283cfda64860fca614ad1ffcff689'
      LIMIT 0, 1
  4. INSERT INTO `jos_session` (`session_id`, `client_id`, `time`)
      VALUES ('bff283cfda64860fca614ad1ffcff689', 0, 1566362305)
  5. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_users'
  6. SELECT id, rules
      FROM `jos_viewlevels`
  7. SELECT folder AS type, element AS name, params
      FROM jos_extensions
      WHERE enabled >= 1
      AND type ='plugin'
      AND state >= 0
      AND access IN (1,1,2,5)
      ORDER BY ordering
  8. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_languages'
  9. SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component
      FROM jos_menu AS m
      LEFT JOIN jos_extensions AS e
      ON m.component_id = e.extension_id
      WHERE m.published = 1
      AND m.parent_id > 0
      AND m.access IN (1,1,2,5)
      ORDER BY m.lft
  10. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_content'
  11. SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug
      FROM jos_categories as c
      LEFT JOIN (SELECT cat.id as id
      FROM jos_categories AS cat JOIN jos_categories AS parent
      ON cat.lft BETWEEN parent.lft
      AND parent.rgt
      WHERE parent.extension = 'com_content'
      AND parent.published != 1
      GROUP BY cat.id) AS badcats
      ON badcats.id = c.id
      WHERE (c.extension='com_content' OR c.extension='system')
      AND c.access IN (1,1,2,5)
      AND c.published = 1
      AND badcats.id is null
      GROUP BY c.id
      ORDER BY c.lft
  12. SELECT *
      FROM jos_languages
      WHERE published=1
  13. SELECT id, home, template, params
      FROM jos_template_styles
      WHERE client_id = 0
  14. SELECT a.rules
      FROM jos_assets AS a
      WHERE (a.id = 1)
      GROUP BY a.id
  15. SELECT b.rules
      FROM jos_assets AS a
      LEFT JOIN jos_assets AS b
      ON b.lft <= a.lft
      AND b.rgt >= a.rgt
      WHERE (a.name = 'com_content' OR a.parent_id=0)
      GROUP BY b.id
      ORDER BY b.lft
  16. SELECT a.*,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count
      FROM jos_content AS a
      LEFT JOIN jos_categories AS c
      on c.id = a.catid
      LEFT JOIN jos_users AS u
      on u.id = a.created_by
      LEFT JOIN jos_categories as parent
      ON parent.id = c.parent_id
      LEFT JOIN jos_content_rating AS v
      ON a.id = v.content_id
      WHERE a.id = 1962
      AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-08-21 04:38:26')
      AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-08-21 04:38:26')
      AND (a.state = 1 OR a.state =2)
  17. UPDATE jos_content
      SET hits = hits + 1
      WHERE id = 1962
  18. SELECT id, title, module, position, content, showtitle, params, mm.menuid
      FROM jos_modules AS m
      LEFT JOIN jos_modules_menu AS mm
      ON mm.moduleid = m.id
      WHERE m.published = 1
      AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2019-08-21 04:38:26')
      AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-08-21 04:38:26')
      AND m.access IN (1,1,2,5)
      AND m.client_id = 0
      AND (mm.menuid = 32383 OR mm.menuid <= 0)
      ORDER BY position, ordering
  19. SELECT extension_id AS "id", element AS "option", params, enabled
      FROM jos_extensions
      WHERE `type` = 'component'
      AND `element` = 'com_fpcontent'
  20. UPDATE `jos_session`
      SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1566362305;s:18:\"session.timer.last\";i:1566362305;s:17:\"session.timer.now\";i:1566362305;s:24:\"session.client.forwarded\";s:14:\"34.238.189.171\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;s:1:\"1\";}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:5;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}', `time` = 1566362307
      WHERE `session_id` = 'bff283cfda64860fca614ad1ffcff689'

17 types de requêtes exécutées, triées par occurrences DESC

Tables sélectionnées :
  1. 4 × SELECT extension_id AS "id", element AS "option", params, enabled FROM jos_extensions
  2. 1 × SELECT a.rules FROM jos_assets AS a
  3. 1 × SELECT id, home, template, params FROM jos_template_styles
  4. 1 × SELECT b.rules FROM jos_assets AS a LEFT JOIN jos_assets AS b ON b.lft <= a.lft AND b.rgt >= a.rgt
  5. 1 × SELECT a.*,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND( v.rating_sum / v.rating_count ) AS rating, v.rating_count as rating_count FROM jos_content AS a LEFT JOIN jos_categories AS c on c.id = a.catid LEFT JOIN jos_users AS u on u.id = a.created_by LEFT JOIN jos_categories as parent ON parent.id = c.parent_id LEFT JOIN jos_content_rating AS v ON a.id = v.content_id
  6. 1 × SELECT id, title, module, position, content, showtitle, params, mm.menuid FROM jos_modules AS m LEFT JOIN jos_modules_menu AS mm ON mm.moduleid = m.id
  7. 1 × SELECT * FROM jos_languages
  8. 1 × SELECT c.*,CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(":", c.id, c.alias) ELSE c.id END as slug FROM jos_categories as c LEFT JOIN (SELECT cat.id as id FROM jos_categories AS cat JOIN jos_categories AS parent ON cat.lft BETWEEN parent.lft AND parent.rgt
  9. 1 × SELECT `session_id` FROM `jos_session`
  10. 1 × SELECT id, rules FROM `jos_viewlevels
  11. 1 × SELECT folder AS type, element AS name, params FROM jos_extensions
  12. 1 × SELECT m.id, m.menutype, m.title, m.alias, m.path AS route, m.link, m.type, m.level,m.browserNav, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,m.language,e.element as component FROM jos_menu AS m LEFT JOIN jos_extensions AS e ON m.component_id = e.extension_id
  13. 1 × SELECT `data` FROM `jos_session`
Autres tables :
  1. 1 × UPDATE `jos_session` SET `data` = '__default|a:8:{s:15:\"session.counter\";i:1;s:19:\"session.timer.start\";i:1566362305;s:18:\"session.timer.last\";i:1566362305;s:17:\"session.timer.now\";i:1566362305;s:24:\"session.client.forwarded\";s:14:\"34.238.189.171\";s:22:\"session.client.browser\";s:40:\"CCBot/2.0 (https://commoncrawl.org/faq/)\";s:8:\"registry\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:4:\"user\";O:5:\"JUser\":23:{s:9:\"\0*\0isRoot\";b:0;s:2:\"id\";i:0;s:4:\"name\";N;s:8:\"username\";N;s:5:\"email\";N;s:8:\"password\";N;s:14:\"password_clear\";s:0:\"\";s:8:\"usertype\";N;s:5:\"block\";N;s:9:\"sendEmail\";i:0;s:12:\"registerDate\";N;s:13:\"lastvisitDate\";N;s:10:\"activation\";N;s:6:\"params\";N;s:6:\"groups\";a:0:{}s:5:\"guest\";i:1;s:10:\"\0*\0_params\";O:9:\"JRegistry\":1:{s:7:\"\0*\0data\";O:8:\"stdClass\":0:{}}s:14:\"\0*\0_authGroups\";a:1:{i:0;s:1:\"1\";}s:14:\"\0*\0_authLevels\";a:4:{i:0;i:1;i:1;i:1;i:2;i:2;i:3;i:5;}s:15:\"\0*\0_authActions\";N;s:12:\"\0*\0_errorMsg\";N;s:10:\"\0*\0_errors\";a:0:{}s:3:\"aid\";i:0;}}', `time` = 1566362307
  2. 1 × UPDATE jos_content SET hits = hits + 1
  3. 1 × INSERT INTO `jos_session` (`session_id`, `client_id`, `time`) VALUES ('bff283cfda64860fca614ad1ffcff689', 0, 1566362305
  4. 1 × DELETE FROM `jos_session`