explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3AYQ

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 61,643.895 ↓ 0.0 0 1

Limit (cost=1,508,666.32..1,541,050.11 rows=1 width=418) (actual time=61,643.895..61,643.895 rows=0 loops=1)

  • Buffers: shared hit=688477 read=11582 dirtied=14314
2. 0.002 61,643.894 ↓ 0.0 0 1

Nested Loop Semi Join (cost=1,508,666.32..1,541,050.11 rows=1 width=418) (actual time=61,643.894..61,643.894 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) AND (CASE WHEN (alternatives: SubPlan 8 or hashed SubPlan 9) THEN tr (...)
  • Buffers: shared hit=688477 read=11582 dirtied=14314
3. 0.000 61,643.892 ↓ 0.0 0 1

Nested Loop (cost=1,508,657.54..1,540,905.99 rows=3 width=435) (actual time=61,643.892..61,643.892 rows=0 loops=1)

  • Join Filter: (t37._idrref = t59._fld17711rref)
  • Buffers: shared hit=688477 read=11582 dirtied=14314
4. 2.251 61,643.892 ↓ 0.0 0 1

Nested Loop (cost=1,508,657.11..1,540,897.23 rows=3 width=318) (actual time=61,643.892..61,643.892 rows=0 loops=1)

  • Join Filter: (t38._fld20189rref = t39.q_001_f_000rref)
  • Rows Removed by Join Filter: 8600
  • Buffers: shared hit=688477 read=11582 dirtied=14314
5. 10.149 28,221.353 ↓ 28.7 86 1

Nested Loop (cost=1.38..28,166.01 rows=3 width=335) (actual time=137.833..28,221.353 rows=86 loops=1)

  • Join Filter: (t37._idrref = t60._fld20554rref)
  • Buffers: shared hit=113289 read=3658 dirtied=6502
6. 43.001 24,199.040 ↓ 111.3 8,573 1

Nested Loop (cost=0.96..28,027.11 rows=77 width=293) (actual time=70.540..24,199.040 rows=8,573 loops=1)

  • Buffers: shared hit=78974 read=3413 dirtied=5773
7. 23,993.067 23,993.067 ↓ 1.6 18,108 1

Index Scan using _document300_bydocdate_trls on _document300 t37 (cost=0.55..19,145.19 rows=11,293 width=259) (actual time=44.472..23,993.067 rows=18,108 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_date_time > '2019-08-31 11:26:46'::timestamp without time zone))
  • Buffers: shared hit=14358 read=3412 dirtied=5673
8. 162.972 162.972 ↓ 0.0 0 18,108

Index Scan using _inforg20187_bydims_r on _inforg20187 t38 (cost=0.41..0.78 rows=1 width=34) (actual time=0.009..0.009 rows=0 loops=18,108)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld20188rref = t37._idrref))
  • Buffers: shared hit=64616 read=1 dirtied=100
9. 4,012.164 4,012.164 ↓ 0.0 0 8,573

Index Scan using _inforg20553_bydims_r on _inforg20553 t60 (cost=0.42..1.79 rows=1 width=42) (actual time=0.468..0.468 rows=0 loops=8,573)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld20554rref = t38._fld20188rref))
  • Filter: ((_fld20557 >= '2019-08-01 00:00:00'::timestamp without time zone) AND (_fld20557 <= '2019-08-31 23:59:59'::timestamp without time zone))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=34315 read=245 dirtied=729
10. 1.076 33,420.288 ↑ 125.5 100 86

Materialize (cost=1,508,655.73..1,512,197.81 rows=12,551 width=17) (actual time=388.293..388.608 rows=100 loops=86)

  • Buffers: shared hit=575188 read=7924 dirtied=7812
11. 0.032 33,419.212 ↑ 125.5 100 1

Subquery Scan on t39 (cost=1,508,655.73..1,512,135.05 rows=12,551 width=17) (actual time=33,393.104..33,419.212 rows=100 loops=1)

  • Buffers: shared hit=575188 read=7924 dirtied=7812
12. 24.470 33,419.180 ↑ 125.5 100 1

GroupAggregate (cost=1,508,655.73..1,512,009.54 rows=12,551 width=18) (actual time=33,393.103..33,419.180 rows=100 loops=1)

  • Group Key: t40._fld20189rref
  • Filter: min(CASE WHEN ((max(t42.fld15641_)) IS NULL) THEN false WHEN (t58._fld20230 IS NOT NULL) THEN false ELSE true END)
  • Rows Removed by Filter: 11663
  • Buffers: shared hit=575188 read=7924 dirtied=7812
