explain.depesz.com

PostgreSQL's explain analyze made readable

Result: nnIP

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 21,739.516 ↓ 0.0 0 1

Limit (cost=68,939.66..68,939.67 rows=1 width=25) (actual time=21,739.516..21,739.516 rows=0 loops=1)

  • Buffers: shared hit=6 read=61216 dirtied=2894
2. 0.044 21,739.515 ↓ 0.0 0 1

Sort (cost=68,939.66..68,939.67 rows=1 width=25) (actual time=21,739.515..21,739.515 rows=0 loops=1)

  • Sort Key: (max(t1._date_time)) DESC
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=6 read=61216 dirtied=2894
3. 0.003 21,739.471 ↓ 0.0 0 1

GroupAggregate (cost=68,939.63..68,939.65 rows=1 width=25) (actual time=21,739.471..21,739.471 rows=0 loops=1)

  • Group Key: t1._fld9822rref
  • Buffers: shared hit=3 read=61216 dirtied=2894
4. 0.023 21,739.468 ↓ 0.0 0 1

Sort (cost=68,939.63..68,939.64 rows=1 width=25) (actual time=21,739.468..21,739.468 rows=0 loops=1)

  • Sort Key: t1._fld9822rref
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=3 read=61216 dirtied=2894
5. 0.002 21,739.445 ↓ 0.0 0 1

Nested Loop Semi Join (cost=17.72..68,939.62 rows=1 width=25) (actual time=21,739.445..21,739.445 rows=0 loops=1)

  • Join Filter: ((CASE WHEN (alternatives: SubPlan 1 or hashed SubPlan 2) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 3 or hashed SubPlan 4) THEN true ELSE false END) OR (CASE WHEN (alternatives: SubPlan 5 or hashed S (...)
  • Buffers: shared read=61216 dirtied=2894
6. 21,739.443 21,739.443 ↓ 0.0 0 1

Seq Scan on _document343 t1 (cost=0.00..68,892.06 rows=1 width=59) (actual time=21,739.443..21,739.443 rows=0 loops=1)

  • Filter: (_posted AND (_fld9822rref <> '\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000\\000'::bytea) AND (_fld717 = '0'::numeric) AND (_fld9817rref = '\\243\\357\\260\\300\\220\\273\\235<\\021\\34 (...)
  • Rows Removed by Filter: 439204
  • Buffers: shared read=61216 dirtied=2894
7. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=17.72..24.82 rows=1 width=17) (never executed)

8. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=17.45..24.52 rows=1 width=37) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference105_byfield2798_sr on _reference105 t4 (cost=0.41..3.92 rows=1 width=19) (never executed)

  • Index Cond: (_fld2789 = 'Документ.ПеремещениеТоваров'::mvarchar)
  • Heap Fetches: 0
10. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=17.04..20.59 rows=1 width=55) (never executed)

11. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=16.63..16.64 rows=1 width=19) (never executed)

  • Group Key: t5._reference73_idrref
12. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.56..16.62 rows=1 width=19) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t6 (cost=0.28..8.86 rows=2 width=24) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14728_type = '\\010'::bytea) AND (_fld14728_rtref = '\\000\\000\\000\\254'::bytea) AND (_fld14728_rrref = '\\020\\2110Z:wN\\241\\021\\351\\305p\\35 (...)
  • Heap Fetches: 0
14. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t5 (cost=0.28..3.85 rows=3 width=49) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld2105_type = t6._fld14727_type) AND (_fld2105_rtref = t6._fld14727_rtref) AND (_fld2105_rrref = t6._fld14727_rrref))
  • Heap Fetches: 0
15. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t3 (cost=0.42..3.94 rows=1 width=36) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t5._reference73_idrref) AND (_fld14846rref = t4._idrref))
  • Heap Fetches: 0
16. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference73hpk on _reference73 t2 (cost=0.27..0.29 rows=1 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t3._fld14847rref))
  • Heap Fetches: 0
17.          

SubPlan (for Nested Loop Semi Join)

18. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t7 (cost=0.41..3.93 rows=1 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\340'::bytea) AND (_fld13933_rrref = t1._fld9816rref) AND (_fld13932rref = t2._idrref))
  • Heap Fetches: 0
19. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t7_1 (cost=0.41..76.41 rows=267 width=36) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\340'::bytea))
  • Heap Fetches: 0
20. 0.000 0.000 ↓ 0.0 0

Index Scan using _inforg13938_bydims_rr on _inforg13938 t8 (cost=0.41..7.43 rows=1 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13939rref = t2._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
21. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t8_1 (cost=0.41..189.35 rows=38 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
22. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t9 (cost=0.41..3.93 rows=1 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\340'::bytea) AND (_fld13933_rrref = t1._fld9817rref) AND (_fld13932rref = t2._idrref))
  • Heap Fetches: 0
23. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t9_1 (cost=0.41..76.41 rows=267 width=36) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\340'::bytea))
  • Heap Fetches: 0
24. 0.000 0.000 ↓ 0.0 0

Index Scan using _inforg13938_bydims_rr on _inforg13938 t10 (cost=0.41..7.43 rows=1 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13939rref = t2._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
25. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t10_1 (cost=0.41..189.35 rows=38 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
Planning time : 1,979.694 ms
Execution time : 21,740.166 ms