explain.depesz.com

PostgreSQL's explain analyze made readable

Result: PRe9

Settings
# exclusive inclusive rows x rows loops node
1. 18.136 489.500 ↓ 0.0 115,229 1

Nested Loop (cost=0..0 rows=0 width=0) (actual time=135.795..489.5 rows=115,229 loops=1)

2. 0.003 0.063 ↓ 0.0 1 1

Nested Loop (cost=0..0 rows=0 width=0) (actual time=0.058..0.063 rows=1 loops=1)

3. 0.006 0.039 ↓ 0.0 1 1

Nested Loop (cost=0..0 rows=0 width=0) (actual time=0.035..0.039 rows=1 loops=1)

4. 0.023 0.023 ↓ 0.0 1 1

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

  • Index Cond: (idaccount = 0)
5. 0.010 0.010 ↓ 0.0 8 1

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

6. 0.021 0.021 ↓ 0.0 1 1

Seq Scan on account_states account_states (cost=0..0 rows=0 width=0) (actual time=0.021..0.021 rows=1 loops=1)

7. 0.000 356.072 ↓ 0.0 115,229 1

Gather (cost=0..0 rows=0 width=0) (actual time=135.716..356.072 rows=115,229 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
8. 16.285 376.894 ↓ 0.0 38,410 3 / 3

Nested Loop (cost=0..0 rows=0 width=0) (actual time=133.742..376.894 rows=38,410 loops=3)

9. 0.000 322.199 ↓ 0.0 38,410 3 / 3

Nested Loop (cost=0..0 rows=0 width=0) (actual time=133.733..322.199 rows=38,410 loops=3)

10. 16.267 247.581 ↓ 0.0 38,410 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual time=133.704..247.581 rows=38,410 loops=3)

11. 23.131 231.277 ↓ 0.0 97,022 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual time=131.049..231.277 rows=97,022 loops=3)

12. 118.898 208.130 ↓ 0.0 97,022 3 / 3

Hash Join (cost=0..0 rows=0 width=0) (actual time=131.01..208.13 rows=97,022 loops=3)

13. 5.895 46.903 ↓ 0.0 97,022 3 / 3

Append (cost=0..0 rows=0 width=0) (actual time=0.04..46.903 rows=97,022 loops=3)

14. 0.012 0.012 ↓ 0.0 0 1 / 3

Index Scan using d_202007_01000_idaccount_source_idx on d_202007_01000 d (cost=0..0 rows=0 width=0) (actual time=0.037..0.037 rows=0 loops=1)

  • Index Cond: ((idaccount = 0) AND (source = 'e8aa105f-2cef-59aa-118d-5cd5462e76a7'::uuid))
  • Filter: ((idevent < 100000000) AND (ideventtype = ANY ('{1000,1000000}'::bigint[])))
15. 40.996 40.996 ↓ 0.0 97,022 3 / 3

Seq Scan on d_202008_01000 d_1 (cost=0..0 rows=0 width=0) (actual time=0.026..40.996 rows=97,022 loops=3)

  • Filter: ((idevent < 100000000) AND (ideventtype = ANY ('{1000,1000000}'::bigint[])) AND (idaccount = 0) AND (source = 'e8aa105f-2cef-59aa-118d-5cd5462e76a7'::uuid))
16. 21.893 42.329 ↓ 0.0 95,993 3 / 3

Hash (cost=0..0 rows=0 width=0) (actual time=42.328..42.329 rows=95,993 loops=3)

17. 20.436 20.436 ↓ 0.0 95,993 3 / 3

Seq Scan on datas_process p (cost=0..0 rows=0 width=0) (actual time=0.013..20.436 rows=95,993 loops=3)

18. 0.004 0.016 ↓ 0.0 3 3 / 3

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

19. 0.012 0.012 ↓ 0.0 3 3 / 3

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

20. 0.009 0.037 ↓ 0.0 7 3 / 3

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

21. 0.028 0.028 ↓ 0.0 7 3 / 3

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

  • Filter: isopen
22. 76.819 76.819 ↓ 0.0 1 115,229 / 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=115,229)

  • Index Cond: (ideventtype = d.ideventtype)
23. 38.410 38.410 ↓ 0.0 1 115,229 / 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=115,229)

  • Index Cond: (idpriority = d.priority)
24.          

SubPlan (for Nested Loop)

25. 115.229 115.229 ↓ 0.0 0 115,229

Result (cost=0..0 rows=0 width=0) (actual time=0.001..0.001 rows=0 loops=115,229)

26. 0.000 0.000 ↓ 0.0 0 115,229

Append (cost=0..0 rows=0 width=0) (actual time=0..0 rows=0 loops=115,229)

27. 0.000 0.000 ↓ 0.0 0 115,229

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

  • Index Cond: (idequipment = d.idequipment)
28. 0.000 0.000 ↓ 0.0 0 115,229

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=115,229)

  • Index Cond: (idequipment = d.idequipment)