explain.depesz.com

PostgreSQL's explain analyze made readable

Result: k1FN

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

GroupAggregate (cost=0..0 rows=0 width=0) (actual time=377.649..377.837 rows=16 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, eventtypes.source_required_to_restore
2. 28.063 395.879 ↓ 0.0 42 1

Gather Merge (cost=0..0 rows=0 width=0) (actual time=377.637..395.879 rows=42 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 0.148 367.816 ↓ 0.0 14 3 / 3

GroupAggregate (cost=0..0 rows=0 width=0) (actual time=367.737..367.816 rows=14 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, eventtypes.source_required_to_restore
4. 0.723 367.668 ↓ 0.0 239 3 / 3

Sort (cost=0..0 rows=0 width=0) (actual time=367.647..367.668 rows=239 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, eventtypes.source_required_to_restore
  • Sort Method: quicksort Memory: 61kB
5. 0.317 366.945 ↓ 0.0 239 3 / 3

Nested Loop (cost=0..0 rows=0 width=0) (actual time=203.182..366.945 rows=239 loops=3)

6. 0.223 366.389 ↓ 0.0 239 3 / 3

Nested Loop (cost=0..0 rows=0 width=0) (actual time=203.161..366.389 rows=239 loops=3)

7. 0.180 365.689 ↓ 0.0 239 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual time=203.147..365.689 rows=239 loops=3)

8. 0.197 365.487 ↓ 0.0 239 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual time=203.107..365.487 rows=239 loops=3)

9. 0.284 365.277 ↓ 0.0 239 3 / 3

Nested Loop (cost=0..0 rows=0 width=0) (actual time=203.079..365.277 rows=239 loops=3)

10. 12.458 364.277 ↓ 0.0 239 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual time=203.02..364.277 rows=239 loops=3)

11. 28.782 351.807 ↓ 0.0 177,175 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual time=201.496..351.807 rows=177,175 loops=3)

12. 170.310 323.016 ↓ 0.0 177,175 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual time=201.472..323.016 rows=177,175 loops=3)

13. 12.869 65.840 ↓ 0.0 177,175 3 / 3

Append (cost=0..0 rows=0 width=0) (actual time=0.155..65.84 rows=177,175 loops=3)

14. 45.489 45.489 ↓ 0.0 151,424 3 / 3

Seq Scan on d_202008_01000 d_17 (cost=0..0 rows=0 width=0) (actual time=0.13..45.489 rows=151,424 loops=3)

15. 1.443 1.443 ↓ 0.0 12,673 1 / 3

Seq Scan on d_202008_00273 d_13 (cost=0..0 rows=0 width=0) (actual time=0.151..4.328 rows=12,673 loops=1)

16. 1.402 1.402 ↓ 0.0 12,671 1 / 3

Seq Scan on d_202008_00042 d_10 (cost=0..0 rows=0 width=0) (actual time=0.005..4.206 rows=12,671 loops=1)

17. 1.133 1.133 ↓ 0.0 8,348 2 / 3

Seq Scan on d_202008_00039 d_7 (cost=0..0 rows=0 width=0) (actual time=0.007..1.699 rows=8,348 loops=2)

18. 0.611 0.611 ↓ 0.0 8,318 1 / 3

Seq Scan on d_202008_00043 d_11 (cost=0..0 rows=0 width=0) (actual time=0.004..1.832 rows=8,318 loops=1)

19. 0.532 0.532 ↓ 0.0 7,569 1 / 3

Seq Scan on d_202008_00276 d_15 (cost=0..0 rows=0 width=0) (actual time=0.005..1.595 rows=7,569 loops=1)

20. 0.974 0.974 ↓ 0.0 6,740 1 / 3

Seq Scan on d_202008_00053 d_12 (cost=0..0 rows=0 width=0) (actual time=0.015..2.922 rows=6,740 loops=1)

21. 0.669 0.669 ↓ 0.0 7,489 1 / 3

Seq Scan on d_202008_00277 d_16 (cost=0..0 rows=0 width=0) (actual time=0.007..2.008 rows=7,489 loops=1)

22. 0.176 0.176 ↓ 0.0 2,387 1 / 3

Seq Scan on d_202008_00041 d_9 (cost=0..0 rows=0 width=0) (actual time=0.004..0.528 rows=2,387 loops=1)

23. 0.340 0.340 ↓ 0.0 2,385 1 / 3

Seq Scan on d_202008_00274 d_14 (cost=0..0 rows=0 width=0) (actual time=0.022..1.02 rows=2,385 loops=1)

24. 0.136 0.136 ↓ 0.0 258 1 / 3

Seq Scan on d_202008_01005 d_19 (cost=0..0 rows=0 width=0) (actual time=0.016..0.408 rows=258 loops=1)

25. 0.001 0.001 ↓ 0.0 0 1 / 3

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

26. 0.000 0.000 ↓ 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.001 rows=0 loops=1)

27. 0.001 0.001 ↓ 0.0 0 1 / 3

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

28. 0.000 0.000 ↓ 0.0 0 1 / 3

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

29. 0.001 0.001 ↓ 0.0 0 1 / 3

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

30. 0.001 0.001 ↓ 0.0 0 1 / 3

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

31. 0.000 0.000 ↓ 0.0 0 1 / 3

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

32. 0.045 0.045 ↓ 0.0 65 1 / 3

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

33. 0.019 0.019 ↓ 0.0 1 1 / 3

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

34. 46.460 86.866 ↓ 0.0 198,453 3 / 3

Hash (cost=0..0 rows=0 width=0) (actual time=86.864..86.866 rows=198,453 loops=3)

35. 40.406 40.406 ↓ 0.0 198,453 3 / 3

Seq Scan on datas_process p (cost=0..0 rows=0 width=0) (actual time=0.018..40.406 rows=198,453 loops=3)

36. 0.003 0.009 ↓ 0.0 3 3 / 3

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

37. 0.006 0.006 ↓ 0.0 3 3 / 3

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

38. 0.002 0.012 ↓ 0.0 7 3 / 3

Hash (cost=0..0 rows=0 width=0) (actual time=0.012..0.012 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.007..0.01 rows=7 loops=3)

  • Filter: isopen
40. 0.716 0.716 ↓ 0.0 1 716 / 3

Index Scan using accounts__pkey1 on accounts accounts (cost=0..0 rows=0 width=0) (actual time=0.003..0.003 rows=1 loops=716)

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

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

42. 0.010 0.010 ↓ 0.0 8 3 / 3

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

43. 0.007 0.022 ↓ 0.0 4 3 / 3

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

44. 0.015 0.015 ↓ 0.0 4 3 / 3

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

45. 0.477 0.477 ↓ 0.0 1 716 / 3

Index Scan using pk_ideventypes on eventtypes eventtypes (cost=0..0 rows=0 width=0) (actual time=0.002..0.002 rows=1 loops=716)

  • Index Cond: (ideventtype = d_17.ideventtype)
46. 0.239 0.239 ↓ 0.0 1 716 / 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=716)

  • Index Cond: (idpriority = d_17.priority)
  • Heap Fetches: 716