explain.depesz.com

PostgreSQL's explain analyze made readable

Result: EeJs

Settings

Optimization(s) for this plan:

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

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

2. 0.000 0.000 ↓ 0.0

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

3. 0.000 0.000 ↓ 0.0

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

4. 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 = 0)
5. 0.000 0.000 ↓ 0.0

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

  • Filter: (idaccount = 0)
6. 0.000 0.000 ↓ 0.0

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

  • Filter: (idaccount = 0)
7. 0.000 0.000 ↓ 0.0

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

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

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

  • Filter: (idaccount = 0)
9. 0.000 0.000 ↓ 0.0

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

10. 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 = 0)
11. 0.000 0.000 ↓ 0.0

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

  • Filter: (idaccount = 0)
12. 0.000 0.000 ↓ 0.0

Index Scan using d_202008_00039_idaccount_ideventtype_idx on d_202008_00039 d_7 (cost=0..0 rows=0 width=0) (never executed)

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

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

  • Filter: (idaccount = 0)
14. 0.000 0.000 ↓ 0.0

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

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

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

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

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

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

Index Scan using d_202008_00053_idaccount_idx on d_202008_00053 d_12 (cost=0..0 rows=0 width=0) (never executed)

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

Index Scan using d_202008_00273_idaccount_idx on d_202008_00273 d_13 (cost=0..0 rows=0 width=0) (never executed)

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

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

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

Index Scan using d_202008_00276_idaccount_idx on d_202008_00276 d_15 (cost=0..0 rows=0 width=0) (never executed)

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

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

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

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

  • Filter: (idaccount = 0)
23. 0.000 0.000 ↓ 0.0

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

  • Filter: (idaccount = 0)
24. 0.000 0.000 ↓ 0.0

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

  • Filter: (idaccount = 0)
25. 0.000 0.000 ↓ 0.0

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

26. 0.000 0.000 ↓ 0.0

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