explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IP4G

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

GroupAggregate (cost=0..0 rows=0 width=0) (actual time=384.884..385.309 rows=65 loops=1)

  • Group Key: accounts.idaccount, d_17.ideventtype, d_17.source, d_17.idequipment, eventtypes.auto_close_on_event_defined, eventtypes.enable_auto_close_on_event_defined
2. 26.792 400.051 ↓ 0.0 130 1

Gather Merge (cost=0..0 rows=0 width=0) (actual time=384.868..400.051 rows=130 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 4.876 373.259 ↓ 0.0 43 3 / 3

GroupAggregate (cost=0..0 rows=0 width=0) (actual time=370.723..373.259 rows=43 loops=3)

  • Group Key: accounts.idaccount, d_17.ideventtype, d_17.source, d_17.idequipment, eventtypes.auto_close_on_event_defined, eventtypes.enable_auto_close_on_event_defined
4. 5.149 368.383 ↓ 0.0 5,544 3 / 3

Sort (cost=0..0 rows=0 width=0) (actual time=367.85..368.383 rows=5,544 loops=3)

  • Sort Key: accounts.idaccount, d_17.ideventtype, d_17.source, d_17.idequipment, eventtypes.auto_close_on_event_defined, eventtypes.enable_auto_close_on_event_defined
  • Sort Method: quicksort Memory: 842kB
5. 4.386 363.234 ↓ 0.0 5,544 3 / 3

Nested Loop (cost=0..0 rows=0 width=0) (actual time=185.74..363.234 rows=5,544 loops=3)

6. 2.661 353.304 ↓ 0.0 5,544 3 / 3

Nested Loop (cost=0..0 rows=0 width=0) (actual time=185.719..353.304 rows=5,544 loops=3)

7. 1.424 345.099 ↓ 0.0 5,544 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual time=185.702..345.099 rows=5,544 loops=3)

8. 1.319 343.640 ↓ 0.0 5,544 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual time=185.649..343.64 rows=5,544 loops=3)

9. 3.052 342.310 ↓ 0.0 5,544 3 / 3

Nested Loop (cost=0..0 rows=0 width=0) (actual time=185.621..342.31 rows=5,544 loops=3)

10. 10.556 333.714 ↓ 0.0 5,544 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual time=185.582..333.714 rows=5,544 loops=3)

11. 29.125 323.145 ↓ 0.0 128,980 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual time=181.222..323.145 rows=128,980 loops=3)

12. 160.139 294.009 ↓ 0.0 128,980 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual time=181.196..294.009 rows=128,980 loops=3)

13. 9.766 63.452 ↓ 0.0 128,980 3 / 3

Append (cost=0..0 rows=0 width=0) (actual time=0.041..63.452 rows=128,980 loops=3)

14. 40.305 40.305 ↓ 0.0 109,586 3 / 3

Seq Scan on d_202008_01000 d_17 (cost=0..0 rows=0 width=0) (actual time=0.02..40.305 rows=109,586 loops=3)

15. 3.715 3.715 ↓ 0.0 16,697 1 / 3

Seq Scan on d_202008_00039 d_7 (cost=0..0 rows=0 width=0) (actual time=0.026..11.146 rows=16,697 loops=1)

16. 1.206 1.206 ↓ 0.0 8,078 1 / 3

Seq Scan on d_202008_00273 d_13 (cost=0..0 rows=0 width=0) (actual time=0.034..3.617 rows=8,078 loops=1)

17. 1.040 1.040 ↓ 0.0 8,076 1 / 3

Seq Scan on d_202008_00042 d_10 (cost=0..0 rows=0 width=0) (actual time=0.04..3.119 rows=8,076 loops=1)

18. 0.483 0.483 ↓ 0.0 3,330 2 / 3

Seq Scan on d_202008_00043 d_11 (cost=0..0 rows=0 width=0) (actual time=0.004..0.725 rows=3,330 loops=2)

19. 0.983 0.983 ↓ 0.0 6,274 1 / 3

Seq Scan on d_202008_00277 d_16 (cost=0..0 rows=0 width=0) (actual time=0.012..2.95 rows=6,274 loops=1)

20. 0.523 0.523 ↓ 0.0 4,021 1 / 3

Seq Scan on d_202008_00276 d_15 (cost=0..0 rows=0 width=0) (actual time=0.007..1.569 rows=4,021 loops=1)

21. 0.377 0.377 ↓ 0.0 3,634 1 / 3

Seq Scan on d_202008_00053 d_12 (cost=0..0 rows=0 width=0) (actual time=0.004..1.131 rows=3,634 loops=1)

22. 4.609 4.609 ↓ 0.0 2,219 1 / 3

Seq Scan on d_202008_00041 d_9 (cost=0..0 rows=0 width=0) (actual time=0.032..13.828 rows=2,219 loops=1)

23. 0.365 0.365 ↓ 0.0 2,217 1 / 3

