explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dqE

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 860.055 ↓ 2.0 2 1

Limit (cost=15,910,328.42..15,935,337.23 rows=1 width=419) (actual time=796.651..860.055 rows=2 loops=1)

  • Buffers: shared hit=658,115
2. 0.035 860.054 ↓ 2.0 2 1

Nested Loop Semi Join (cost=15,910,328.42..15,935,337.23 rows=1 width=419) (actual time=796.650..860.054 rows=2 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=658,115
3. 0.005 859.887 ↑ 3.0 2 1

Nested Loop (cost=15,910,297.57..15,934,984.39 rows=6 width=436) (actual time=796.536..859.887 rows=2 loops=1)

  • Join Filter: (t36._idrref = t57._fld17711rref)
  • Buffers: shared hit=658,047
4. 20.018 859.864 ↑ 3.0 2 1

Nested Loop (cost=15,910,297.15..15,934,977.51 rows=6 width=319) (actual time=796.524..859.864 rows=2 loops=1)

  • Join Filter: (t37._fld20189rref = t38.q_001_f_000rref)
  • Rows Removed by Join Filter: 229,085
  • Buffers: shared hit=658,039
5. 1.466 36.971 ↓ 356.8 2,141 1

Nested Loop (cost=1.26..12,036.46 rows=6 width=336) (actual time=0.082..36.971 rows=2,141 loops=1)

  • Join Filter: (t36._idrref = t58._fld20554rref)
  • Buffers: shared hit=39,080
6. 6.005 21.882 ↓ 119.5 4,541 1

Nested Loop (cost=0.84..11,962.19 rows=38 width=294) (actual time=0.056..21.882 rows=4,541 loops=1)

  • Buffers: shared hit=20,882
7. 4.967 4.967 ↑ 1.0 5,455 1

Index Scan using _document300_bydocdate_trls on _document300 t36 (cost=0.55..9,581.98 rows=5,634 width=260) (actual time=0.027..4.967 rows=5,455 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_date_time > '2019-09-26 14:10:02'::timestamp without time zone))
  • Buffers: shared hit=5,381
8. 10.910 10.910 ↑ 1.0 1 5,455

Index Scan using _inforg20187_bydims_r on _inforg20187 t37 (cost=0.29..0.41 rows=1 width=34) (actual time=0.002..0.002 rows=1 loops=5,455)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld20188rref = t36._idrref))
  • Buffers: shared hit=15,501
9. 13.623 13.623 ↓ 0.0 0 4,541

Index Scan using _inforg20553_bydims_r on _inforg20553 t58 (cost=0.42..1.94 rows=1 width=42) (actual time=0.003..0.003 rows=0 loops=4,541)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld20554rref = t37._fld20188rref))
  • Filter: ((_fld20557 >= '2019-01-01 00:00:00'::timestamp without time zone) AND (_fld20557 <= '2019-09-27 23:59:59'::timestamp without time zone))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=18,198
10. 9.019 802.875 ↑ 118.9 107 2,141

Materialize (cost=15,910,295.89..15,921,828.23 rows=12,718 width=17) (actual time=0.365..0.375 rows=107 loops=2,141)

  • Buffers: shared hit=618,959
11. 0.009 793.856 ↑ 118.9 107 1

Subquery Scan on t38 (cost=15,910,295.89..15,921,764.64 rows=12,718 width=17) (actual time=781.683..793.856 rows=107 loops=1)

  • Buffers: shared hit=618,959
12. 11.718 793.847 ↑ 118.9 107 1

GroupAggregate (cost=15,910,295.89..15,921,637.46 rows=12,718 width=18) (actual time=781.682..793.847 rows=107 loops=1)

  • Group Key: t39._fld20189rref
  • Filter: min(CASE WHEN ((t41._fld15638_type IS NULL) AND (t41._fld15638_rtref IS NULL) AND (t41._fld15638_rrref IS NULL)) THEN false WHEN (t56._fld20230 IS NOT NULL) THEN false ELSE true END)
  • Rows Removed by Filter: 12,611
  • Buffers: shared hit=618,959
13. 6.846 782.129 ↑ 3.4 12,804 1

