explain.depesz.com

PostgreSQL's explain analyze made readable

Result: f5WB

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 108,284.592 ↓ 0.0 0 1

Limit (cost=15,917,021.41..16,045,597.13 rows=1 width=419) (actual time=108,284.592..108,284.592 rows=0 loops=1)

  • Buffers: shared hit=812,929 read=25,884
2. 0.002 108,284.591 ↓ 0.0 0 1

Nested Loop Semi Join (cost=15,917,021.41..16,045,597.13 rows=1 width=419) (actual time=108,284.591..108,284.591 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=812,929 read=25,884
3. 0.038 108,284.589 ↓ 0.0 0 1

Nested Loop (cost=15,916,990.57..16,045,500.86 rows=1 width=436) (actual time=108,284.589..108,284.589 rows=0 loops=1)

  • Join Filter: (t38._fld20189rref = t40._fld20189rref)
  • Rows Removed by Join Filter: 182
  • Buffers: shared hit=812,929 read=25,884
4. 2,768.196 106,336.289 ↓ 2.0 2 1

Nested Loop (cost=1.27..124,833.20 rows=1 width=453) (actual time=20,674.216..106,336.289 rows=2 loops=1)

  • Join Filter: (t37._idrref = t60._fld20554rref)
  • Rows Removed by Join Filter: 12,517,708
  • Buffers: shared hit=209,379 read=25,622
5. 6.155 102,183.236 ↓ 61.5 123 1

Nested Loop (cost=1.27..112,108.54 rows=2 width=462) (actual time=20,348.698..102,183.236 rows=123 loops=1)

  • Buffers: shared hit=208,625 read=22,477
6. 159.006 78,650.702 ↓ 31.4 12,071 1

Nested Loop (cost=0.84..110,841.07 rows=385 width=294) (actual time=48.911..78,650.702 rows=12,071 loops=1)

  • Buffers: shared hit=163,757 read=18,945
7. 78,093.963 78,093.963 ↑ 1.0 56,819 1

Index Scan using _document300_bydocdate_trls on _document300 t37 (cost=0.55..92,273.32 rows=57,023 width=260) (actual time=23.749..78,093.963 rows=56,819 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_date_time > '2019-09-07 18:31:54'::timestamp without time zone))
  • Buffers: shared hit=37,758 read=18,945
8. 397.733 397.733 ↓ 0.0 0 56,819

Index Scan using _inforg20187_bydims_r on _inforg20187 t38 (cost=0.29..0.32 rows=1 width=34) (actual time=0.007..0.007 rows=0 loops=56,819)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld20188rref = t37._idrref))
  • Buffers: shared hit=125,999
9. 23,526.379 23,526.379 ↓ 0.0 0 12,071

Index Scan using _inforg17710_bydims_r on _inforg17710 t59 (cost=0.43..3.28 rows=1 width=168) (actual time=1.949..1.949 rows=0 loops=12,071)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld17711rref = t37._idrref))
  • Filter: (_fld17715 = 'Скаткін Денис Євгенович'::mvarchar)
  • Rows Removed by Filter: 1
  • Buffers: shared hit=44,868 read=3,532
10. 1,081.992 1,384.857 ↓ 1.0 101,770 123

Materialize (cost=0.00..9,932.31 rows=101,540 width=42) (actual time=0.081..11.259 rows=101,770 loops=123)

  • Buffers: shared hit=754 read=3,145
11. 302.865 302.865 ↓ 1.0 101,770 1

Seq Scan on _inforg20553 t60 (cost=0.00..9,424.61 rows=101,540 width=42) (actual time=9.892..302.865 rows=101,770 loops=1)

  • Filter: ((_fld20557 >= '2019-08-01 00:00:00'::timestamp without time zone) AND (_fld20557 <= '2019-09-10 23:59:59'::timestamp without time zone) AND (_fld717 = '0'::numeric))
  • Rows Removed by Filter: 213,979
  • Buffers: shared hit=754 read=3,145
12. 39.756 1,948.262 ↑ 139.8 91 2

GroupAggregate (cost=15,916,989.31..15,920,381.51 rows=12,718 width=18) (actual time=952.497..974.131 rows=91 loops=2)

  • Group Key: t40._fld20189rref
  • Filter: min(CASE WHEN ((max(t43._fld15641)) IS NULL) THEN false WHEN (t58._fld20230 IS NOT NULL) THEN false ELSE true END)
  • Rows Removed by Filter: 12,627
  • Buffers: shared hit=603,550 read=262