13. 15.851 33,394.710 ↑ 1.1 11,857 1

Sort (cost=1,508,655.73..1,508,687.38 rows=12,660 width=57) (actual time=33,392.705..33,394.710 rows=11,857 loops=1)

  • Sort Key: t40._fld20189rref
  • Sort Method: quicksort Memory: 1311kB
  • Buffers: shared hit=575188 read=7924 dirtied=7812
14. 4.231 33,378.859 ↑ 1.1 11,857 1

Hash Right Join (cost=1,505,502.01..1,507,793.08 rows=12,660 width=57) (actual time=33,372.742..33,378.859 rows=11,857 loops=1)

  • Hash Cond: (t42.fld15638_rrref = t40._fld20188rref)
  • Buffers: shared hit=575185 read=7924 dirtied=7812
15. 2.315 33,355.051 ↑ 8.4 101 1

GroupAggregate (cost=1,504,964.05..1,507,235.02 rows=846 width=57) (actual time=33,353.046..33,355.051 rows=101 loops=1)

  • Group Key: t42.fld15638_type, t42.fld15638_rtref, t42.fld15638_rrref
  • Filter: min(CASE WHEN ((t42.fld15643balance_ = t42.fld15644balance_) AND (t42.fld15643balance_ > '0'::numeric)) THEN true ELSE false END)
  • Rows Removed by Filter: 177
  • Buffers: shared hit=575015 read=7924 dirtied=7664
16. 0.782 33,352.736 ↑ 14.7 576 1

Sort (cost=1,504,964.05..1,504,985.19 rows=8,458 width=93) (actual time=33,352.624..33,352.736 rows=576 loops=1)

  • Sort Key: t42.fld15638_rrref
  • Sort Method: quicksort Memory: 70kB
  • Buffers: shared hit=575012 read=7924 dirtied=7664
17. 0.126 33,351.954 ↑ 14.7 576 1

Subquery Scan on t42 (cost=1,503,966.41..1,504,412.33 rows=8,458 width=93) (actual time=33,350.871..33,351.954 rows=576 loops=1)

  • Buffers: shared hit=575012 read=7924 dirtied=7664
18. 0.886 33,351.828 ↑ 14.7 576 1

GroupAggregate (cost=1,503,966.41..1,504,327.75 rows=8,458 width=93) (actual time=33,350.870..33,351.828 rows=576 loops=1)

  • Group Key: t43._fld15641, t43._fld15638_type, t43._fld15638_rtref, t43._fld15638_rrref
  • Filter: ((sum(t43._fld15643) <> '0'::numeric) OR (sum(t43._fld15644) <> '0'::numeric))
  • Buffers: shared hit=575012 read=7924 dirtied=7664
19. 2.533 33,350.942 ↑ 14.8 576 1

Sort (cost=1,503,966.41..1,503,987.77 rows=8,541 width=36) (actual time=33,350.835..33,350.942 rows=576 loops=1)

  • Sort Key: t43._fld15641, t43._fld15638_rrref
  • Sort Method: quicksort Memory: 70kB
  • Buffers: shared hit=575012 read=7924 dirtied=7664
20. 5,834.659 33,348.409 ↑ 14.8 576 1

