explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZXQ0

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

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

2. 0.000 0.000 ↓ 0.0

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

  • Filter: isopen
3. 0.000 0.000 ↓ 0.0

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

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

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

7. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on d_201901_01003 d (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((idevent <> 212054) AND (COALESCE(idequipment, '-1'::bigint) = '-1'::integer) AND (source = '7c4808e6-60e3-9479-efe7-86ca429bc636'::uuid))
8. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on d_201901_01003_idaccount_ideventtype_idx (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idaccount = 7,437)
9. 0.000 0.000 ↓ 0.0

Index Scan using d_202007_00066_idaccount_ideventtype_idx on d_202007_00066 d_1 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idaccount = 7,437)
  • Filter: ((idevent <> 212054) AND (COALESCE(idequipment, '-1'::bigint) = '-1'::integer) AND (source = '7c4808e6-60e3-9479-efe7-86ca429bc636'::uuid))
10. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on d_202007_00068 d_2 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((idevent <> 212054) AND (COALESCE(idequipment, '-1'::bigint) = '-1'::integer) AND (source = '7c4808e6-60e3-9479-efe7-86ca429bc636'::uuid))
11. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on d_202007_00068_idaccount_ideventtype_idx (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idaccount = 7,437)
12. 0.000 0.000 ↓ 0.0

Index Scan using d_202007_01000_idaccount_idx on d_202007_01000 d_3 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idaccount = 7,437)
  • Filter: ((idevent <> 212054) AND (COALESCE(idequipment, '-1'::bigint) = '-1'::integer) AND (source = '7c4808e6-60e3-9479-efe7-86ca429bc636'::uuid))
13. 0.000 0.000 ↓ 0.0

Index Scan using d_202007_01002_idaccount_idx on d_202007_01002 d_4 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idaccount = 7,437)
  • Filter: ((idevent <> 212054) AND (COALESCE(idequipment, '-1'::bigint) = '-1'::integer) AND (source = '7c4808e6-60e3-9479-efe7-86ca429bc636'::uuid))
14. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on d_202007_01005 d_5 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((idevent <> 212054) AND (COALESCE(idequipment, '-1'::bigint) = '-1'::integer) AND (source = '7c4808e6-60e3-9479-efe7-86ca429bc636'::uuid))
15. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on d_202007_01005_idaccount_ideventtype_idx (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idaccount = 7,437)
16. 0.000 0.000 ↓ 0.0

Index Scan using d_202007_01008_idaccount_idx on d_202007_01008 d_6 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idaccount = 7,437)
  • Filter: ((idevent <> 212054) AND (COALESCE(idequipment, '-1'::bigint) = '-1'::integer) AND (source = '7c4808e6-60e3-9479-efe7-86ca429bc636'::uuid))
17. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on d_202008_00039 d_7 (cost=0..0 rows=0 width=0) (never executed)

  • Filter: ((idevent <> 212054) AND (COALESCE(idequipment, '-1'::bigint) = '-1'::integer) AND (source = '7c4808e6-60e3-9479-efe7-86ca429bc636'::uuid))
18. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on d_202008_00039_idaccount_ideventtype_idx (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idaccount = 7,437)
19. 0.000 0.000 ↓ 0.0

Index Scan using d_202008_00041_idaccount_idx on d_202008_00041 d_8 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idaccount = 7,437)
  • Filter: ((idevent <> 212054) AND (COALESCE(idequipment, '-1'::bigint) = '-1'::integer) AND (source = '7c4808e6-60e3-9479-efe7-86ca429bc636'::uuid))
20. 0.000 0.000 ↓ 0.0

Index Scan using d_202008_00042_idaccount_ideventtype_idx on d_202008_00042 d_9 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idaccount = 7,437)
  • Filter: ((idevent <> 212054) AND (COALESCE(idequipment, '-1'::bigint) = '-1'::integer) AND (source = '7c4808e6-60e3-9479-efe7-86ca429bc636'::uuid))