Sort (cost=15,910,295.89..15,910,405.83 rows=43,978 width=49) (actual time=781.238..782.129 rows=12,804 loops=1)

  • Sort Key: t39._fld20189rref
  • Sort Method: quicksort Memory: 1,385kB
  • Buffers: shared hit=618,959
14. 16.996 775.283 ↑ 3.4 12,804 1

Nested Loop Left Join (cost=0.84..15,906,904.19 rows=43,978 width=49) (actual time=65.105..775.283 rows=12,804 loops=1)

  • Join Filter: (t39._fld20188rref = t56._fld20229rref)
  • Rows Removed by Join Filter: 102,424
  • Buffers: shared hit=618,959
15. 2.309 758.287 ↑ 3.4 12,804 1

Merge Left Join (cost=0.84..15,901,625.71 rows=43,978 width=58) (actual time=65.080..758.287 rows=12,804 loops=1)

  • Merge Cond: (t39._fld20188rref = t41._fld15638_rrref)
  • Buffers: shared hit=618,958
16. 6.860 6.860 ↑ 1.0 12,804 1

Index Scan using _inforg20187_bydims_r on _inforg20187 t39 (cost=0.29..680.79 rows=12,804 width=34) (actual time=0.027..6.860 rows=12,804 loops=1)

  • Index Cond: (_fld717 = '0'::numeric)
  • Buffers: shared hit=12,546
17. 0.052 749.118 ↑ 411.0 107 1

Materialize (cost=0.55..15,900,363.19 rows=43,978 width=24) (actual time=65.050..749.118 rows=107 loops=1)

  • Buffers: shared hit=606,412
18. 0.761 749.066 ↑ 411.0 107 1

GroupAggregate (cost=0.55..15,899,813.46 rows=43,978 width=88) (actual time=65.045..749.066 rows=107 loops=1)

  • Group Key: t41._fld15638_type, t41._fld15638_rtref, t41._fld15638_rrref
  • Filter: ((sum(t41._fld15643) > '0'::numeric) AND (sum(t41._fld15643) = sum(t41._fld15644)) AND ((sum(t41._fld15643) <> '0'::numeric) OR (sum(t41._fld15644) <> '0'::numeric)))
  • Rows Removed by Filter: 180
  • Buffers: shared hit=606,412
19. 144.369 748.305 ↑ 88.6 521 1