13. 11.617 1,908.506 ↑ 1.0 12,804 2

Sort (cost=15,916,989.31..15,917,021.32 rows=12,804 width=57) (actual time=951.974..954.253 rows=12,804 loops=2)

  • Sort Key: t40._fld20189rref
  • Sort Method: quicksort Memory: 1,385kB
  • Buffers: shared hit=603,550 read=262
14. 2.338 1,896.889 ↑ 1.0 12,804 1

Hash Right Join (cost=15,901,954.74..15,916,115.80 rows=12,804 width=57) (actual time=1,893.715..1,896.889 rows=12,804 loops=1)

  • Hash Cond: (t43._fld15638_rrref = t40._fld20188rref)
  • Buffers: shared hit=603,550 read=262
15. 0.607 1,879.119 ↑ 48.3 91 1

GroupAggregate (cost=15,901,478.34..15,915,534.95 rows=4,398 width=57) (actual time=1,878.253..1,879.119 rows=91 loops=1)

  • Group Key: t43._fld15638_type, t43._fld15638_rtref, t43._fld15638_rrref
  • Filter: min(CASE WHEN (((sum(t43._fld15643)) = (sum(t43._fld15644))) AND ((sum(t43._fld15643)) > '0'::numeric)) THEN true ELSE false END)
  • Rows Removed by Filter: 129
  • Buffers: shared hit=603,442 read=262
16. 0.314 1,878.512 ↑ 122.5 359 1

GroupAggregate (cost=15,901,478.34..15,903,397.02 rows=43,978 width=92) (actual time=1,878.175..1,878.512 rows=359 loops=1)

  • Group Key: t43._fld15638_type, t43._fld15638_rtref, t43._fld15638_rrref, t43._fld15641
  • Filter: ((sum(t43._fld15643) <> '0'::numeric) OR (sum(t43._fld15644) <> '0'::numeric))
  • Buffers: shared hit=603,442 read=262
17. 0.753 1,878.198 ↑ 128.6 359 1

Sort (cost=15,901,478.34..15,901,593.80 rows=46,183 width=35) (actual time=1,878.157..1,878.198 rows=359 loops=1)

  • Sort Key: t43._fld15638_rrref, t43._fld15641
  • Sort Method: quicksort Memory: 53kB
  • Buffers: shared hit=603,442 read=262
18. 216.621 1,877.445 ↑ 128.6 359 1

Index Scan using _accumrg15647_bydims_trrrnr on _accumrgt15647 t43 (cost=0.55..15,897,900.30 rows=46,183 width=35) (actual time=171.433..1,877.445 rows=359 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 = _fld15638_rtref))
  • Filter: (((_fld15643 <> '0'::numeric) OR (_fld15644 <> '0'::numeric)) AND ((_fld15643 <> '0'::numeric) OR (_fld15644 <> '0'::numeric)) AND (SubPlan 23))
  • Rows Removed by Filter: 142,196
  • Buffers: shared hit=603,439 read=262
19.          

SubPlan (for Index Scan)

20. 20.008 1,660.824 ↓ 0.0 0 16,776

