explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 274z

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 589.490 ↓ 0.0 128,426 1

Gather (cost=0..0 rows=0 width=0) (actual time=137.1..589.49 rows=128,426 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 11.391 472.697 ↓ 0.0 42,809 3 / 3

Nested Loop (cost=0..0 rows=0 width=0) (actual time=133.354..472.697 rows=42,809 loops=3)

3. 26.949 418.497 ↓ 0.0 42,809 3 / 3

Nested Loop (cost=0..0 rows=0 width=0) (actual time=133.342..418.497 rows=42,809 loops=3)

4. 12.508 348.739 ↓ 0.0 42,809 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual time=133.324..348.739 rows=42,809 loops=3)

5. 13.591 336.214 ↓ 0.0 42,809 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual time=133.235..336.214 rows=42,809 loops=3)

6. 29.682 322.612 ↓ 0.0 42,809 3 / 3

Nested Loop (cost=0..0 rows=0 width=0) (actual time=133.211..322.612 rows=42,809 loops=3)

7. 18.031 250.121 ↓ 0.0 42,809 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual time=133.157..250.121 rows=42,809 loops=3)

8. 24.987 232.077 ↓ 0.0 117,606 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual time=131.286..232.077 rows=117,606 loops=3)

9. 120.748 207.081 ↓ 0.0 117,606 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual time=131.263..207.081 rows=117,606 loops=3)

10. 7.342 47.318 ↓ 0.0 117,606 3 / 3

Append (cost=0..0 rows=0 width=0) (actual time=0.015..47.318 rows=117,606 loops=3)

11. 33.690 33.690 ↓ 0.0 98,748 3 / 3

Seq Scan on d_202008_01000 d_17 (cost=0..0 rows=0 width=0) (actual time=0.029..33.69 rows=98,748 loops=3)

12. 1.586 1.586 ↓ 0.0 16,697 1 / 3

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

13. 1.209 1.209 ↓ 0.0 7,682 1 / 3

Seq Scan on d_202008_00273 d_13 (cost=0..0 rows=0 width=0) (actual time=0.01..3.628 rows=7,682 loops=1)

14. 0.668 0.668 ↓ 0.0 3,840 2 / 3

Seq Scan on d_202008_00042 d_10 (cost=0..0 rows=0 width=0) (actual time=0.008..1.002 rows=3,840 loops=2)

15. 0.968 0.968 ↓ 0.0 6,661 1 / 3

Seq Scan on d_202008_00043 d_11 (cost=0..0 rows=0 width=0) (actual time=0.004..2.904 rows=6,661 loops=1)

16. 0.875 0.875 ↓ 0.0 6,274 1 / 3

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

17. 0.324 0.324 ↓ 0.0 3,623 1 / 3

Seq Scan on d_202008_00276 d_15 (cost=0..0 rows=0 width=0) (actual time=0.006..0.971 rows=3,623 loops=1)

18. 0.268 0.268 ↓ 0.0 3,236 1 / 3

Seq Scan on d_202008_00053 d_12 (cost=0..0 rows=0 width=0) (actual time=0.006..0.805 rows=3,236 loops=1)

19. 0.157 0.157 ↓ 0.0 2,217 1 / 3

Seq Scan on d_202008_00041 d_9 (cost=0..0 rows=0 width=0) (actual time=0.003..0.47 rows=2,217 loops=1)

20. 0.177 0.177 ↓ 0.0 2,215 1 / 3

Seq Scan on d_202008_00274 d_14 (cost=0..0 rows=0 width=0) (actual time=0.004..0.53 rows=2,215 loops=1)

21. 0.044 0.044 ↓ 0.0 224 1 / 3

Seq Scan on d_202008_01005 d_19 (cost=0..0 rows=0 width=0) (actual time=0.003..0.133 rows=224 loops=1)

22. 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)

23. 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..0 rows=0 loops=1)

24. 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)

25. 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..0 rows=0 loops=1)

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

27. 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..0 rows=0 loops=1)

28. 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..0 rows=0 loops=1)

29. 0.007 0.007 ↓ 0.0 65 1 / 3

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

30. 0.003 0.003 ↓ 0.0 1 1 / 3

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

31. 19.724 39.015 ↓ 0.0 96,076 3 / 3

Hash (cost=0..0 rows=0 width=0) (actual time=39.015..39.015 rows=96,076 loops=3)

32. 19.291 19.291 ↓ 0.0 96,076 3 / 3

Seq Scan on datas_process p (cost=0..0 rows=0 width=0) (actual time=0.008..19.291 rows=96,076 loops=3)

33. 0.003 0.009 ↓ 0.0 3 3 / 3

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

34. 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)

35. 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)

36. 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
37. 42.809 42.809 ↓ 0.0 1 128,426 / 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=128,426)

  • Index Cond: (idaccount = d_17.idaccount)
38. 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)

39. 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)

40. 0.006 0.017 ↓ 0.0 4 3 / 3

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

41. 0.011 0.011 ↓ 0.0 4 3 / 3

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

42. 42.809 42.809 ↓ 0.0 1 128,426 / 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=128,426)

  • Index Cond: (ideventtype = d_17.ideventtype)
43. 42.809 42.809 ↓ 0.0 1 128,426 / 3

Index 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=128,426)

  • Index Cond: (idpriority = d_17.priority)
44.          

SubPlan (for Gather)

45. 128.426 128.426 ↓ 0.0 0 128,426

Result (cost=0..0 rows=0 width=0) (actual time=0.001..0.001 rows=0 loops=128,426)

46. 0.000 0.000 ↓ 0.0 0 128,426

Append (cost=0..0 rows=0 width=0) (actual time=0..0 rows=0 loops=128,426)

47. 0.000 0.000 ↓ 0.0 0 128,426

Index Scan using pk_equipments_idequipment on equipments equipments (cost=0..0 rows=0 width=0) (actual time=0..0 rows=0 loops=128,426)

  • Index Cond: (idequipment = d_17.idequipment)
48. 0.000 0.000 ↓ 0.0 0 128,426

Index Scan using network_devices_2_pkey on network_devices network_devices (cost=0..0 rows=0 width=0) (actual time=0..0 rows=0 loops=128,426)

  • Index Cond: (idequipment = d_17.idequipment)