Index Scan using _accumrg15647_bydims_trrrnr on _accumrgt15647 t41 (cost=0.55..15,897,900.30 rows=46,183 width=31) (actual time=19.334..748.305 rows=521 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,'::bytea = _fld15 (...)
  • Filter: (((_fld15643 <> '0'::numeric) OR (_fld15644 <> '0'::numeric)) AND ((_fld15643 <> '0'::numeric) OR (_fld15644 <> '0'::numeric)) AND (SubPlan 23))
  • Rows Removed by Filter: 142,034
  • Buffers: shared hit=606,412
20.          

SubPlan (for Index Scan)

21. 20.527 603.936 ↓ 0.0 0 16,776

Nested Loop Semi Join (cost=31.69..111.34 rows=1 width=0) (actual time=0.036..0.036 rows=0 loops=16,776)

  • 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 true ELSE f (...)
  • Buffers: shared hit=494,005
22. 50.328 167.760 ↑ 1.0 1 16,776

Nested Loop Left Join (cost=0.84..14.98 rows=1 width=68) (actual time=0.009..0.010 rows=1 loops=16,776)

  • Join Filter: ((t41._fld15638_type = '\\010'::bytea) AND (t41._fld15638_rtref = '\\000\\000\\001,'::bytea))
  • Filter: ((CASE WHEN (CASE WHEN ((t41._fld15638_type = '\\010'::bytea) AND (t41._fld15638_rtref = '\\000\\000\\0012'::bytea)) THEN t42._fld8248rref WHEN ((t41._fld15638_ (...)
  • Buffers: shared hit=117,625
23. 0.000 50.328 ↑ 1.0 1 16,776

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

  • Join Filter: ((t41._fld15638_type = '\\010'::bytea) AND (t41._fld15638_rtref = '\\000\\000\\0012'::bytea))
  • Buffers: shared hit=50,379
24. 0.000 0.000 ↑ 1.0 1 16,776

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

25. 50.328 50.328 ↓ 0.0 0 16,776

Index Scan using _document306hpk on _document306 t42 (cost=0.42..7.44 rows=1 width=34) (actual time=0.003..0.003 rows=0 loops=16,776)

  • Index Cond: ((_fld717 = '0'::numeric) AND (t41._fld15638_rrref = _idrref))
  • Buffers: shared hit=50,379
26. 67.104 67.104 ↑ 1.0 1 16,776

Index Scan using _document300hpk on _document300 t43 (cost=0.43..7.45 rows=1 width=34) (actual time=0.004..0.004 rows=1 loops=16,776)

  • Index Cond: ((_fld717 = '0'::numeric) AND (t41._fld15638_rrref = _idrref))
  • Buffers: shared hit=67,246
27. 0.000 402.624 ↓ 0.0 0 16,776

Materialize (cost=30.84..59.56 rows=1 width=17) (actual time=0.024..0.024 rows=0 loops=16,776)

  • Buffers: shared hit=368,040
28. 16.776 402.624 ↓ 0.0 0 16,776

Nested Loop (cost=30.84..59.56 rows=1 width=17) (actual time=0.024..0.024 rows=0 loops=16,776)

  • Buffers: shared hit=368,040
29. 0.000 234.864 ↑ 1.0 1 16,776

Nested Loop (cost=30.57..44.64 rows=1 width=38) (actual time=0.011..0.014 rows=1 loops=16,776)

  • Buffers: shared hit=233,311
30. 67.104 67.104 ↑ 1.0 1 16,776

Index Only Scan using _reference105_byfield2798_sr on _reference105 t46 (cost=0.41..7.42 rows=1 width=19) (actual time=0.004..0.004 rows=1 loops=16,776)

  • Index Cond: (_fld2789 = 'РегистрНакопления.ЗаказыКлиентов'::mvarchar)
  • Heap Fetches: 16,776
  • Buffers: shared hit=67,104
31. 167.760 167.760 ↑ 1.0 1 16,776

Nested Loop (cost=30.17..37.21 rows=1 width=57) (actual time=0.007..0.010 rows=1 loops=16,776)

  • Buffers: shared hit=166,207
  • -> Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t45 (cost=0.42..7.44 rows=1 width=38) (actual time=0.003..0.003 rows=0 loops=49 (...)
32. 0.000 0.000 ↓ 3.0 3 16,776

HashAggregate (cost=29.75..29.76 rows=1 width=19) (actual time=0.000..0.000 rows=3 loops=16,776)

  • Group Key: t47._reference73_idrref
  • Buffers: shared hit=10
  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t47._reference73_idrref) AND (_fld14846rref = t46._idrref))
  • Heap Fetches: 16,776
  • Buffers: shared hit=166,197
33. 0.051 0.051 ↓ 3.0 3 1

Nested Loop (cost=0.56..29.75 rows=1 width=19) (actual time=0.045..0.051 rows=3 loops=1)

  • Buffers: shared hit=10
  • -> Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t48 (cost=0.28..8.86 rows=2 width=24) (actual time=0.016..0.018 row (...)
  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14728_type = '\\010'::bytea) AND (_fld14728_rtref = '\\000\\000\\000\\254'::bytea) AN (...)
  • Heap Fetches: 2
  • Buffers: shared hit=3
  • -> Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t47 (cost=0.28..10.41 rows=3 width=49) (actual time=0 (...)
  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld2105_type = t48._fld14727_type) AND (_fld2105_rtref = t48._fld14727_rtref) AND (_fld2 (...)
  • Heap Fetches: 3
  • Buffers: shared hit=7
34. 50.328 150.984 ↓ 0.0 0 16,776

Index Only Scan using _reference73hpk on _reference73 t44 (cost=0.27..14.91 rows=1 width=17) (actual time=0.009..0.009 rows=0 loops=16,776)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t45._fld14847rref))
  • Filter: (CASE WHEN (alternatives: SubPlan 16 or hashed SubPlan 17) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 18 or hashed SubPlan 19) THEN (...)
  • Rows Removed by Filter: 1
  • Heap Fetches: 16,776
  • Buffers: shared hit=134,729
35.          

SubPlan (for Index Only Scan)

36. 50.328 50.328 ↓ 0.0 0 16,776

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t51 (cost=0.28..7.31 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=16,776)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\340'::bytea) AND (_fld13933_rrr (...)
  • Heap Fetches: 521
  • Buffers: shared hit=34,073
37. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t51_1 (cost=0.28..7.30 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 (_fld13933_rrr (...)
  • Heap Fetches: 0
38. 50.328 50.328 ↑ 1.0 1 16,776

Index Scan using _inforg13938_bydims_rr on _inforg13938 t52 (cost=0.28..7.30 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=16,776)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13939rref = t44._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\00 (...)
  • Filter: (NOT _fld13941)
  • Buffers: shared hit=50,328
39. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on _inforg13938 t52_1 (cost=9.35..51.24 rows=31 width=17) (never executed)

  • Recheck Cond: ((_fld717 = '0'::numeric) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
40. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on _inforg13938_bydims13943_rr (cost=0.00..9.34 rows=165 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
41.          

SubPlan (for Nested Loop Semi Join)

42. 2.084 2.084 ↑ 1.0 1 521

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t49 (cost=0.31..7.34 rows=1 width=0) (actual time=0.004..0.004 rows=1 loops=521)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = CASE WHEN (CASE WHEN ((t41._fld15638_type = '\\010'::bytea) AND (t41._fld15638_rtref = '\\000\\000\\0012': (...)
  • Heap Fetches: 521
  • Buffers: shared hit=1,563
43. 0.000 0.000 ↓ 0.0 0

Seq Scan on _inforg13931 t49_1 (cost=0.00..52.78 rows=2,302 width=45) (never executed)

  • Filter: (_fld717 = '0'::numeric)
44. 1.563 1.563 ↑ 1.0 1 521

Index Scan using _inforg13938_bydims_rr on _inforg13938 t50 (cost=0.30..7.33 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=521)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13939rref = t44._idrref) AND (_fld13940_type = CASE WHEN (CASE WHEN ((t41._fld15638_type = '\\010'::bytea) AND (t41._fl (...)
  • Filter: (NOT _fld13941)
  • Buffers: shared hit=1,563
45. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on _inforg13938 t50_1 (cost=32.28..80.43 rows=732 width=24) (never executed)

  • Recheck Cond: (_fld717 = '0'::numeric)
  • Filter: (NOT _fld13941)
46. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on _inforg13938_byresource13945_lrr (cost=0.00..32.10 rows=732 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false))
47. 2.084 7.815 ↑ 1.0 1 521

Nested Loop (cost=0.73..14.79 rows=1 width=0) (actual time=0.015..0.015 rows=1 loops=521)

  • Buffers: shared hit=3,651
48. 3.647 3.647 ↑ 1.0 1 521

Index Only Scan using _inforg13761_bydims_rrn on _inforg13761 t54 (cost=0.45..7.48 rows=1 width=24) (actual time=0.007..0.007 rows=1 loops=521)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13762_type = CASE WHEN (CASE WHEN ((t41._fld15638_type = '\\010'::bytea) AND (t41._fld15638_rtref = '\\000\\000\\ (...)
  • Heap Fetches: 521
  • Buffers: shared hit=2,088
49. 2.084 2.084 ↑ 1.0 1 521

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t53 (cost=0.28..7.31 rows=1 width=27) (actual time=0.004..0.004 rows=1 loops=521)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = t54._fld13763_type) AND (_fld13933_rtref = t54._fld13763_rtref) AND (_fld13933_rrref = t54._fld13763 (...)
  • Heap Fetches: 521
  • Buffers: shared hit=1,563
50. 1.563 1.563 ↑ 1.0 1 521

Index Scan using _inforg13938_bydims_rr on _inforg13938 t55 (cost=0.30..7.33 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=521)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13939rref = t44._idrref) AND (_fld13940_type = CASE WHEN (CASE WHEN ((t41._fld15638_type = '\\010'::bytea) AND (t41._fl (...)
  • Filter: (NOT _fld13941)
  • Buffers: shared hit=1,563
51. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on _inforg13938 t55_1 (cost=32.28..80.43 rows=732 width=24) (never executed)

  • Recheck Cond: (_fld717 = '0'::numeric)
  • Filter: (NOT _fld13941)
52. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on _inforg13938_byresource13945_lrr (cost=0.00..32.10 rows=732 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false))
53. 0.000 0.000 ↑ 1.0 8 12,804

Materialize (cost=0.00..1.14 rows=8 width=25) (actual time=0.000..0.000 rows=8 loops=12,804)

  • Buffers: shared hit=1
54. 0.011 0.011 ↑ 1.0 8 1

Seq Scan on _inforg20228 t56 (cost=0.00..1.10 rows=8 width=25) (actual time=0.010..0.011 rows=8 loops=1)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=1
55. 0.018 0.018 ↑ 1.0 1 2

Index Scan using _inforg17710_bydims_r on _inforg17710 t57 (cost=0.43..1.13 rows=1 width=168) (actual time=0.008..0.009 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld17711rref = t58._fld20554rref))
  • Buffers: shared hit=8
56. 0.001 0.058 ↑ 1.0 1 2

Materialize (cost=30.84..44.95 rows=1 width=17) (actual time=0.029..0.029 rows=1 loops=2)

  • Buffers: shared hit=24
57. 0.002 0.057 ↑ 1.0 1 1

Nested Loop (cost=30.84..44.94 rows=1 width=17) (actual time=0.057..0.057 rows=1 loops=1)

  • Buffers: shared hit=24
58. 0.002 0.052 ↑ 1.0 1 1

Nested Loop (cost=30.57..44.64 rows=1 width=38) (actual time=0.052..0.052 rows=1 loops=1)

  • Buffers: shared hit=21
59. 0.009 0.009 ↑ 1.0 1 1

Index Only Scan using _reference105_byfield2798_sr on _reference105 t61 (cost=0.41..7.42 rows=1 width=19) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (_fld2789 = 'Документ.ЗаказКлиента'::mvarchar)
  • Heap Fetches: 1
  • Buffers: shared hit=4
60. 0.003 0.041 ↑ 1.0 1 1

Nested Loop (cost=30.17..37.21 rows=1 width=57) (actual time=0.041..0.041 rows=1 loops=1)

  • Buffers: shared hit=17
61. 0.003 0.028 ↓ 2.0 2 1

HashAggregate (cost=29.75..29.76 rows=1 width=19) (actual time=0.028..0.028 rows=2 loops=1)

  • Group Key: t62._reference73_idrref
  • Buffers: shared hit=10
62. 0.003 0.025 ↓ 3.0 3 1

Nested Loop (cost=0.56..29.75 rows=1 width=19) (actual time=0.022..0.025 rows=3 loops=1)

  • Buffers: shared hit=10
63. 0.008 0.008 ↑ 1.0 2 1

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t63 (cost=0.28..8.86 rows=2 width=24) (actual time=0.008..0.008 rows=2 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14728_type = '\\010'::bytea) AND (_fld14728_rtref = '\\000\\000\\000\\254'::bytea) AND (_fld14728_rrref = '\\245\\2300Z:wN\\241\\021\\350\\376\\327\\252I\\247D (...)
  • Heap Fetches: 2
  • Buffers: shared hit=3
64. 0.014 0.014 ↑ 1.5 2 2

Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t62 (cost=0.28..10.41 rows=3 width=49) (actual time=0.005..0.007 rows=2 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld2105_type = t63._fld14727_type) AND (_fld2105_rtref = t63._fld14727_rtref) AND (_fld2105_rrref = t63._fld14727_rrref))
  • Heap Fetches: 3
  • Buffers: shared hit=7
65. 0.010 0.010 ↓ 0.0 0 2

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t60 (cost=0.42..7.44 rows=1 width=38) (actual time=0.005..0.005 rows=0 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t62._reference73_idrref) AND (_fld14846rref = t61._idrref))
  • Heap Fetches: 1
  • Buffers: shared hit=7
66. 0.003 0.003 ↑ 1.0 1 1

Index Only Scan using _reference73hpk on _reference73 t59 (cost=0.27..0.29 rows=1 width=17) (actual time=0.003..0.003 rows=1 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t60._fld14847rref))
  • Heap Fetches: 1
  • Buffers: shared hit=3
67.          

SubPlan (for Nested Loop Semi Join)

68. 0.010 0.010 ↑ 1.0 1 2

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t64 (cost=0.28..7.31 rows=1 width=0) (actual time=0.005..0.005 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\340'::bytea) AND (_fld13933_rrref = t36._fld7786rref) AND (_fld13932rref = t59._idrref))
  • Heap Fetches: 2
  • Buffers: shared hit=6
69. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on _inforg13931 t64_1 (cost=14.09..42.64 rows=260 width=36) (never executed)

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

Bitmap Index Scan on _inforg13931_bydims13935_rr (cost=0.00..14.03 rows=260 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\340'::bytea))
71. 0.010 0.010 ↑ 1.0 1 2

Index Scan using _inforg13938_bydims_rr on _inforg13938 t65 (cost=0.28..7.30 rows=1 width=0) (actual time=0.005..0.005 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13939rref = t59._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
  • Buffers: shared hit=6
72. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on _inforg13938 t65_1 (cost=9.35..51.24 rows=31 width=17) (never executed)

  • Recheck Cond: ((_fld717 = '0'::numeric) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
73. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on _inforg13938_bydims13943_rr (cost=0.00..9.34 rows=165 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
74. 0.008 0.008 ↑ 1.0 1 2

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t69 (cost=0.28..7.31 rows=1 width=0) (actual time=0.004..0.004 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\361'::bytea) AND (_fld13933_rrref = t36._fld7818rref) AND (_fld13932rref = t59._idrref))
  • Heap Fetches: 2
  • Buffers: shared hit=6
75. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on _inforg13931 t69_1 (cost=9.45..36.42 rows=170 width=36) (never executed)

  • Recheck Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\361'::bytea))
76. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on _inforg13931_bydims13935_rr (cost=0.00..9.40 rows=170 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\361'::bytea))
77. 0.008 0.008 ↑ 1.0 1 2

Index Scan using _inforg13938_bydims_rr on _inforg13938 t70 (cost=0.28..7.30 rows=1 width=0) (actual time=0.004..0.004 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13939rref = t59._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\361'::bytea))
  • Filter: (NOT _fld13941)
  • Buffers: shared hit=6
78. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on _inforg13938 t70_1 (cost=9.35..51.24 rows=31 width=17) (never executed)

  • Recheck Cond: ((_fld717 = '0'::numeric) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\361'::bytea))
  • Filter: (NOT _fld13941)
79. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on _inforg13938_bydims13943_rr (cost=0.00..9.34 rows=165 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\361'::bytea))
80. 0.004 0.032 ↑ 1.0 1 2

Nested Loop (cost=0.70..14.77 rows=1 width=0) (actual time=0.016..0.016 rows=1 loops=2)

  • Buffers: shared hit=14
81. 0.018 0.018 ↑ 1.0 1 2

Index Only Scan using _inforg13761_bydims_rrn on _inforg13761 t67 (cost=0.42..7.45 rows=1 width=24) (actual time=0.009..0.009 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13762_type = '\\010'::bytea) AND (_fld13762_rtref = '\\000\\000\\000\\242'::bytea) AND (_fld13762_rrref = t36._fld7777rref))
  • Heap Fetches: 2
  • Buffers: shared hit=8
82. 0.010 0.010 ↑ 1.0 1 2

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t66 (cost=0.28..7.31 rows=1 width=27) (actual time=0.005..0.005 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = t67._fld13763_type) AND (_fld13933_rtref = t67._fld13763_rtref) AND (_fld13933_rrref = t67._fld13763_rrref) AND (_fld13932rref = t59._idrref))
  • Heap Fetches: 2
  • Buffers: shared hit=6
83. 0.006 0.006 ↑ 1.0 1 2

Index Scan using _inforg13938_bydims_rr on _inforg13938 t68 (cost=0.28..7.30 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=2)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13939rref = t59._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\242'::bytea))
  • Filter: (NOT _fld13941)
  • Buffers: shared hit=6
84. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on _inforg13938 t68_1 (cost=9.35..51.24 rows=31 width=17) (never executed)

  • Recheck Cond: ((_fld717 = '0'::numeric) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\242'::bytea))
  • Filter: (NOT _fld13941)
85. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on _inforg13938_bydims13943_rr (cost=0.00..9.34 rows=165 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\242'::bytea))
Planning time : 29.411 ms
Execution time : 861.673 ms