explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fjcE

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

Limit (cost=0..0 rows=0 width=0) (never executed)

2. 0.000 0.000 ↓ 0.0

Result (cost=0..0 rows=0 width=0) (never executed)

3. 0.000 0.000 ↓ 0.0

Sort (cost=0..0 rows=0 width=0) (never executed)

  • Sort Key: d.idevent DESC
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

7. 0.000 0.000 ↓ 0.0

Index Scan using accounts__pkey1 on accounts accounts (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idaccount = 0)
8. 0.000 0.000 ↓ 0.0

Seq Scan on divisions divisions (cost=0..0 rows=0 width=0) (never executed)

9. 0.000 0.000 ↓ 0.0

Seq Scan on account_states account_states (cost=0..0 rows=0 width=0) (never executed)

10. 0.000 0.000 ↓ 0.0

Gather (cost=0..0 rows=0 width=0) (never executed)

  • Workers Planned: 2
11. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

12. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0..0 rows=0 width=0) (never executed)

13. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

14. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

15. 0.000 0.000 ↓ 0.0

Hash Join (cost=0..0 rows=0 width=0) (never executed)

16. 0.000 0.000 ↓ 0.0

Append (cost=0..0 rows=0 width=0) (never executed)

17. 0.000 0.000 ↓ 0.0

Index Scan using d_202007_01000_idaccount_source_idx on d_202007_01000 d (cost=0..0 rows=0 width=0) (never executed)

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

Seq Scan on d_202008_01000 d_1 (cost=0..0 rows=0 width=0) (never executed)

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

Hash (cost=0..0 rows=0 width=0) (never executed)

20. 0.000 0.000 ↓ 0.0

Seq Scan on datas_process p (cost=0..0 rows=0 width=0) (never executed)

21. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

22. 0.000 0.000 ↓ 0.0

Seq Scan on reception_modes reception_modes (cost=0..0 rows=0 width=0) (never executed)

23. 0.000 0.000 ↓ 0.0

Hash (cost=0..0 rows=0 width=0) (never executed)

24. 0.000 0.000 ↓ 0.0

Seq Scan on statustypes statustypes (cost=0..0 rows=0 width=0) (never executed)

  • Filter: isopen
25. 0.000 0.000 ↓ 0.0

Index Scan using pk_ideventypes on eventtypes eventtypes (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (ideventtype = d.ideventtype)
26. 0.000 0.000 ↓ 0.0

Index Scan using priority_levels_pkey on priority_levels priority_levels (cost=0..0 rows=0 width=0) (never executed)

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

SubPlan (for Result)

28. 0.000 0.000 ↓ 0.0

Result (cost=0..0 rows=0 width=0) (never executed)

29. 0.000 0.000 ↓ 0.0

Append (cost=0..0 rows=0 width=0) (never executed)

30. 0.000 0.000 ↓ 0.0

Index Scan using pk_equipments_idequipment on equipments equipments (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idequipment = d.idequipment)
31. 0.000 0.000 ↓ 0.0

Index Scan using network_devices_2_pkey on network_devices network_devices (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idequipment = d.idequipment)