21. 0.000 0.000 ↓ 0.0

Index Scan using d_202008_00043_idaccount_idx on d_202008_00043 d_10 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idaccount = 7,437)
  • Filter: ((idevent <> 212054) AND (COALESCE(idequipment, '-1'::bigint) = '-1'::integer) AND (source = '7c4808e6-60e3-9479-efe7-86ca429bc636'::uuid))
22. 0.000 0.000 ↓ 0.0

Index Scan using d_202008_00053_idaccount_ideventtype_idx on d_202008_00053 d_11 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idaccount = 7,437)
  • Filter: ((idevent <> 212054) AND (COALESCE(idequipment, '-1'::bigint) = '-1'::integer) AND (source = '7c4808e6-60e3-9479-efe7-86ca429bc636'::uuid))
23. 0.000 0.000 ↓ 0.0

Index Scan using d_202008_00273_idaccount_ideventtype_idx on d_202008_00273 d_12 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idaccount = 7,437)
  • Filter: ((idevent <> 212054) AND (COALESCE(idequipment, '-1'::bigint) = '-1'::integer) AND (source = '7c4808e6-60e3-9479-efe7-86ca429bc636'::uuid))
24. 0.000 0.000 ↓ 0.0

Index Scan using d_202008_00274_idaccount_idx on d_202008_00274 d_13 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idaccount = 7,437)
  • Filter: ((idevent <> 212054) AND (COALESCE(idequipment, '-1'::bigint) = '-1'::integer) AND (source = '7c4808e6-60e3-9479-efe7-86ca429bc636'::uuid))
25. 0.000 0.000 ↓ 0.0

Index Scan using d_202008_00276_idaccount_ideventtype_idx on d_202008_00276 d_14 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idaccount = 7,437)
  • Filter: ((idevent <> 212054) AND (COALESCE(idequipment, '-1'::bigint) = '-1'::integer) AND (source = '7c4808e6-60e3-9479-efe7-86ca429bc636'::uuid))
26. 0.000 0.000 ↓ 0.0

Index Scan using d_202008_00277_idaccount_idx on d_202008_00277 d_15 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idaccount = 7,437)
  • Filter: ((idevent <> 212054) AND (COALESCE(idequipment, '-1'::bigint) = '-1'::integer) AND (source = '7c4808e6-60e3-9479-efe7-86ca429bc636'::uuid))
27. 0.000 0.000 ↓ 0.0

Index Scan using d_202008_01000_idaccount_idx on d_202008_01000 d_16 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idaccount = 7,437)
  • Filter: ((idevent <> 212054) AND (COALESCE(idequipment, '-1'::bigint) = '-1'::integer) AND (source = '7c4808e6-60e3-9479-efe7-86ca429bc636'::uuid))
28. 0.000 0.000 ↓ 0.0

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

  • Filter: ((idevent <> 212054) AND (idaccount = 7,437) AND (COALESCE(idequipment, '-1'::bigint) = '-1'::integer) AND (source = '7c4808e6-60e3-9479-efe7-86ca429bc636'::uuid))
29. 0.000 0.000 ↓ 0.0

Index Scan using d_202008_01005_idaccount_idx on d_202008_01005 d_18 (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idaccount = 7,437)
  • Filter: ((idevent <> 212054) AND (COALESCE(idequipment, '-1'::bigint) = '-1'::integer) AND (source = '7c4808e6-60e3-9479-efe7-86ca429bc636'::uuid))
30. 0.000 0.000 ↓ 0.0

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

31. 0.000 0.000 ↓ 0.0

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

32. 0.000 0.000 ↓ 0.0

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

33. 0.000 0.000 ↓ 0.0

Index Scan using idx_datas_process_idevent on datas_process p (cost=0..0 rows=0 width=0) (never executed)

  • Index Cond: (idevent = d.idevent)