explain.depesz.com

PostgreSQL's explain analyze made readable

Result: kTd3 : Optimization for: plan #3AYQ

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 864.156 ↓ 0.0 0 1

Limit (cost=1,543,506.16..1,575,889.95 rows=1 width=418) (actual time=864.156..864.156 rows=0 loops=1)

  • Buffers: shared hit=697331
2. 0.001 864.155 ↓ 0.0 0 1

Nested Loop Semi Join (cost=1,543,506.16..1,575,889.95 rows=1 width=418) (actual time=864.155..864.155 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=697331
3. 0.000 864.154 ↓ 0.0 0 1

Nested Loop (cost=1,543,497.38..1,575,745.82 rows=3 width=435) (actual time=864.154..864.154 rows=0 loops=1)

  • Join Filter: (t37._idrref = t59._fld17711rref)
  • Buffers: shared hit=697331
4. 0.764 864.154 ↓ 0.0 0 1

Nested Loop (cost=1,543,496.95..1,575,737.07 rows=3 width=318) (actual time=864.154..864.154 rows=0 loops=1)

  • Join Filter: (t38._fld20189rref = t39.q_001_f_000rref)
  • Rows Removed by Join Filter: 8600
  • Buffers: shared hit=697331
5. 2.222 100.656 ↓ 28.7 86 1

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

  • Join Filter: (t37._idrref = t60._fld20554rref)
  • Buffers: shared hit=115233
6. 19.867 72.715 ↓ 111.3 8,573 1

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

  • Buffers: shared hit=80865
7. 16.632 16.632 ↓ 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=0.040..16.632 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=17516
8. 36.216 36.216 ↓ 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.002..0.002 rows=0 loops=18,108)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld20188rref = t37._idrref))
  • Buffers: shared hit=63349
9. 25.719 25.719 ↓ 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.003..0.003 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=34368
10. 0.403 762.734 ↑ 125.5 100 86

Materialize (cost=1,543,495.57..1,547,037.65 rows=12,551 width=17) (actual time=8.724..8.869 rows=100 loops=86)

  • Buffers: shared hit=582098
11. 0.010 762.331 ↑ 125.5 100 1

Subquery Scan on t39 (cost=1,543,495.57..1,546,974.89 rows=12,551 width=17) (actual time=750.239..762.331 rows=100 loops=1)

  • Buffers: shared hit=582098
12. 11.243 762.321 ↑ 125.5 100 1