Nested Loop Semi Join (cost=31.69..111.34 rows=1 width=0) (actual time=0.099..0.099 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 false END) AND (CAS (...)
  • Buffers: shared hit=491,032 read=262
21. 67.104 251.640 ↑ 1.0 1 16,776

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

  • 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 ((t43._fld15638_type = '\\010'::by (...)
  • Buffers: shared hit=117,622
22. 16.776 83.880 ↑ 1.0 1 16,776

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

  • Join Filter: ((t43._fld15638_type = '\\010'::bytea) AND (t43._fld15638_rtref = '\\000\\000\\0012'::bytea))
  • Buffers: shared hit=50,379
23. 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)

24. 67.104 67.104 ↓ 0.0 0 16,776

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

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

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

  • Index Cond: ((_fld717 = '0'::numeric) AND (t43._fld15638_rrref = _idrref))
  • Buffers: shared hit=67,243
26. 16.776 771.696 ↓ 0.0 0 16,776

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

  • Buffers: shared hit=367,917 read=11
27. 16.776 754.920 ↓ 0.0 0 16,776

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

  • Buffers: shared hit=367,917 read=11
28. 16.776 469.728 ↑ 1.0 1 16,776

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

  • Buffers: shared hit=232,713 read=7
29. 100.656 100.656 ↑ 1.0 1 16,776

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

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

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

  • Buffers: shared hit=165,609 read=7
31. 14.294 83.880 ↓ 3.0 3 16,776

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

  • Group Key: t49._reference73_idrref
  • Buffers: shared hit=5 read=5
32. 15.520 69.586 ↓ 3.0 3 1

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

  • Buffers: shared hit=5 read=5
  • -> Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t49 (cost=0.28..10.41 rows=3 width=49) (actual time=7.594..7.747 rows=2 (...)
33. 54.066 54.066 ↑ 1.0 2 1

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t50 (cost=0.28..8.86 rows=2 width=24) (actual time=54.064..54.066 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 (...)
  • Heap Fetches: 2
  • Buffers: shared hit=1 read=2
  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld2105_type = t50._fld14727_type) AND (_fld2105_rtref = t50._fld14727_rtref) AND (_fld2105_rrref = t50._f (...)
  • Heap Fetches: 3
  • Buffers: shared hit=4 read=3
34. 248.050 248.050 ↓ 0.0 0 49,610

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t47 (cost=0.42..7.44 rows=1 width=38) (actual time=0.005..0.005 rows=0 loops=49,610)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t49._reference73_idrref) AND (_fld14846rref = t48._idrref))
  • Heap Fetches: 16,776
  • Buffers: shared hit=165,604 read=2
35. 83.880 268.416 ↓ 0.0 0 16,776

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

  • 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 SubPlan 19) THEN true ELSE false E (...)
  • Rows Removed by Filter: 1
  • Heap Fetches: 16,776
  • Buffers: shared hit=135,204 read=4
36.          

SubPlan (for Index Only Scan)

37. 83.880 83.880 ↓ 0.0 0 16,776

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t53 (cost=0.28..7.31 rows=1 width=0) (actual time=0.005..0.005 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_rrref = t43._fld15642 (...)
  • Heap Fetches: 359
  • Buffers: shared hit=34,551 read=1
38. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t53_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_rrref = t43._fld15642 (...)
  • Heap Fetches: 0
39. 100.656 100.656 ↑ 1.0 1 16,776

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

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13939rref = t46._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
  • Buffers: shared hit=50,326 read=2
40. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on _inforg13938 t54_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)
41. 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))
42.          

SubPlan (for Nested Loop Semi Join)