Seq Scan on d_202008_00274 d_14 (cost=0..0 rows=0 width=0) (actual time=0.011..1.094 rows=2,217 loops=1)

24. 0.053 0.053 ↓ 0.0 240 1 / 3

Seq Scan on d_202008_01005 d_19 (cost=0..0 rows=0 width=0) (actual time=0.01..0.16 rows=240 loops=1)

25. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on d_202007_01008 d_6 (cost=0..0 rows=0 width=0) (actual time=0..0 rows=0 loops=1)

26. 0.001 0.001 ↓ 0.0 0 1 / 3

Seq Scan on d_202007_01000 d_3 (cost=0..0 rows=0 width=0) (actual time=0.001..0.002 rows=0 loops=1)

27. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on d_202007_01002 d_4 (cost=0..0 rows=0 width=0) (actual time=0.001..0.001 rows=0 loops=1)

28. 0.001 0.001 ↓ 0.0 0 1 / 3

Seq Scan on d_201901_01003 d (cost=0..0 rows=0 width=0) (actual time=0.002..0.002 rows=0 loops=1)

29. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on d_202007_00068 d_2 (cost=0..0 rows=0 width=0) (actual time=0.001..0.001 rows=0 loops=1)

30. 0.000 0.000 ↓ 0.0 0 1 / 3

Seq Scan on d_202007_01005 d_5 (cost=0..0 rows=0 width=0) (actual time=0.001..0.001 rows=0 loops=1)

31. 0.001 0.001 ↓ 0.0 0 1 / 3

Seq Scan on d_202007_00066 d_1 (cost=0..0 rows=0 width=0) (actual time=0.002..0.003 rows=0 loops=1)

32. 0.012 0.012 ↓ 0.0 65 1 / 3

Seq Scan on d_202008_00040 d_8 (cost=0..0 rows=0 width=0) (actual time=0.013..0.036 rows=65 loops=1)

33. 0.011 0.011 ↓ 0.0 1 1 / 3

Seq Scan on d_202008_01002 d_18 (cost=0..0 rows=0 width=0) (actual time=0.031..0.032 rows=1 loops=1)

34. 37.514 70.418 ↓ 0.0 144,715 3 / 3

Hash (cost=0..0 rows=0 width=0) (actual time=70.416..70.418 rows=144,715 loops=3)

35. 32.904 32.904 ↓ 0.0 144,715 3 / 3

Seq Scan on datas_process p (cost=0..0 rows=0 width=0) (actual time=0.029..32.904 rows=144,715 loops=3)

36. 0.003 0.011 ↓ 0.0 3 3 / 3

Hash (cost=0..0 rows=0 width=0) (actual time=0.011..0.011 rows=3 loops=3)

37. 0.008 0.008 ↓ 0.0 3 3 / 3

Seq Scan on reception_modes reception_modes (cost=0..0 rows=0 width=0) (actual time=0.008..0.008 rows=3 loops=3)

38. 0.003 0.013 ↓ 0.0 7 3 / 3

Hash (cost=0..0 rows=0 width=0) (actual time=0.013..0.013 rows=7 loops=3)

39. 0.010 0.010 ↓ 0.0 7 3 / 3

Seq Scan on statustypes statustypes (cost=0..0 rows=0 width=0) (actual time=0.008..0.01 rows=7 loops=3)

  • Filter: isopen
40. 5.544 5.544 ↓ 0.0 1 16,631 / 3

Index Scan using accounts__pkey1 on accounts accounts (cost=0..0 rows=0 width=0) (actual time=0.001..0.001 rows=1 loops=16,631)

  • Index Cond: (idaccount = d_17.idaccount)
41. 0.003 0.011 ↓ 0.0 8 3 / 3

Hash (cost=0..0 rows=0 width=0) (actual time=0.011..0.011 rows=8 loops=3)

42. 0.008 0.008 ↓ 0.0 8 3 / 3

Seq Scan on divisions divisions (cost=0..0 rows=0 width=0) (actual time=0.007..0.008 rows=8 loops=3)

43. 0.006 0.035 ↓ 0.0 4 3 / 3

Hash (cost=0..0 rows=0 width=0) (actual time=0.034..0.035 rows=4 loops=3)

44. 0.029 0.029 ↓ 0.0 4 3 / 3

Seq Scan on account_states account_states (cost=0..0 rows=0 width=0) (actual time=0.028..0.029 rows=4 loops=3)

45. 5.544 5.544 ↓ 0.0 1 16,631 / 3

Index Scan using pk_ideventypes on eventtypes eventtypes (cost=0..0 rows=0 width=0) (actual time=0.001..0.001 rows=1 loops=16,631)

  • Index Cond: (ideventtype = d_17.ideventtype)
46. 5.544 5.544 ↓ 0.0 1 16,631 / 3

Index Only Scan using priority_levels_pkey on priority_levels priority_levels (cost=0..0 rows=0 width=0) (actual time=0.001..0.001 rows=1 loops=16,631)

  • Index Cond: (idpriority = d_17.priority)
  • Heap Fetches: 16,631