GroupAggregate (cost=1,543,495.57..1,546,849.38 rows=12,551 width=18) (actual time=750.237..762.321 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=582098
13. 6.570 751.078 ↑ 1.1 11,857 1

Sort (cost=1,543,495.57..1,543,527.22 rows=12,660 width=57) (actual time=750.078..751.078 rows=11,857 loops=1)

  • Sort Key: t40._fld20189rref
  • Sort Method: quicksort Memory: 1311kB
  • Buffers: shared hit=582098
14. 2.217 744.508 ↑ 1.1 11,857 1

Hash Right Join (cost=1,540,288.48..1,542,632.92 rows=12,660 width=57) (actual time=741.630..744.508 rows=11,857 loops=1)

  • Hash Cond: (t42.fld15638_rrref = t40._fld20188rref)
  • Buffers: shared hit=582098
15. 0.734 729.090 ↑ 8.6 101 1

GroupAggregate (cost=1,539,750.51..1,542,074.39 rows=866 width=57) (actual time=728.338..729.090 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=581928
16. 0.308 728.356 ↑ 15.0 576 1

Sort (cost=1,539,750.51..1,539,772.15 rows=8,655 width=93) (actual time=728.301..728.356 rows=576 loops=1)

  • Sort Key: t42.fld15638_rrref
  • Sort Method: quicksort Memory: 70kB
  • Buffers: shared hit=581928
17. 0.041 728.048 ↑ 15.0 576 1

Subquery Scan on t42 (cost=1,538,728.21..1,539,184.51 rows=8,655 width=93) (actual time=727.640..728.048 rows=576 loops=1)

  • Buffers: shared hit=581928
18. 0.344 728.007 ↑ 15.0 576 1

GroupAggregate (cost=1,538,728.21..1,539,097.96 rows=8,655 width=93) (actual time=727.639..728.007 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=581928
19. 0.739 727.663 ↑ 15.2 576 1

Sort (cost=1,538,728.21..1,538,750.06 rows=8,740 width=36) (actual time=727.621..727.663 rows=576 loops=1)

  • Sort Key: t43._fld15641, t43._fld15638_rrref
  • Sort Method: quicksort Memory: 70kB
  • Buffers: shared hit=581928
20. 56.299 726.924 ↑ 15.2 576 1

Index Scan using _accumrg15647_bydims_trrrnr on _accumrgt15647 t43 (cost=0.55..1,538,156.02 rows=8,740 width=36) (actual time=15.187..726.924 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=581928
21.          

SubPlan (forIndex Scan)

22. 22.426 670.625 ↓ 0.0 0 18,125

Nested Loop Semi Join (cost=9.62..76.05 rows=1 width=0) (actual time=0.037..0.037 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=551289
23. 54.375 181.250 ↑ 1.0 1 18,125

Nested Loop Left Join (cost=0.84..14.98 rows=1 width=68) (actual time=0.010..0.010 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=127211
24. 0.000 54.375 ↑ 1.0 1 18,125

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

  • Join Filter: ((t43._fld15638_type = '\\010'::bytea) AND (t43._fld15638_rtref = '\\000\\000\\0012'::bytea))
  • Buffers: shared hit=54464
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. 54.375 54.375 ↓ 0.0 0 18,125

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

  • Index Cond: ((_fld717 = '0'::numeric) AND (t43._fld15638_rrref = _idrref))
  • Buffers: shared hit=54464
27. 72.500 72.500 ↑ 1.0 1 18,125

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

  • Index Cond: ((_fld717 = '0'::numeric) AND (t43._fld15638_rrref = _idrref))
  • Buffers: shared hit=72747
28. 0.000 453.125 ↓ 0.0 0 18,125

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

  • Buffers: shared hit=415368
29. 18.125 453.125 ↓ 0.0 0 18,125

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

  • Buffers: shared hit=415368
30. 72.500 253.750 ↑ 1.0 1 18,125

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

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

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

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

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

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

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

  • Buffers: shared hit=10
  • -> Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t50 (cost=0.28..3.80 rows=1 width=24) (actual time=0.01 (...)
  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14728_type = '\\010'::bytea) AND (_fld14728_rtref = '\\000\\000\\000\\254 (...)
  • Heap Fetches: 2
  • Buffers: shared hit=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=6
34. 181.250 181.250 ↓ 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.010..0.010 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=163910
  • -> Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t53 (cost=0.41..7.43 rows=1 width=0) (actual time=0.004..0.004 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=55158
  • -> Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t54 (cost=0.41..3.93 rows=1 width=0) (actual time=0.003..0.003 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=54376
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. 2.304 2.304 ↑ 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.004..0.004 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=1729
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. 1.728 1.728 ↑ 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.003..0.003 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. 2.304 8.064 ↑ 1.0 1 576

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

  • Buffers: shared hit=3523
44. 3.456 3.456 ↑ 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=0.006..0.006 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=1794
45. 2.304 2.304 ↑ 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.004..0.004 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=1729
46. 1.728 1.728 ↑ 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.003..0.003 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. 4.507 13.201 ↑ 1.1 11,857 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 894kB
  • Buffers: shared hit=170
49. 3.584 8.694 ↑ 1.1 11,857 1

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

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

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

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=165
51. 0.041 0.107 ↑ 1.0 114 1

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

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

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

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=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 : 29.236 ms
Execution time : 865.131 ms