Index Scan using _accumrg15647_bydims_trrrnr on _accumrgt15647 t43 (cost=0.55..1,503,408.68 rows=8,541 width=36) (actual time=580.897..33,348.409 rows=576 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_period = '3999-11-01 00:00:00'::timestamp without time zone) AND ('\\010'::bytea = _fld15638_type) AND ('\\000\\000\\001,'::by (...)
  • Filter: (((_fld15643 <> '0'::numeric) OR (_fld15644 <> '0'::numeric)) AND ((_fld15643 <> '0'::numeric) OR (_fld15644 <> '0'::numeric)) AND (SubPlan 23))
  • Rows Removed by Filter: 30914
  • Buffers: shared hit=575009 read=7924 dirtied=7664
21.          

SubPlan (forIndex Scan)

22. 41.844 27,513.750 ↓ 0.0 0 18,125

Nested Loop Semi Join (cost=9.62..76.05 rows=1 width=0) (actual time=1.518..1.518 rows=0 loops=18,125)

  • Join Filter: ((CASE WHEN (alternatives: SubPlan 12 or hashed SubPlan 13) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 14 or hashed SubPlan 15) THEN (...)
  • Buffers: shared hit=546337 read=5326 dirtied=4077
23. 181.250 23,580.625 ↑ 1.0 1 18,125

Nested Loop Left Join (cost=0.84..14.98 rows=1 width=68) (actual time=1.267..1.301 rows=1 loops=18,125)

  • Join Filter: ((t43._fld15638_type = '\\010'::bytea) AND (t43._fld15638_rtref = '\\000\\000\\001,'::bytea))
  • Filter: ((CASE WHEN (CASE WHEN ((t43._fld15638_type = '\\010'::bytea) AND (t43._fld15638_rtref = '\\000\\000\\0012'::bytea)) THEN t44._fld8248rref WHEN ((t4 (...)
  • Buffers: shared hit=122552 read=5030 dirtied=4071
24. 36.250 833.750 ↑ 1.0 1 18,125

Nested Loop Left Join (cost=0.42..7.47 rows=1 width=34) (actual time=0.045..0.046 rows=1 loops=18,125)

  • Join Filter: ((t43._fld15638_type = '\\010'::bytea) AND (t43._fld15638_rtref = '\\000\\000\\0012'::bytea))
  • Buffers: shared hit=54328 read=136
25. 0.000 0.000 ↑ 1.0 1 18,125

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=18,125)

26. 797.500 797.500 ↓ 0.0 0 18,125

Index Scan using _document306hpk on _document306 t44 (cost=0.42..7.44 rows=1 width=34) (actual time=0.044..0.044 rows=0 loops=18,125)

  • Index Cond: ((_fld717 = '0'::numeric) AND (t43._fld15638_rrref = _idrref))
  • Buffers: shared hit=54328 read=136
27. 22,565.625 22,565.625 ↑ 1.0 1 18,125

Index Scan using _document300hpk on _document300 t45 (cost=0.43..7.45 rows=1 width=34) (actual time=1.213..1.245 rows=1 loops=18,125)

  • Index Cond: ((_fld717 = '0'::numeric) AND (t43._fld15638_rrref = _idrref))
  • Buffers: shared hit=68224 read=4894 dirtied=4071
28. 18.125 1,540.625 ↓ 0.0 0 18,125

Materialize (cost=8.78..30.76 rows=1 width=17) (actual time=0.085..0.085 rows=0 loops=18,125)

  • Buffers: shared hit=415333 read=38 dirtied=1
29. 36.250 1,522.500 ↓ 0.0 0 18,125

Nested Loop (cost=8.78..30.75 rows=1 width=17) (actual time=0.084..0.084 rows=0 loops=18,125)

  • Buffers: shared hit=415333 read=38 dirtied=1
30. 253.750 833.750 ↑ 1.0 1 18,125

Nested Loop (cost=8.51..19.08 rows=1 width=38) (actual time=0.036..0.046 rows=1 loops=18,125)

  • Buffers: shared hit=251443 read=18
  • -> Index Only Scan using _reference105_byfield2798_sr on _reference105 t48 (cost=0.41..3.92 rows=1 width=20) (actual time=0.012..0.012 rows=1 (...)
  • Index Cond: (_fld2789 = 'РегистрНакопления.ЗаказыКлиентов'::mvarchar)
  • Heap Fetches: 0
  • Buffers: shared hit=54375 read=4
31. 525.625 580.000 ↑ 1.0 1 18,125

Nested Loop (cost=8.11..15.15 rows=1 width=57) (actual time=0.023..0.032 rows=1 loops=18,125)

  • Buffers: shared hit=197068 read=14
  • -> Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t47 (cost=0.42..7.44 rows=1 width=38) (actual time=0.009..0.009 row (...)
32. 22.879 54.375 ↓ 3.0 3 18,125

HashAggregate (cost=7.69..7.70 rows=1 width=19) (actual time=0.002..0.003 rows=3 loops=18,125)

  • Group Key: t49._reference73_idrref
  • Buffers: shared hit=5 read=5
  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t49._reference73_idrref) AND (_fld14846rref = t48._idrref))
  • Heap Fetches: 18125
  • Buffers: shared hit=197063 read=9
33. 31.496 31.496 ↓ 3.0 3 1

Nested Loop (cost=0.56..7.68 rows=1 width=19) (actual time=31.475..31.496 rows=3 loops=1)

  • Buffers: shared hit=5 read=5
  • -> Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t50 (cost=0.28..3.80 rows=1 width=24) (actual time=27.2 (...)
  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14728_type = '\\010'::bytea) AND (_fld14728_rtref = '\\000\\000\\000\\254 (...)
  • Heap Fetches: 2
  • Buffers: shared read=4
  • -> Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t49 (cost=0.28..3.85 rows=3 width=49) (ac (...)
  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld2105_type = t50._fld14727_type) AND (_fld2105_rtref = t50._fld14727_rtref (...)
  • Heap Fetches: 1
  • Buffers: shared hit=5 read=1
34. 652.500 652.500 ↓ 0.0 0 18,125

Index Only Scan using _reference73hpk on _reference73 t46 (cost=0.27..11.66 rows=1 width=17) (actual time=0.036..0.036 rows=0 loops=18,125)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t47._fld14847rref))
  • Filter: (CASE WHEN (alternatives: SubPlan 16 or hashed SubPlan 17) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 18 or hashed SubP (...)
  • Rows Removed by Filter: 1
  • Heap Fetches: 18125
  • Buffers: shared hit=163890 read=20 dirtied=1
  • -> Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t53 (cost=0.41..7.43 rows=1 width=0) (actual time=0.013..0.013 rows=0 l (...)
  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\340'::bytea) AND (_ (...)
  • Heap Fetches: 0
  • Buffers: shared hit=55146 read=12
  • -> Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t54 (cost=0.41..3.93 rows=1 width=0) (actual time=0.012..0.012 row (...)
  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13939rref = t46._idrref) AND (_fld13940_type = '\\010'::bytea) AN (...)
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
  • Buffers: shared hit=54372 read=4
35.          

SubPlan (forIndex Only Scan)

36. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t53_1 (cost=0.41..7.43 rows=1 width=18) (never executed)

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

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t54_1 (cost=0.41..192.55 rows=46 width=17) (never executed)

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

SubPlan (forNested Loop Semi Join)

39. 6.336 6.336 ↑ 1.0 1 576

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t51 (cost=0.43..7.46 rows=1 width=0) (actual time=0.011..0.011 rows=1 loops=576)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = CASE WHEN (CASE WHEN ((t43._fld15638_type = '\\010'::bytea) AND (t43._fld15638_rtref = '\\000\ (...)
  • Heap Fetches: 0
  • Buffers: shared hit=1728 read=1
40. 0.000 0.000 ↓ 0.0 0

Seq Scan on _inforg13931 t51_1 (cost=0.00..69.76 rows=2,301 width=45) (never executed)

  • Filter: (_fld717 = '0'::numeric)
41. 5.184 5.184 ↑ 1.0 1 576

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t52 (cost=0.43..3.96 rows=1 width=0) (actual time=0.009..0.009 rows=1 loops=576)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13939rref = t46._idrref) AND (_fld13940_type = CASE WHEN (CASE WHEN ((t43._fld15638 (...)
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
  • Buffers: shared hit=1729
42. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t52_1 (cost=0.41..197.65 rows=1,112 width=24) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
43. 4.608 2,333.376 ↑ 1.0 1 576

Nested Loop (cost=0.86..14.92 rows=1 width=0) (actual time=4.051..4.051 rows=1 loops=576)

  • Buffers: shared hit=3266 read=257 dirtied=5
44. 2,310.912 2,310.912 ↑ 1.0 1 576

Index Only Scan using _inforg13761_bydims_rrn on _inforg13761 t56 (cost=0.45..7.48 rows=1 width=24) (actual time=4.012..4.012 rows=1 loops=576)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13762_type = CASE WHEN (CASE WHEN ((t43._fld15638_type = '\\010'::bytea) AND (t43._fld15638_rtref = ' (...)
  • Heap Fetches: 61
  • Buffers: shared hit=1540 read=254 dirtied=5
45. 17.856 17.856 ↑ 1.0 1 576

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t55 (cost=0.41..7.43 rows=1 width=27) (actual time=0.031..0.031 rows=1 loops=576)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = t56._fld13763_type) AND (_fld13933_rtref = t56._fld13763_rtref) AND (_fld13933_rrref = t (...)
  • Heap Fetches: 0
  • Buffers: shared hit=1726 read=3
46. 5.760 5.760 ↑ 1.0 1 576

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t57 (cost=0.43..3.96 rows=1 width=0) (actual time=0.010..0.010 rows=1 loops=576)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13939rref = t46._idrref) AND (_fld13940_type = CASE WHEN (CASE WHEN ((t43._fld15638 (...)
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
  • Buffers: shared hit=1729
47. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t57_1 (cost=0.41..197.65 rows=1,112 width=24) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
48. 5.609 19.577 ↑ 1.1 11,857 1

Hash (cost=379.71..379.71 rows=12,660 width=42) (actual time=19.577..19.577 rows=11,857 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 894kB
  • Buffers: shared hit=170 dirtied=148
49. 4.327 13.968 ↑ 1.1 11,857 1

Hash Left Join (cost=7.85..379.71 rows=12,660 width=42) (actual time=0.373..13.968 rows=11,857 loops=1)

  • Hash Cond: (t40._fld20188rref = t58._fld20229rref)
  • Buffers: shared hit=170 dirtied=148
50. 9.352 9.352 ↑ 1.1 11,857 1

Seq Scan on _inforg20187 t40 (cost=0.00..323.25 rows=12,660 width=34) (actual time=0.069..9.352 rows=11,857 loops=1)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=165 dirtied=143
51. 0.058 0.289 ↑ 1.0 114 1

Hash (cost=6.42..6.42 rows=114 width=25) (actual time=0.289..0.289 rows=114 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 15kB
  • Buffers: shared hit=5 dirtied=5
52. 0.231 0.231 ↑ 1.0 114 1

Seq Scan on _inforg20228 t58 (cost=0.00..6.42 rows=114 width=25) (actual time=0.047..0.231 rows=114 loops=1)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=5 dirtied=5
53. 0.000 0.000 ↓ 0.0 0

Index Scan using _inforg17710_bydims_r on _inforg17710 t59 (cost=0.43..2.90 rows=1 width=168) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld17711rref = t60._fld20554rref))
54. 0.000 0.000 ↓ 0.0 0

Materialize (cost=8.78..19.39 rows=1 width=17) (never executed)

55. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8.78..19.38 rows=1 width=17) (never executed)

56. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8.51..19.08 rows=1 width=38) (never executed)

57. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (_fld2789 = 'Документ.ЗаказКлиента'::mvarchar)
  • Heap Fetches: 0
58. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=8.11..15.15 rows=1 width=57) (never executed)

59. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=7.69..7.70 rows=1 width=19) (never executed)

  • Group Key: t64._reference73_idrref
60. 0.000 0.000 ↓ 0.0 0

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

61. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t65 (cost=0.28..3.80 rows=1 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 = '\\002\\2140Z:wN\\241\\021\\351\\276\\230\\011A\\206\ (...)
  • Heap Fetches: 0
62. 0.000 0.000 ↓ 0.0 0

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

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

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t62 (cost=0.42..7.44 rows=1 width=38) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t64._reference73_idrref) AND (_fld14846rref = t63._idrref))
  • Heap Fetches: 0
64. 0.000 0.000 ↓ 0.0 0

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

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

SubPlan (forNested Loop Semi Join)

66. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t66 (cost=0.41..7.43 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 = t37._fld7786rref) AND (_fld13932rref = t61._idrref))
  • Heap Fetches: 0
67. 0.000 0.000 ↓ 0.0 0

Seq Scan on _inforg13931 t66_1 (cost=0.00..81.27 rows=266 width=36) (never executed)

  • Filter: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\340'::bytea))
68. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t67 (cost=0.41..3.93 rows=1 width=0) (never executed)

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

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t67_1 (cost=0.41..192.55 rows=46 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
70. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\361'::bytea) AND (_fld13933_rrref = t37._fld7818rref) AND (_fld13932rref = t61._idrref))
  • Heap Fetches: 0
71. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t71_1 (cost=0.41..54.94 rows=178 width=36) (never executed)

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

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t72 (cost=0.41..3.93 rows=1 width=0) (never executed)

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

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t72_1 (cost=0.41..192.55 rows=46 width=17) (never executed)

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

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

75. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13761_bydims_rrn on _inforg13761 t69 (cost=0.42..7.45 rows=1 width=24) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13762_type = '\\010'::bytea) AND (_fld13762_rtref = '\\000\\000\\000\\242'::bytea) AND (_fld13762_rrref = t37._fld7777rref))
  • Heap Fetches: 0
76. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t68 (cost=0.41..7.43 rows=1 width=27) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = t69._fld13763_type) AND (_fld13933_rtref = t69._fld13763_rtref) AND (_fld13933_rrref = t69._fld13763_rrref) AND (_fld13932rref = t61._idrref))
  • Heap Fetches: 0
77. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t70 (cost=0.41..3.93 rows=1 width=0) (never executed)

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

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t70_1 (cost=0.41..192.55 rows=46 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\242'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
Planning time : 1,204.455 ms
Execution time : 61,676.837 ms