43. 2.154 2.154 ↑ 1.0 1 359

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t51 (cost=0.31..7.34 rows=1 width=0) (actual time=0.006..0.006 rows=1 loops=359)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = CASE WHEN (CASE WHEN ((t43._fld15638_type = '\\010'::bytea) AND (t43._fld15638_rtref = '\\000\\000\\0012'::bytea)) THEN t44. (...)
  • Heap Fetches: 359
  • Buffers: shared hit=1,077
44. 0.000 0.000 ↓ 0.0 0

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

  • Filter: (_fld717 = '0'::numeric)
45. 1.795 1.795 ↑ 1.0 1 359

Index Scan using _inforg13938_bydims_rr on _inforg13938 t52 (cost=0.30..7.33 rows=1 width=0) (actual time=0.005..0.005 rows=1 loops=359)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13939rref = t46._idrref) AND (_fld13940_type = CASE WHEN (CASE WHEN ((t43._fld15638_type = '\\010'::bytea) AND (t43._fld15638_rtref = '\\ (...)
  • Filter: (NOT _fld13941)
  • Buffers: shared hit=1,077
46. 0.000 0.000 ↓ 0.0 0

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

  • Recheck Cond: (_fld717 = '0'::numeric)
  • Filter: (NOT _fld13941)
47. 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))
48. 2.513 611.377 ↑ 1.0 1 359

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

  • Buffers: shared hit=2,262 read=251
49. 605.992 605.992 ↑ 1.0 1 359

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

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13762_type = CASE WHEN (CASE WHEN ((t43._fld15638_type = '\\010'::bytea) AND (t43._fld15638_rtref = '\\000\\000\\0012'::bytea)) THE (...)
  • Heap Fetches: 359
  • Buffers: shared hit=1,185 read=251
50. 2.872 2.872 ↑ 1.0 1 359

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t55 (cost=0.28..7.31 rows=1 width=27) (actual time=0.008..0.008 rows=1 loops=359)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = t56._fld13763_type) AND (_fld13933_rtref = t56._fld13763_rtref) AND (_fld13933_rrref = t56._fld13763_rrref) AND (_fld1 (...)
  • Heap Fetches: 359
  • Buffers: shared hit=1,077
51. 2.154 2.154 ↑ 1.0 1 359

Index Scan using _inforg13938_bydims_rr on _inforg13938 t57 (cost=0.30..7.33 rows=1 width=0) (actual time=0.006..0.006 rows=1 loops=359)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13939rref = t46._idrref) AND (_fld13940_type = CASE WHEN (CASE WHEN ((t43._fld15638_type = '\\010'::bytea) AND (t43._fld15638_rtref = '\\ (...)
  • Filter: (NOT _fld13941)
  • Buffers: shared hit=1,077
52. 0.000 0.000 ↓ 0.0 0

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

  • Recheck Cond: (_fld717 = '0'::numeric)
  • Filter: (NOT _fld13941)
53. 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))
54. 5.483 15.432 ↑ 1.0 12,804 1

Hash (cost=316.34..316.34 rows=12,804 width=42) (actual time=15.432..15.432 rows=12,804 loops=1)

  • Buckets: 16,384 Batches: 1 Memory Usage: 954kB
  • Buffers: shared hit=108
55. 4.375 9.949 ↑ 1.0 12,804 1

Hash Left Join (cost=1.20..316.34 rows=12,804 width=42) (actual time=0.049..9.949 rows=12,804 loops=1)

  • Hash Cond: (t40._fld20188rref = t58._fld20229rref)
  • Buffers: shared hit=108
56. 5.556 5.556 ↑ 1.0 12,804 1

Seq Scan on _inforg20187 t40 (cost=0.00..267.05 rows=12,804 width=34) (actual time=0.018..5.556 rows=12,804 loops=1)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=107
57. 0.006 0.018 ↑ 1.0 8 1

Hash (cost=1.10..1.10 rows=8 width=25) (actual time=0.018..0.018 rows=8 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
58. 0.012 0.012 ↑ 1.0 8 1

Seq Scan on _inforg20228 t58 (cost=0.00..1.10 rows=8 width=25) (actual time=0.007..0.012 rows=8 loops=1)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=1
59. 0.000 0.000 ↓ 0.0 0

Materialize (cost=30.84..44.95 rows=1 width=17) (never executed)

60. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=30.84..44.94 rows=1 width=17) (never executed)

61. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=30.57..44.64 rows=1 width=38) (never executed)

62. 0.000 0.000 ↓ 0.0 0

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

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

Nested Loop (cost=30.17..37.21 rows=1 width=57) (never executed)

64. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=29.75..29.76 rows=1 width=19) (never executed)

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

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

66. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t65 (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 = 'P\\2140Z:wL\\341\\021\\347\\024w\\304\\321\\272\\236 (...)
  • Heap Fetches: 0
67. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t64 (cost=0.28..10.41 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
68. 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
69. 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
70.          

SubPlan (for Nested Loop Semi Join)

71. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t66 (cost=0.28..7.31 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
72. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on _inforg13931 t66_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))
73. 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))
74. 0.000 0.000 ↓ 0.0 0

Index Scan using _inforg13938_bydims_rr on _inforg13938 t67 (cost=0.28..7.30 rows=1 width=0) (never executed)

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

Bitmap Heap Scan on _inforg13938 t67_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)
76. 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))
77. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t71 (cost=0.28..7.31 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
78. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on _inforg13931 t71_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))
79. 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))
80. 0.000 0.000 ↓ 0.0 0

Index Scan using _inforg13938_bydims_rr on _inforg13938 t72 (cost=0.28..7.30 rows=1 width=0) (never executed)

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

Bitmap Heap Scan on _inforg13938 t72_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)
82. 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))
83. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.70..14.77 rows=1 width=0) (never executed)

84. 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
85. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t68 (cost=0.28..7.31 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
86. 0.000 0.000 ↓ 0.0 0

Index Scan using _inforg13938_bydims_rr on _inforg13938 t70 (cost=0.28..7.30 rows=1 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13939rref = t61._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\242'::bytea))
  • Filter: (NOT _fld13941)
87. 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\\242'::bytea))
  • Filter: (NOT _fld13941)
88. 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 : 28.455 ms
Execution time : 108,287.910 ms