explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dm7

Settings
# exclusive inclusive rows x rows loops node
1. 0.081 582,404.562 ↓ 258.0 258 1

Group (cost=4,944,164.52..4,944,164.53 rows=1 width=200) (actual time=582,404.403..582,404.562 rows=258 loops=1)

  • Group Key: t2._period, (CASE WHEN (t4._idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END), (CASE WHEN (t4._idrref IS NOT NULL) THEN '\\x000000da'::bytea ELSE NULL::bytea END), t4._idrref, t2._fld45482rref, t2._fld45483rref, t2._fld45484rref
2. 2.455 582,404.481 ↓ 258.0 258 1

Sort (cost=4,944,164.52..4,944,164.53 rows=1 width=200) (actual time=582,404.401..582,404.481 rows=258 loops=1)

  • Sort Key: t2._period, (CASE WHEN (t4._idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END), (CASE WHEN (t4._idrref IS NOT NULL) THEN '\\x000000da'::bytea ELSE NULL::bytea END), t4._idrref, t2._fld45482rref
  • Sort Method: quicksort Memory: 61kB
3. 3.890 582,402.026 ↓ 258.0 258 1

Nested Loop Left Join (cost=4,883,019.34..4,944,164.52 rows=1 width=200) (actual time=19,321.007..582,402.026 rows=258 loops=1)

4. 7.663 7,669.080 ↓ 258.0 258 1

Nested Loop (cost=4,316,954.48..4,317,832.23 rows=1 width=200) (actual time=7,598.176..7,669.080 rows=258 loops=1)

5. 21.863 7,610.727 ↓ 24.6 5,069 1

HashAggregate (cost=4,316,954.26..4,316,956.32 rows=206 width=336) (actual time=7,597.595..7,610.727 rows=5,069 loops=1)

  • Group Key: (CASE WHEN (t4._idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END), (CASE WHEN (t4._idrref IS NOT NULL) THEN '\\x000000da'::bytea ELSE NULL::bytea END), t4._idrref, t2._fld45482rref, t3._date_time, t2._period, t2._fld45483rref, t2._fld45486_type, t2._fld45486_rtref, t2._fld45486_rrref, t2._fld45484rref, t2._fld45485rref
6. 1.117 7,588.864 ↓ 24.6 5,069 1

Append (cost=0.56..4,316,951.79 rows=206 width=336) (actual time=306.763..7,588.864 rows=5,069 loops=1)

7. 0.001 275.998 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..144,555.16 rows=1 width=205) (actual time=275.998..275.998 rows=0 loops=1)

8. 9.774 275.997 ↓ 0.0 0 1

Nested Loop (cost=0.45..144,555.01 rows=1 width=152) (actual time=275.997..275.997 rows=0 loops=1)

9. 87.825 87.825 ↑ 1.0 29,733 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t3 (cost=0.22..28,392.76 rows=29,750 width=58) (actual time=0.081..87.825 rows=29,733 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000000da'::bytea))
10. 178.398 178.398 ↓ 0.0 0 29,733

Index Scan using _inforg45481_bydims_rt on _inforg45481 t2 (cost=0.22..3.89 rows=1 width=114) (actual time=0.006..0.006 rows=0 loops=29,733)

  • Index Cond: ((_fld45482rref = t3._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t3._marked) OR (t3._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
11. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document218_pkey on _document218 t4 (cost=0.12..0.14 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t3._fld27211_rrref)
  • Filter: ((t3._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t3._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000000da'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
12. 0.841 585.264 ↓ 316.3 949 1

Nested Loop Left Join (cost=0.61..168,979.98 rows=3 width=205) (actual time=30.762..585.264 rows=949 loops=1)

13. 5.394 581.576 ↓ 316.3 949 1

Nested Loop (cost=0.45..168,979.36 rows=3 width=152) (actual time=30.678..581.576 rows=949 loops=1)

14. 429.007 429.007 ↓ 29.9 5,075 1

Index Scan using _inforg45481_byperiod_tr on _inforg45481 t5 (cost=0.22..168,256.52 rows=170 width=114) (actual time=13.950..429.007 rows=5,075 loops=1)

  • Index Cond: ((_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea))
  • Rows Removed by Filter: 224856
15. 147.175 147.175 ↓ 0.0 0 5,075

Index Scan using _document27198ng_pkey on _document27198 t6 (cost=0.22..4.24 rows=1 width=58) (actual time=0.029..0.029 rows=0 loops=5,075)

  • Index Cond: (_idrref = t5._fld45482rref)
  • Filter: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000000dd'::bytea) AND ((NOT _marked) OR (_marked AND (t5._fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 1
16. 2.847 2.847 ↑ 1.0 1 949

Index Only Scan using _document221ng_pkey on _document221 t7 (cost=0.17..0.20 rows=1 width=19) (actual time=0.003..0.003 rows=1 loops=949)

  • Index Cond: (_idrref = t6._fld27211_rrref)
  • Filter: ((t6._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t6._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000000dd'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
17. 0.001 221.904 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.61..168,980.01 rows=3 width=203) (actual time=221.904..221.904 rows=0 loops=1)

18. 1.569 221.903 ↓ 0.0 0 1

Nested Loop (cost=0.45..168,979.36 rows=3 width=152) (actual time=221.903..221.903 rows=0 loops=1)

19. 200.034 200.034 ↓ 29.9 5,075 1

Index Scan using _inforg45481_byperiod_tr on _inforg45481 t8 (cost=0.22..168,256.52 rows=170 width=114) (actual time=0.925..200.034 rows=5,075 loops=1)

  • Index Cond: ((_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea))
  • Rows Removed by Filter: 224856
20. 20.300 20.300 ↓ 0.0 0 5,075

Index Scan using _document27198ng_pkey on _document27198 t9 (cost=0.22..4.24 rows=1 width=58) (actual time=0.004..0.004 rows=0 loops=5,075)

  • Index Cond: (_idrref = t8._fld45482rref)
  • Filter: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000000df'::bytea) AND ((NOT _marked) OR (_marked AND (t8._fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 1
21. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document223ng_pkey on _document223 t10 (cost=0.17..0.21 rows=1 width=17) (never executed)

  • Index Cond: (_idrref = t9._fld27211_rrref)
  • Filter: ((t9._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t9._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000000df'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
22. 0.000 264.738 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.61..168,979.57 rows=1 width=206) (actual time=264.738..264.738 rows=0 loops=1)

23. 1.084 264.738 ↓ 0.0 0 1

Nested Loop (cost=0.45..168,979.36 rows=1 width=152) (actual time=264.738..264.738 rows=0 loops=1)

24. 238.279 238.279 ↓ 29.9 5,075 1

Index Scan using _inforg45481_byperiod_tr on _inforg45481 t11 (cost=0.22..168,256.52 rows=170 width=114) (actual time=0.861..238.279 rows=5,075 loops=1)

  • Index Cond: ((_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea))
  • Rows Removed by Filter: 224856
25. 25.375 25.375 ↓ 0.0 0 5,075

Index Scan using _document27198ng_pkey on _document27198 t12 (cost=0.22..4.24 rows=1 width=58) (actual time=0.005..0.005 rows=0 loops=5,075)

  • Index Cond: (_idrref = t11._fld45482rref)
  • Filter: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x0000812c'::bytea) AND ((NOT _marked) OR (_marked AND (t11._fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 1
26. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document33068ng_pkey1 on _document33068 t13 (cost=0.17..0.20 rows=1 width=20) (never executed)

  • Index Cond: (_idrref = t12._fld27211_rrref)
  • Filter: ((t12._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t12._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x0000812c'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
27. 0.001 32.513 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.39 rows=1 width=205) (actual time=32.513..32.513 rows=0 loops=1)

28. 1.583 32.512 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=32.512..32.512 rows=0 loops=1)

29. 11.138 11.138 ↓ 1.1 2,199 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t15 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.051..11.138 rows=2,199 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000000f8'::bytea))
30. 19.791 19.791 ↓ 0.0 0 2,199

Index Scan using _inforg45481_bydims_rt on _inforg45481 t14 (cost=0.22..4.22 rows=1 width=114) (actual time=0.009..0.009 rows=0 loops=2,199)

  • Index Cond: ((_fld45482rref = t15._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t15._marked) OR (t15._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
31. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document248_pkey on _document248 t16 (cost=0.11..0.14 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t15._fld27211_rrref)
  • Filter: ((t15._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t15._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000000f8'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
32. 0.001 11.499 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.38 rows=1 width=205) (actual time=11.499..11.499 rows=0 loops=1)

33. 0.479 11.498 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=11.498..11.498 rows=0 loops=1)

34. 3.669 3.669 ↑ 2.8 735 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t18 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.027..3.669 rows=735 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000000fb'::bytea))
35. 7.350 7.350 ↓ 0.0 0 735

Index Scan using _inforg45481_bydims_rt on _inforg45481 t17 (cost=0.22..4.22 rows=1 width=114) (actual time=0.010..0.010 rows=0 loops=735)

  • Index Cond: ((_fld45482rref = t18._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t18._marked) OR (t18._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
36. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document251_pkey on _document251 t19 (cost=0.11..0.13 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t18._fld27211_rrref)
  • Filter: ((t18._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t18._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000000fb'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
37. 0.000 0.293 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.45..10,619.34 rows=1 width=206) (actual time=0.293..0.293 rows=0 loops=1)

  • Join Filter: ((t21._fld27211_type = CASE WHEN (t22._idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t21._fld27211_rtref = CASE WHEN (t22._idrref IS NOT NULL) THEN '\\x000000fc'::bytea ELSE NULL::bytea END) AND (t21._fld27211_rrref = t22._idrref))
38. 0.012 0.293 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=0.293..0.293 rows=0 loops=1)

39. 0.097 0.097 ↑ 88.5 23 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t21 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.022..0.097 rows=23 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000000fc'::bytea))
40. 0.184 0.184 ↓ 0.0 0 23

Index Scan using _inforg45481_bydims_rt on _inforg45481 t20 (cost=0.22..4.22 rows=1 width=114) (actual time=0.008..0.008 rows=0 loops=23)

  • Index Cond: ((_fld45482rref = t21._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t21._marked) OR (t21._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
41. 0.000 0.000 ↓ 0.0 0

Seq Scan on _document252 t22 (cost=0.00..4.48 rows=48 width=20) (never executed)

42. 0.002 57.046 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.40 rows=1 width=205) (actual time=57.046..57.046 rows=0 loops=1)

43. 1.651 57.044 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=57.044..57.044 rows=0 loops=1)

44. 18.340 18.340 ↓ 2.0 4,117 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t24 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.012..18.340 rows=4,117 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000000fd'::bytea))
45. 37.053 37.053 ↓ 0.0 0 4,117

Index Scan using _inforg45481_bydims_rt on _inforg45481 t23 (cost=0.22..4.22 rows=1 width=114) (actual time=0.009..0.009 rows=0 loops=4,117)

  • Index Cond: ((_fld45482rref = t24._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t24._marked) OR (t24._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
46. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document253_pkey on _document253 t25 (cost=0.11..0.15 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t24._fld27211_rrref)
  • Filter: ((t24._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t24._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000000fd'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
47. 0.003 6.839 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.38 rows=1 width=205) (actual time=6.839..6.839 rows=0 loops=1)

48. 0.226 6.836 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=6.836..6.836 rows=0 loops=1)

49. 1.983 1.983 ↑ 3.1 661 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t27 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.024..1.983 rows=661 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x00000131'::bytea))
50. 4.627 4.627 ↓ 0.0 0 661

Index Scan using _inforg45481_bydims_rt on _inforg45481 t26 (cost=0.22..4.22 rows=1 width=114) (actual time=0.007..0.007 rows=0 loops=661)

  • Index Cond: ((_fld45482rref = t27._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t27._marked) OR (t27._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
51. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document305_pkey on _document305 t28 (cost=0.11..0.13 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t27._fld27211_rrref)
  • Filter: ((t27._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t27._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x00000131'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
52. 0.003 73.885 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..35,149.29 rows=1 width=205) (actual time=73.885..73.885 rows=0 loops=1)

53. 4.546 73.882 ↓ 0.0 0 1

Nested Loop (cost=0.45..35,149.14 rows=1 width=152) (actual time=73.882..73.882 rows=0 loops=1)

54. 25.824 25.824 ↑ 1.1 6,216 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t30 (cost=0.22..6,685.23 rows=6,831 width=58) (actual time=0.058..25.824 rows=6,216 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x00005734'::bytea))
55. 43.512 43.512 ↓ 0.0 0 6,216

Index Scan using _inforg45481_bydims_rt on _inforg45481 t29 (cost=0.22..4.16 rows=1 width=114) (actual time=0.007..0.007 rows=0 loops=6,216)

  • Index Cond: ((_fld45482rref = t30._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t30._marked) OR (t30._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
56. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document22324_pkey on _document22324 t31 (cost=0.11..0.15 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t30._fld27211_rrref)
  • Filter: ((t30._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t30._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x00005734'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
57. 0.004 0.303 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.45..10,617.20 rows=1 width=206) (actual time=0.303..0.303 rows=0 loops=1)

  • Join Filter: ((t33._fld27211_type = CASE WHEN (t34._idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t33._fld27211_rtref = CASE WHEN (t34._idrref IS NOT NULL) THEN '\\x00006841'::bytea ELSE NULL::bytea END) AND (t33._fld27211_rrref = t34._idrref))
58. 0.018 0.299 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=0.299..0.299 rows=0 loops=1)

59. 0.101 0.101 ↑ 135.7 15 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t33 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.039..0.101 rows=15 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x00006841'::bytea))
60. 0.180 0.180 ↓ 0.0 0 15

Index Scan using _inforg45481_bydims_rt on _inforg45481 t32 (cost=0.22..4.22 rows=1 width=114) (actual time=0.012..0.012 rows=0 loops=15)

  • Index Cond: ((_fld45482rref = t33._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t33._marked) OR (t33._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
61. 0.000 0.000 ↓ 0.0 0

Seq Scan on _document26689 t34 (cost=0.00..2.42 rows=42 width=20) (never executed)

62. 0.003 1.530 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.51..10,614.33 rows=1 width=206) (actual time=1.530..1.530 rows=0 loops=1)

63. 0.094 1.527 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=1.527..1.527 rows=0 loops=1)

64. 0.529 0.529 ↑ 18.0 113 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t36 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.028..0.529 rows=113 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x00005c68'::bytea))
65. 0.904 0.904 ↓ 0.0 0 113

Index Scan using _inforg45481_bydims_rt on _inforg45481 t35 (cost=0.22..4.22 rows=1 width=114) (actual time=0.008..0.008 rows=0 loops=113)

  • Index Cond: ((_fld45482rref = t36._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t36._marked) OR (t36._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
66. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document23656_pkey on _document23656 t37 (cost=0.06..0.08 rows=1 width=20) (never executed)

  • Index Cond: (_idrref = t36._fld27211_rrref)
  • Filter: ((t36._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t36._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x00005c68'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
67. 0.002 232.590 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..105,524.56 rows=1 width=205) (actual time=232.590..232.590 rows=0 loops=1)

68. 19.935 232.588 ↓ 0.0 0 1

Nested Loop (cost=0.45..105,524.41 rows=1 width=152) (actual time=232.588..232.588 rows=0 loops=1)

69. 83.005 83.005 ↓ 1.0 21,608 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t39 (cost=0.22..20,496.01 rows=21,280 width=58) (actual time=0.046..83.005 rows=21,608 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x00000132'::bytea))
70. 129.648 129.648 ↓ 0.0 0 21,608

Index Scan using _inforg45481_bydims_rt on _inforg45481 t38 (cost=0.22..3.99 rows=1 width=114) (actual time=0.006..0.006 rows=0 loops=21,608)

  • Index Cond: ((_fld45482rref = t39._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t39._marked) OR (t39._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
71. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document306_pkey on _document306 t40 (cost=0.12..0.15 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t39._fld27211_rrref)
  • Filter: ((t39._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t39._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x00000132'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
72. 0.003 267.786 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.62..168,986.63 rows=32 width=206) (actual time=267.786..267.786 rows=0 loops=1)

73. 1.599 267.783 ↓ 0.0 0 1

Nested Loop (cost=0.45..168,979.36 rows=32 width=152) (actual time=267.783..267.783 rows=0 loops=1)

74. 240.809 240.809 ↓ 29.9 5,075 1

Index Scan using _inforg45481_byperiod_tr on _inforg45481 t41 (cost=0.22..168,256.52 rows=170 width=114) (actual time=1.109..240.809 rows=5,075 loops=1)

  • Index Cond: ((_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea))
  • Rows Removed by Filter: 224856
75. 25.375 25.375 ↓ 0.0 0 5,075

Index Scan using _document27198ng_pkey on _document27198 t42 (cost=0.22..4.24 rows=1 width=58) (actual time=0.005..0.005 rows=0 loops=5,075)

  • Index Cond: (_idrref = t41._fld45482rref)
  • Filter: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x00004fba'::bytea) AND ((NOT _marked) OR (_marked AND (t41._fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 1
76. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document20410_pkey on _document20410 t43 (cost=0.17..0.22 rows=1 width=20) (never executed)

  • Index Cond: (_idrref = t42._fld27211_rrref)
  • Filter: ((t42._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t42._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x00004fba'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
77. 0.003 29.476 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.42 rows=1 width=205) (actual time=29.476..29.476 rows=0 loops=1)

78. 1.765 29.473 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=29.473..29.473 rows=0 loops=1)

79. 10.014 10.014 ↓ 1.4 2,949 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t45 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.038..10.014 rows=2,949 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x0000013b'::bytea))
80. 17.694 17.694 ↓ 0.0 0 2,949

Index Scan using _inforg45481_bydims_rt on _inforg45481 t44 (cost=0.22..4.22 rows=1 width=114) (actual time=0.006..0.006 rows=0 loops=2,949)

  • Index Cond: ((_fld45482rref = t45._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t45._marked) OR (t45._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
81. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document315_pkey on _document315 t46 (cost=0.11..0.17 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t45._fld27211_rrref)
  • Filter: ((t45._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t45._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x0000013b'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
82. 0.002 24.684 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.43 rows=1 width=205) (actual time=24.684..24.684 rows=0 loops=1)

83. 2.217 24.682 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=24.682..24.682 rows=0 loops=1)

84. 8.269 8.269 ↓ 1.2 2,366 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t48 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.025..8.269 rows=2,366 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x0000013f'::bytea))
85. 14.196 14.196 ↓ 0.0 0 2,366

Index Scan using _inforg45481_bydims_rt on _inforg45481 t47 (cost=0.22..4.22 rows=1 width=114) (actual time=0.006..0.006 rows=0 loops=2,366)

  • Index Cond: ((_fld45482rref = t48._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t48._marked) OR (t48._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
86. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document319_pkey on _document319 t49 (cost=0.11..0.18 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t48._fld27211_rrref)
  • Filter: ((t48._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t48._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x0000013f'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
87. 0.002 81.337 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..37,614.96 rows=1 width=205) (actual time=81.337..81.337 rows=0 loops=1)

88. 3.261 81.335 ↓ 0.0 0 1

Nested Loop (cost=0.45..37,614.79 rows=1 width=152) (actual time=81.335..81.335 rows=0 loops=1)

89. 27.914 27.914 ↓ 1.1 8,360 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t51 (cost=0.22..7,160.19 rows=7,320 width=58) (actual time=0.027..27.914 rows=8,360 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x00000144'::bytea))
90. 50.160 50.160 ↓ 0.0 0 8,360

Index Scan using _inforg45481_bydims_rt on _inforg45481 t50 (cost=0.22..4.15 rows=1 width=114) (actual time=0.006..0.006 rows=0 loops=8,360)

  • Index Cond: ((_fld45482rref = t51._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t51._marked) OR (t51._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
91. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document324ng_pkey1 on _document324 t52 (cost=0.12..0.16 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t51._fld27211_rrref)
  • Filter: ((t51._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t51._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x00000144'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
92. 0.003 90.813 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..43,391.90 rows=1 width=205) (actual time=90.813..90.813 rows=0 loops=1)

93. 1.597 90.810 ↓ 0.0 0 1

Nested Loop (cost=0.45..43,391.73 rows=1 width=152) (actual time=90.810..90.810 rows=0 loops=1)

94. 29.965 29.965 ↑ 1.0 8,464 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t54 (cost=0.22..8,273.88 rows=8,470 width=58) (actual time=0.056..29.965 rows=8,464 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000059dd'::bytea))
95. 59.248 59.248 ↓ 0.0 0 8,464

Index Scan using _inforg45481_bydims_rt on _inforg45481 t53 (cost=0.22..4.14 rows=1 width=114) (actual time=0.007..0.007 rows=0 loops=8,464)

  • Index Cond: ((_fld45482rref = t54._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t54._marked) OR (t54._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
96. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document23005_pkey on _document23005 t55 (cost=0.12..0.16 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t54._fld27211_rrref)
  • Filter: ((t54._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t54._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000059dd'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
97. 0.039 12.215 ↓ 2.0 2 1

Nested Loop Left Join (cost=0.56..10,614.39 rows=1 width=205) (actual time=9.668..12.215 rows=2 loops=1)

98. 0.541 12.128 ↓ 2.0 2 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=9.585..12.128 rows=2 loops=1)

99. 4.047 4.047 ↑ 1.4 1,508 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t57 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.037..4.047 rows=1,508 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000086a9'::bytea))
100. 7.540 7.540 ↓ 0.0 0 1,508

Index Scan using _inforg45481_bydims_rt on _inforg45481 t56 (cost=0.22..4.22 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=1,508)

  • Index Cond: ((_fld45482rref = t57._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t57._marked) OR (t57._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
101. 0.048 0.048 ↑ 1.0 1 2

Index Only Scan using _document34473_pkey on _document34473 t58 (cost=0.11..0.14 rows=1 width=19) (actual time=0.024..0.024 rows=1 loops=2)

  • Index Cond: (_idrref = t57._fld27211_rrref)
  • Filter: ((t57._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t57._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000086a9'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
102. 0.018 12.726 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.56..10,614.39 rows=1 width=205) (actual time=11.113..12.726 rows=1 loops=1)

103. 0.097 12.667 ↑ 1.0 1 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=11.054..12.667 rows=1 loops=1)

104. 4.120 4.120 ↑ 1.2 1,690 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t60 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.035..4.120 rows=1,690 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000086aa'::bytea))
105. 8.450 8.450 ↓ 0.0 0 1,690

Index Scan using _inforg45481_bydims_rt on _inforg45481 t59 (cost=0.22..4.22 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=1,690)

  • Index Cond: ((_fld45482rref = t60._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t60._marked) OR (t60._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
106. 0.041 0.041 ↑ 1.0 1 1

Index Only Scan using _document34474ng_pkey on _document34474 t61 (cost=0.11..0.14 rows=1 width=19) (actual time=0.041..0.041 rows=1 loops=1)

  • Index Cond: (_idrref = t60._fld27211_rrref)
  • Filter: ((t60._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t60._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000086aa'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
107. 0.002 8.888 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.39 rows=1 width=205) (actual time=8.888..8.888 rows=0 loops=1)

108. 0.023 8.886 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=8.886..8.886 rows=0 loops=1)

109. 3.283 3.283 ↑ 1.8 1,116 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t63 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.034..3.283 rows=1,116 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x0000014c'::bytea))
110. 5.580 5.580 ↓ 0.0 0 1,116

Index Scan using _inforg45481_bydims_rt on _inforg45481 t62 (cost=0.22..4.22 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=1,116)

  • Index Cond: ((_fld45482rref = t63._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t63._marked) OR (t63._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
111. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document332_pkey on _document332 t64 (cost=0.11..0.14 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t63._fld27211_rrref)
  • Filter: ((t63._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t63._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x0000014c'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
112. 0.002 59.949 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.47 rows=1 width=205) (actual time=59.949..59.949 rows=0 loops=1)

113. 2.097 59.947 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=59.947..59.947 rows=0 loops=1)

114. 20.560 20.560 ↓ 3.1 6,215 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t66 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.018..20.560 rows=6,215 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x0000015d'::bytea))
115. 37.290 37.290 ↓ 0.0 0 6,215

Index Scan using _inforg45481_bydims_rt on _inforg45481 t65 (cost=0.22..4.22 rows=1 width=114) (actual time=0.006..0.006 rows=0 loops=6,215)

  • Index Cond: ((_fld45482rref = t66._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t66._marked) OR (t66._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
116. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document349_pkey on _document349 t67 (cost=0.12..0.22 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t66._fld27211_rrref)
  • Filter: ((t66._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t66._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x0000015d'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
117. 0.063 275.185 ↓ 32.0 32 1

Nested Loop Left Join (cost=0.61..154,506.58 rows=1 width=205) (actual time=219.537..275.185 rows=32 loops=1)

118. 23.289 274.898 ↓ 32.0 32 1

Nested Loop (cost=0.45..154,506.37 rows=1 width=152) (actual time=219.436..274.898 rows=32 loops=1)

119. 90.594 90.594 ↓ 1.0 32,203 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t69 (cost=0.22..30,431.81 rows=31,963 width=58) (actual time=0.023..90.594 rows=32,203 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x00000166'::bytea))
120. 161.015 161.015 ↓ 0.0 0 32,203

Index Scan using _inforg45481_bydims_rt on _inforg45481 t68 (cost=0.22..3.87 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=32,203)

  • Index Cond: ((_fld45482rref = t69._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t69._marked) OR (t69._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
121. 0.224 0.224 ↑ 1.0 1 32

Index Only Scan using _document358_pkey on _document358 t70 (cost=0.17..0.20 rows=1 width=19) (actual time=0.007..0.007 rows=1 loops=32)

  • Index Cond: (_idrref = t69._fld27211_rrref)
  • Filter: ((t69._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t69._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x00000166'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
122. 0.047 385.779 ↓ 9.0 9 1

Nested Loop Left Join (cost=0.61..168,969.22 rows=1 width=205) (actual time=21.176..385.779 rows=9 loops=1)

123. 19.946 385.453 ↓ 9.0 9 1

Nested Loop (cost=0.45..168,969.01 rows=1 width=152) (actual time=21.093..385.453 rows=9 loops=1)

124. 120.094 120.094 ↑ 1.0 35,059 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t72 (cost=0.22..33,414.16 rows=35,219 width=58) (actual time=0.045..120.094 rows=35,059 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000059dc'::bytea))
125. 245.413 245.413 ↓ 0.0 0 35,059

Index Scan using _inforg45481_bydims_rt on _inforg45481 t71 (cost=0.22..3.84 rows=1 width=114) (actual time=0.007..0.007 rows=0 loops=35,059)

  • Index Cond: ((_fld45482rref = t72._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t72._marked) OR (t72._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
126. 0.279 0.279 ↑ 1.0 1 9

Index Only Scan using _document23004ng_pkey1 on _document23004 t73 (cost=0.17..0.20 rows=1 width=19) (actual time=0.031..0.031 rows=1 loops=9)

  • Index Cond: (_idrref = t72._fld27211_rrref)
  • Filter: ((t72._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t72._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000059dc'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
127. 0.004 0.083 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.45..10,615.38 rows=1 width=206) (actual time=0.083..0.083 rows=0 loops=1)

  • Join Filter: ((t75._fld27211_type = CASE WHEN (t76._idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t75._fld27211_rtref = CASE WHEN (t76._idrref IS NOT NULL) THEN '\\x00000172'::bytea ELSE NULL::bytea END) AND (t75._fld27211_rrref = t76._idrref))
128. 0.015 0.079 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=0.079..0.079 rows=0 loops=1)

129. 0.039 0.039 ↑ 407.2 5 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t75 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.026..0.039 rows=5 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x00000172'::bytea))
130. 0.025 0.025 ↓ 0.0 0 5

Index Scan using _inforg45481_bydims_rt on _inforg45481 t74 (cost=0.22..4.22 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=5)

  • Index Cond: ((_fld45482rref = t75._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t75._marked) OR (t75._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
131. 0.000 0.000 ↓ 0.0 0

Seq Scan on _document370 t76 (cost=0.00..1.06 rows=6 width=20) (never executed)

132. 0.001 24.564 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.40 rows=1 width=205) (actual time=24.564..24.564 rows=0 loops=1)

133. 1.935 24.563 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=24.563..24.563 rows=0 loops=1)

134. 7.708 7.708 ↓ 1.5 2,984 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t78 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.015..7.708 rows=2,984 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x00000173'::bytea))
135. 14.920 14.920 ↓ 0.0 0 2,984

Index Scan using _inforg45481_bydims_rt on _inforg45481 t77 (cost=0.22..4.22 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=2,984)

  • Index Cond: ((_fld45482rref = t78._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t78._marked) OR (t78._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 1
136. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document371_pkey on _document371 t79 (cost=0.11..0.15 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t78._fld27211_rrref)
  • Filter: ((t78._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t78._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x00000173'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
137. 2.008 285.161 ↓ 141.6 2,407 1

Nested Loop Left Join (cost=0.62..168,982.92 rows=17 width=205) (actual time=1.191..285.161 rows=2,407 loops=1)

138. 2.874 275.932 ↓ 141.6 2,407 1

Nested Loop (cost=0.45..168,979.36 rows=17 width=152) (actual time=1.124..275.932 rows=2,407 loops=1)

139. 247.683 247.683 ↓ 29.9 5,075 1

Index Scan using _inforg45481_byperiod_tr on _inforg45481 t80 (cost=0.22..168,256.52 rows=170 width=114) (actual time=1.091..247.683 rows=5,075 loops=1)

  • Index Cond: ((_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea))
  • Rows Removed by Filter: 224856
140. 25.375 25.375 ↓ 0.0 0 5,075

Index Scan using _document27198ng_pkey on _document27198 t81 (cost=0.22..4.24 rows=1 width=58) (actual time=0.005..0.005 rows=0 loops=5,075)

  • Index Cond: (_idrref = t80._fld45482rref)
  • Filter: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000001a5'::bytea) AND ((NOT _marked) OR (_marked AND (t80._fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 1
141. 7.221 7.221 ↑ 1.0 1 2,407

Index Only Scan using _document421ng_pkey on _document421 t82 (cost=0.17..0.20 rows=1 width=19) (actual time=0.003..0.003 rows=1 loops=2,407)

  • Index Cond: (_idrref = t81._fld27211_rrref)
  • Filter: ((t81._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t81._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000001a5'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 5
142. 0.003 185.746 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.61..150,402.48 rows=1 width=205) (actual time=185.746..185.746 rows=0 loops=1)

143. 3.425 185.743 ↓ 0.0 0 1

Nested Loop (cost=0.45..150,402.24 rows=1 width=152) (actual time=185.743..185.743 rows=0 loops=1)

144. 57.050 57.050 ↓ 1.0 31,317 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t84 (cost=0.22..29,589.00 rows=31,048 width=58) (actual time=0.036..57.050 rows=31,317 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000001ab'::bytea))
145. 125.268 125.268 ↓ 0.0 0 31,317

Index Scan using _inforg45481_bydims_rt on _inforg45481 t83 (cost=0.22..3.88 rows=1 width=114) (actual time=0.004..0.004 rows=0 loops=31,317)

  • Index Cond: ((_fld45482rref = t84._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t84._marked) OR (t84._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
146. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document427_pkey on _document427 t85 (cost=0.17..0.23 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t84._fld27211_rrref)
  • Filter: ((t84._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t84._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000001ab'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
147. 0.002 8.711 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.39 rows=1 width=206) (actual time=8.711..8.711 rows=0 loops=1)

148. 0.897 8.709 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=8.709..8.709 rows=0 loops=1)

149. 2.508 2.508 ↑ 1.5 1,326 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t87 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.042..2.508 rows=1,326 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000001ac'::bytea))
150. 5.304 5.304 ↓ 0.0 0 1,326

Index Scan using _inforg45481_bydims_rt on _inforg45481 t86 (cost=0.22..4.22 rows=1 width=114) (actual time=0.004..0.004 rows=0 loops=1,326)

  • Index Cond: ((_fld45482rref = t87._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t87._marked) OR (t87._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
151. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document428_pkey on _document428 t88 (cost=0.11..0.14 rows=1 width=20) (never executed)

  • Index Cond: (_idrref = t87._fld27211_rrref)
  • Filter: ((t87._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t87._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000001ac'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
152. 0.004 267.723 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.61..168,979.77 rows=2 width=205) (actual time=267.723..267.723 rows=0 loops=1)

153. 0.857 267.719 ↓ 0.0 0 1

Nested Loop (cost=0.45..168,979.36 rows=2 width=152) (actual time=267.719..267.719 rows=0 loops=1)

154. 241.487 241.487 ↓ 29.9 5,075 1

Index Scan using _inforg45481_byperiod_tr on _inforg45481 t89 (cost=0.22..168,256.52 rows=170 width=114) (actual time=1.171..241.487 rows=5,075 loops=1)

  • Index Cond: ((_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea))
  • Rows Removed by Filter: 224856
155. 25.375 25.375 ↓ 0.0 0 5,075

Index Scan using _document27198ng_pkey on _document27198 t90 (cost=0.22..4.24 rows=1 width=58) (actual time=0.005..0.005 rows=0 loops=5,075)

  • Index Cond: (_idrref = t89._fld45482rref)
  • Filter: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000001af'::bytea) AND ((NOT _marked) OR (_marked AND (t89._fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 1
156. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document431_pkey on _document431 t91 (cost=0.17..0.20 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t90._fld27211_rrref)
  • Filter: ((t90._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t90._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000001af'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
157. 0.003 21.059 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.40 rows=1 width=206) (actual time=21.059..21.059 rows=0 loops=1)

158. 0.419 21.056 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=21.056..21.056 rows=0 loops=1)

159. 6.749 6.749 ↓ 1.7 3,472 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t93 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.049..6.749 rows=3,472 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000001b5'::bytea))
160. 13.888 13.888 ↓ 0.0 0 3,472

Index Scan using _inforg45481_bydims_rt on _inforg45481 t92 (cost=0.22..4.22 rows=1 width=114) (actual time=0.004..0.004 rows=0 loops=3,472)

  • Index Cond: ((_fld45482rref = t93._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t93._marked) OR (t93._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
161. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document437_pkey on _document437 t94 (cost=0.11..0.15 rows=1 width=20) (never executed)

  • Index Cond: (_idrref = t93._fld27211_rrref)
  • Filter: ((t93._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t93._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000001b5'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
162. 0.002 96.033 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..63,536.67 rows=1 width=206) (actual time=96.033..96.033 rows=0 loops=1)

163. 11.819 96.031 ↓ 0.0 0 1

Nested Loop (cost=0.45..63,536.52 rows=1 width=152) (actual time=96.031..96.031 rows=0 loops=1)

164. 30.644 30.644 ↓ 1.1 13,392 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t96 (cost=0.22..12,188.35 rows=12,534 width=58) (actual time=0.046..30.644 rows=13,392 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x00007145'::bytea))
165. 53.568 53.568 ↓ 0.0 0 13,392

Index Scan using _inforg45481_bydims_rt on _inforg45481 t95 (cost=0.22..4.09 rows=1 width=114) (actual time=0.004..0.004 rows=0 loops=13,392)

  • Index Cond: ((_fld45482rref = t96._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t96._marked) OR (t96._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
166. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document28997_pkey on _document28997 t97 (cost=0.11..0.14 rows=1 width=20) (never executed)

  • Index Cond: (_idrref = t96._fld27211_rrref)
  • Filter: ((t96._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t96._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x00007145'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
167. 0.059 260.253 ↓ 5.2 31 1

Nested Loop Left Join (cost=0.62..168,980.64 rows=6 width=205) (actual time=32.044..260.253 rows=31 loops=1)

168. 0.000 259.884 ↓ 5.2 31 1

Nested Loop (cost=0.45..168,979.36 rows=6 width=152) (actual time=31.970..259.884 rows=31 loops=1)

169. 234.905 234.905 ↓ 29.9 5,075 1

Index Scan using _inforg45481_byperiod_tr on _inforg45481 t98 (cost=0.22..168,256.52 rows=170 width=114) (actual time=1.170..234.905 rows=5,075 loops=1)

  • Index Cond: ((_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea))
  • Rows Removed by Filter: 224856
170. 25.375 25.375 ↓ 0.0 0 5,075

Index Scan using _document27198ng_pkey on _document27198 t99 (cost=0.22..4.24 rows=1 width=58) (actual time=0.005..0.005 rows=0 loops=5,075)

  • Index Cond: (_idrref = t98._fld45482rref)
  • Filter: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x00000175'::bytea) AND ((NOT _marked) OR (_marked AND (t98._fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 1
171. 0.310 0.310 ↑ 1.0 1 31

Index Only Scan using _document373_pkey on _document373 t100 (cost=0.17..0.20 rows=1 width=19) (actual time=0.010..0.010 rows=1 loops=31)

  • Index Cond: (_idrref = t99._fld27211_rrref)
  • Filter: ((t99._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t99._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x00000175'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
172. 0.070 241.666 ↓ 26.0 26 1

Nested Loop Left Join (cost=0.61..168,979.56 rows=1 width=205) (actual time=74.738..241.666 rows=26 loops=1)

173. 3.253 241.440 ↓ 26.0 26 1

Nested Loop (cost=0.45..168,979.36 rows=1 width=152) (actual time=74.619..241.440 rows=26 loops=1)

174. 217.887 217.887 ↓ 29.9 5,075 1

Index Scan using _inforg45481_byperiod_tr on _inforg45481 t101 (cost=0.22..168,256.52 rows=170 width=114) (actual time=1.055..217.887 rows=5,075 loops=1)

  • Index Cond: ((_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea))
  • Rows Removed by Filter: 224856
175. 20.300 20.300 ↓ 0.0 0 5,075

Index Scan using _document27198ng_pkey on _document27198 t102 (cost=0.22..4.24 rows=1 width=58) (actual time=0.004..0.004 rows=0 loops=5,075)

  • Index Cond: (_idrref = t101._fld45482rref)
  • Filter: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x00000179'::bytea) AND ((NOT _marked) OR (_marked AND (t101._fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 1
176. 0.156 0.156 ↑ 1.0 1 26

Index Only Scan using _document377_pkey on _document377 t103 (cost=0.17..0.20 rows=1 width=19) (actual time=0.006..0.006 rows=1 loops=26)

  • Index Cond: (_idrref = t102._fld27211_rrref)
  • Filter: ((t102._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t102._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x00000179'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
177. 0.017 7.146 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.39 rows=1 width=205) (actual time=7.146..7.146 rows=0 loops=1)

178. 0.186 7.129 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=7.129..7.129 rows=0 loops=1)

179. 2.188 2.188 ↑ 2.1 951 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t105 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.056..2.188 rows=951 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x0000017b'::bytea))
180. 4.755 4.755 ↓ 0.0 0 951

Index Scan using _inforg45481_bydims_rt on _inforg45481 t104 (cost=0.22..4.22 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=951)

  • Index Cond: ((_fld45482rref = t105._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t105._marked) OR (t105._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
181. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document379_pkey on _document379 t106 (cost=0.11..0.14 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t105._fld27211_rrref)
  • Filter: ((t105._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t105._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x0000017b'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
182. 0.006 24.032 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.41 rows=1 width=205) (actual time=24.032..24.032 rows=0 loops=1)

183. 2.634 24.026 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=24.026..24.026 rows=0 loops=1)

184. 6.761 6.761 ↓ 2.4 4,877 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t108 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.040..6.761 rows=4,877 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x0000017c'::bytea))
185. 14.631 14.631 ↓ 0.0 0 4,877

Index Scan using _inforg45481_bydims_rt on _inforg45481 t107 (cost=0.22..4.22 rows=1 width=114) (actual time=0.003..0.003 rows=0 loops=4,877)

  • Index Cond: ((_fld45482rref = t108._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t108._marked) OR (t108._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
186. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document380_pkey on _document380 t109 (cost=0.11..0.16 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t108._fld27211_rrref)
  • Filter: ((t108._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t108._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x0000017c'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
187. 0.006 101.822 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..67,702.36 rows=1 width=205) (actual time=101.822..101.822 rows=0 loops=1)

188. 2.930 101.816 ↓ 0.0 0 1

Nested Loop (cost=0.45..67,702.21 rows=1 width=152) (actual time=101.816..101.816 rows=0 loops=1)

189. 34.661 34.661 ↑ 1.0 12,845 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t111 (cost=0.22..13,005.03 rows=13,385 width=58) (actual time=0.048..34.661 rows=12,845 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x0000017e'::bytea))
190. 64.225 64.225 ↓ 0.0 0 12,845

Index Scan using _inforg45481_bydims_rt on _inforg45481 t110 (cost=0.22..4.08 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=12,845)

  • Index Cond: ((_fld45482rref = t111._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t111._marked) OR (t111._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
191. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document382_pkey on _document382 t112 (cost=0.11..0.14 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t111._fld27211_rrref)
  • Filter: ((t111._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t111._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x0000017e'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
192. 0.017 152.559 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..95,874.36 rows=1 width=205) (actual time=152.559..152.559 rows=0 loops=1)

193. 1.778 152.542 ↓ 0.0 0 1

Nested Loop (cost=0.45..95,874.21 rows=1 width=152) (actual time=152.542..152.542 rows=0 loops=1)

194. 51.649 51.649 ↓ 1.0 19,823 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t114 (cost=0.22..18,568.77 rows=19,237 width=58) (actual time=0.059..51.649 rows=19,823 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x0000017f'::bytea))
195. 99.115 99.115 ↓ 0.0 0 19,823

Index Scan using _inforg45481_bydims_rt on _inforg45481 t113 (cost=0.22..4.01 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=19,823)

  • Index Cond: ((_fld45482rref = t114._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t114._marked) OR (t114._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
196. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document383_pkey on _document383 t115 (cost=0.12..0.14 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t114._fld27211_rrref)
  • Filter: ((t114._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t114._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x0000017f'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
197. 0.011 17.707 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.39 rows=1 width=205) (actual time=17.707..17.707 rows=0 loops=1)

198. 0.911 17.696 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=17.696..17.696 rows=0 loops=1)

199. 5.765 5.765 ↓ 1.1 2,204 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t117 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.063..5.765 rows=2,204 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x00000180'::bytea))
200. 11.020 11.020 ↓ 0.0 0 2,204

Index Scan using _inforg45481_bydims_rt on _inforg45481 t116 (cost=0.22..4.22 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=2,204)

  • Index Cond: ((_fld45482rref = t117._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t117._marked) OR (t117._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
201. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document384_pkey on _document384 t118 (cost=0.11..0.14 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t117._fld27211_rrref)
  • Filter: ((t117._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t117._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x00000180'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
202. 0.012 259.512 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.62..168,982.10 rows=13 width=205) (actual time=259.512..259.512 rows=0 loops=1)

203. 0.000 259.500 ↓ 0.0 0 1

Nested Loop (cost=0.45..168,979.36 rows=13 width=152) (actual time=259.500..259.500 rows=0 loops=1)

204. 234.598 234.598 ↓ 29.9 5,075 1

Index Scan using _inforg45481_byperiod_tr on _inforg45481 t119 (cost=0.22..168,256.52 rows=170 width=114) (actual time=1.239..234.598 rows=5,075 loops=1)

  • Index Cond: ((_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea))
  • Rows Removed by Filter: 224856
205. 25.375 25.375 ↓ 0.0 0 5,075

Index Scan using _document27198ng_pkey on _document27198 t120 (cost=0.22..4.24 rows=1 width=58) (actual time=0.005..0.005 rows=0 loops=5,075)

  • Index Cond: (_idrref = t119._fld45482rref)
  • Filter: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x00000181'::bytea) AND ((NOT _marked) OR (_marked AND (t119._fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 1
206. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document385_pkey on _document385 t121 (cost=0.17..0.20 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t120._fld27211_rrref)
  • Filter: ((t120._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t120._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x00000181'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
207. 0.014 35.413 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.40 rows=1 width=205) (actual time=35.413..35.413 rows=0 loops=1)

208. 3.178 35.399 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=35.399..35.399 rows=0 loops=1)

209. 11.141 11.141 ↓ 2.1 4,216 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t123 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.049..11.141 rows=4,216 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x0000b3de'::bytea))
210. 21.080 21.080 ↓ 0.0 0 4,216

Index Scan using _inforg45481_bydims_rt on _inforg45481 t122 (cost=0.22..4.22 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=4,216)

  • Index Cond: ((_fld45482rref = t123._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t123._marked) OR (t123._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
211. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document46046_pkey on _document46046 t124 (cost=0.11..0.15 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t123._fld27211_rrref)
  • Filter: ((t123._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t123._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x0000b3de'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
212. 0.011 99.340 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..63,951.48 rows=1 width=205) (actual time=99.340..99.340 rows=0 loops=1)

213. 6.507 99.329 ↓ 0.0 0 1

Nested Loop (cost=0.45..63,951.33 rows=1 width=152) (actual time=99.329..99.329 rows=0 loops=1)

214. 27.957 27.957 ↓ 1.0 12,973 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t126 (cost=0.22..12,269.48 rows=12,619 width=58) (actual time=0.058..27.957 rows=12,973 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x00006b11'::bytea))
215. 64.865 64.865 ↓ 0.0 0 12,973

Index Scan using _inforg45481_bydims_rt on _inforg45481 t125 (cost=0.22..4.09 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=12,973)

  • Index Cond: ((_fld45482rref = t126._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t126._marked) OR (t126._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
216. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document27409_pkey on _document27409 t127 (cost=0.11..0.14 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t126._fld27211_rrref)
  • Filter: ((t126._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t126._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x00006b11'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
217. 0.098 21.369 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.56..10,614.41 rows=1 width=205) (actual time=18.836..21.369 rows=1 loops=1)

218. 2.443 21.204 ↑ 1.0 1 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=18.671..21.204 rows=1 loops=1)

219. 7.165 7.165 ↓ 1.4 2,899 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t129 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.048..7.165 rows=2,899 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x0000019f'::bytea))
220. 11.596 11.596 ↓ 0.0 0 2,899

Index Scan using _inforg45481_bydims_rt on _inforg45481 t128 (cost=0.22..4.22 rows=1 width=114) (actual time=0.004..0.004 rows=0 loops=2,899)

  • Index Cond: ((_fld45482rref = t129._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t129._marked) OR (t129._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
221. 0.067 0.067 ↑ 1.0 1 1

Index Only Scan using _document415_pkey on _document415 t130 (cost=0.11..0.16 rows=1 width=19) (actual time=0.067..0.067 rows=1 loops=1)

  • Index Cond: (_idrref = t129._fld27211_rrref)
  • Filter: ((t129._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t129._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x0000019f'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
222. 0.011 233.140 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.61..168,979.58 rows=1 width=205) (actual time=233.140..233.140 rows=0 loops=1)

223. 2.305 233.129 ↓ 0.0 0 1

Nested Loop (cost=0.45..168,979.36 rows=1 width=152) (actual time=233.129..233.129 rows=0 loops=1)

224. 210.524 210.524 ↓ 29.9 5,075 1

Index Scan using _inforg45481_byperiod_tr on _inforg45481 t131 (cost=0.22..168,256.52 rows=170 width=114) (actual time=1.124..210.524 rows=5,075 loops=1)

  • Index Cond: ((_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea))
  • Rows Removed by Filter: 224856
225. 20.300 20.300 ↓ 0.0 0 5,075

Index Scan using _document27198ng_pkey on _document27198 t132 (cost=0.22..4.24 rows=1 width=58) (actual time=0.004..0.004 rows=0 loops=5,075)

  • Index Cond: (_idrref = t131._fld45482rref)
  • Filter: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000059db'::bytea) AND ((NOT _marked) OR (_marked AND (t131._fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 1
226. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document23003ng_pkey1 on _document23003 t133 (cost=0.17..0.21 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t132._fld27211_rrref)
  • Filter: ((t132._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t132._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000059db'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
227. 0.018 51.832 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..53,252.98 rows=1 width=205) (actual time=51.832..51.832 rows=0 loops=1)

228. 6.534 51.814 ↓ 0.0 0 1

Nested Loop (cost=0.45..53,252.83 rows=1 width=152) (actual time=51.814..51.814 rows=0 loops=1)

229. 14.476 14.476 ↑ 1.0 10,268 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t135 (cost=0.22..10,184.33 rows=10,449 width=58) (actual time=0.057..14.476 rows=10,268 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000001a0'::bytea))
230. 30.804 30.804 ↓ 0.0 0 10,268

Index Scan using _inforg45481_bydims_rt on _inforg45481 t134 (cost=0.22..4.11 rows=1 width=114) (actual time=0.003..0.003 rows=0 loops=10,268)

  • Index Cond: ((_fld45482rref = t135._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t135._marked) OR (t135._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
231. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document416_pkey on _document416 t136 (cost=0.11..0.14 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t135._fld27211_rrref)
  • Filter: ((t135._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t135._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000001a0'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
232. 0.010 2.672 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.38 rows=1 width=205) (actual time=2.672..2.672 rows=0 loops=1)

233. 0.053 2.662 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=2.662..2.662 rows=0 loops=1)

234. 0.739 0.739 ↑ 5.4 374 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t138 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.049..0.739 rows=374 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000001a1'::bytea))
235. 1.870 1.870 ↓ 0.0 0 374

Index Scan using _inforg45481_bydims_rt on _inforg45481 t137 (cost=0.22..4.22 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=374)

  • Index Cond: ((_fld45482rref = t138._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t138._marked) OR (t138._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
236. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document417_pkey on _document417 t139 (cost=0.11..0.13 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t138._fld27211_rrref)
  • Filter: ((t138._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t138._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000001a1'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
237. 0.052 23.343 ↑ 1.0 1 1

Nested Loop Left Join (cost=0.56..10,614.41 rows=1 width=205) (actual time=21.440..23.343 rows=1 loops=1)

238. 1.504 23.232 ↑ 1.0 1 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=21.329..23.232 rows=1 loops=1)

239. 6.928 6.928 ↓ 1.5 2,960 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t141 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.026..6.928 rows=2,960 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000001a4'::bytea))
240. 14.800 14.800 ↓ 0.0 0 2,960

Index Scan using _inforg45481_bydims_rt on _inforg45481 t140 (cost=0.22..4.22 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=2,960)

  • Index Cond: ((_fld45482rref = t141._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t141._marked) OR (t141._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
241. 0.059 0.059 ↑ 1.0 1 1

Index Only Scan using _document420_pkey on _document420 t142 (cost=0.11..0.16 rows=1 width=19) (actual time=0.059..0.059 rows=1 loops=1)

  • Index Cond: (_idrref = t141._fld27211_rrref)
  • Filter: ((t141._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t141._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000001a4'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
242. 0.010 1.017 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.45..10,623.70 rows=1 width=203) (actual time=1.017..1.017 rows=0 loops=1)

  • Join Filter: ((t144._fld27211_type = CASE WHEN (t145._idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t144._fld27211_rtref = CASE WHEN (t145._idrref IS NOT NULL) THEN '\\x0000d053'::bytea ELSE NULL::bytea END) AND (t144._fld27211_rrref = t145._idrref))
243. 0.094 1.007 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=1.007..1.007 rows=0 loops=1)

244. 0.343 0.343 ↑ 17.9 114 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t144 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.044..0.343 rows=114 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x0000d053'::bytea))
245. 0.570 0.570 ↓ 0.0 0 114

Index Scan using _inforg45481_bydims_rt on _inforg45481 t143 (cost=0.22..4.22 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=114)

  • Index Cond: ((_fld45482rref = t144._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t144._marked) OR (t144._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
246. 0.000 0.000 ↓ 0.0 0

Seq Scan on _document53331 t145 (cost=0.00..8.07 rows=107 width=17) (never executed)

247. 0.006 249.950 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.67..168,986.09 rows=16 width=206) (actual time=249.950..249.950 rows=0 loops=1)

248. 3.867 249.944 ↓ 0.0 0 1

Nested Loop (cost=0.45..168,979.36 rows=16 width=152) (actual time=249.944..249.944 rows=0 loops=1)

249. 225.777 225.777 ↓ 29.9 5,075 1

Index Scan using _inforg45481_byperiod_tr on _inforg45481 t146 (cost=0.22..168,256.52 rows=170 width=114) (actual time=1.232..225.777 rows=5,075 loops=1)

  • Index Cond: ((_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea))
  • Rows Removed by Filter: 224856
250. 20.300 20.300 ↓ 0.0 0 5,075

Index Scan using _document27198ng_pkey on _document27198 t147 (cost=0.22..4.24 rows=1 width=58) (actual time=0.004..0.004 rows=0 loops=5,075)

  • Index Cond: (_idrref = t146._fld45482rref)
  • Filter: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x00005014'::bytea) AND ((NOT _marked) OR (_marked AND (t146._fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 1
251. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document20500ng_pkey on _document20500 t148 (cost=0.22..0.41 rows=1 width=20) (never executed)

  • Index Cond: (_idrref = t147._fld27211_rrref)
  • Filter: ((t147._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t147._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x00005014'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
252. 0.649 261.247 ↓ 260.7 1,564 1

Nested Loop Left Join (cost=0.62..168,980.65 rows=6 width=203) (actual time=1.640..261.247 rows=1,564 loops=1)

253. 0.534 255.906 ↓ 260.7 1,564 1

Nested Loop (cost=0.45..168,979.36 rows=6 width=152) (actual time=1.506..255.906 rows=1,564 loops=1)

254. 229.997 229.997 ↓ 29.9 5,075 1

Index Scan using _inforg45481_byperiod_tr on _inforg45481 t149 (cost=0.22..168,256.52 rows=170 width=114) (actual time=1.004..229.997 rows=5,075 loops=1)

  • Index Cond: ((_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea))
  • Rows Removed by Filter: 224856
255. 25.375 25.375 ↓ 0.0 0 5,075

Index Scan using _document27198ng_pkey on _document27198 t150 (cost=0.22..4.24 rows=1 width=58) (actual time=0.005..0.005 rows=0 loops=5,075)

  • Index Cond: (_idrref = t149._fld45482rref)
  • Filter: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000001be'::bytea) AND ((NOT _marked) OR (_marked AND (t149._fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 1
256. 4.692 4.692 ↑ 1.0 1 1,564

Index Only Scan using _document446ng_pkey1 on _document446 t151 (cost=0.17..0.21 rows=1 width=17) (actual time=0.003..0.003 rows=1 loops=1,564)

  • Index Cond: (_idrref = t150._fld27211_rrref)
  • Filter: ((t150._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t150._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000001be'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
257. 0.011 73.007 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..52,722.98 rows=1 width=205) (actual time=73.007..73.007 rows=0 loops=1)

258. 1.573 72.996 ↓ 0.0 0 1

Nested Loop (cost=0.45..52,722.83 rows=1 width=152) (actual time=72.996..72.996 rows=0 loops=1)

259. 22.233 22.233 ↑ 1.1 9,838 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t153 (cost=0.22..10,081.62 rows=10,342 width=58) (actual time=0.111..22.233 rows=9,838 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000001bf'::bytea))
260. 49.190 49.190 ↓ 0.0 0 9,838

Index Scan using _inforg45481_bydims_rt on _inforg45481 t152 (cost=0.22..4.11 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=9,838)

  • Index Cond: ((_fld45482rref = t153._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t153._marked) OR (t153._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
261. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document447_pkey on _document447 t154 (cost=0.11..0.14 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t153._fld27211_rrref)
  • Filter: ((t153._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t153._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000001bf'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
262. 0.003 6.145 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.46 rows=1 width=206) (actual time=6.145..6.145 rows=0 loops=1)

263. 0.049 6.142 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=6.142..6.142 rows=0 loops=1)

264. 1.805 1.805 ↑ 1.9 1,072 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t156 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.044..1.805 rows=1,072 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000050c2'::bytea))
265. 4.288 4.288 ↓ 0.0 0 1,072

Index Scan using _inforg45481_bydims_rt on _inforg45481 t155 (cost=0.22..4.22 rows=1 width=114) (actual time=0.004..0.004 rows=0 loops=1,072)

  • Index Cond: ((_fld45482rref = t156._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t156._marked) OR (t156._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
266. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document20674_pkey on _document20674 t157 (cost=0.12..0.22 rows=1 width=20) (never executed)

  • Index Cond: (_idrref = t156._fld27211_rrref)
  • Filter: ((t156._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t156._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000050c2'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
267. 0.002 6.857 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.38 rows=1 width=205) (actual time=6.857..6.857 rows=0 loops=1)

268. 0.197 6.855 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=6.855..6.855 rows=0 loops=1)

269. 2.108 2.108 ↑ 3.1 650 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t159 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.035..2.108 rows=650 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000088f3'::bytea))
270. 4.550 4.550 ↓ 0.0 0 650

Index Scan using _inforg45481_bydims_rt on _inforg45481 t158 (cost=0.22..4.22 rows=1 width=114) (actual time=0.007..0.007 rows=0 loops=650)

  • Index Cond: ((_fld45482rref = t159._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t159._marked) OR (t159._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
271. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document35059_pkey on _document35059 t160 (cost=0.11..0.13 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t159._fld27211_rrref)
  • Filter: ((t159._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t159._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000088f3'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
272. 0.002 305.602 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.62..168,981.23 rows=9 width=206) (actual time=305.602..305.602 rows=0 loops=1)

273. 4.555 305.600 ↓ 0.0 0 1

Nested Loop (cost=0.45..168,979.36 rows=9 width=152) (actual time=305.600..305.600 rows=0 loops=1)

274. 275.670 275.670 ↓ 29.9 5,075 1

Index Scan using _inforg45481_byperiod_tr on _inforg45481 t161 (cost=0.22..168,256.52 rows=170 width=114) (actual time=1.264..275.670 rows=5,075 loops=1)

  • Index Cond: ((_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea))
  • Rows Removed by Filter: 224856
275. 25.375 25.375 ↓ 0.0 0 5,075

Index Scan using _document27198ng_pkey on _document27198 t162 (cost=0.22..4.24 rows=1 width=58) (actual time=0.005..0.005 rows=0 loops=5,075)

  • Index Cond: (_idrref = t161._fld45482rref)
  • Filter: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x00006869'::bytea) AND ((NOT _marked) OR (_marked AND (t161._fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 1
276. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document26729ng_pkey on _document26729 t163 (cost=0.17..0.20 rows=1 width=20) (never executed)

  • Index Cond: (_idrref = t162._fld27211_rrref)
  • Filter: ((t162._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t162._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x00006869'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
277. 0.004 46.118 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.42 rows=1 width=205) (actual time=46.118..46.118 rows=0 loops=1)

278. 1.675 46.114 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=46.114..46.114 rows=0 loops=1)

279. 15.814 15.814 ↓ 2.8 5,725 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t165 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.031..15.814 rows=5,725 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000088c2'::bytea))
280. 28.625 28.625 ↓ 0.0 0 5,725

Index Scan using _inforg45481_bydims_rt on _inforg45481 t164 (cost=0.22..4.22 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=5,725)

  • Index Cond: ((_fld45482rref = t165._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t165._marked) OR (t165._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
281. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document35010_pkey on _document35010 t166 (cost=0.11..0.18 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t165._fld27211_rrref)
  • Filter: ((t165._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t165._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000088c2'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
282. 0.029 148.037 ↓ 11.0 11 1

Nested Loop Left Join (cost=0.56..93,348.69 rows=1 width=205) (actual time=120.572..148.037 rows=11 loops=1)

283. 9.117 147.909 ↓ 11.0 11 1

Nested Loop (cost=0.45..93,348.54 rows=1 width=152) (actual time=120.496..147.909 rows=11 loops=1)

284. 48.032 48.032 ↑ 1.0 18,152 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t168 (cost=0.22..18,066.77 rows=18,705 width=58) (actual time=0.030..48.032 rows=18,152 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000001d6'::bytea))
285. 90.760 90.760 ↓ 0.0 0 18,152

Index Scan using _inforg45481_bydims_rt on _inforg45481 t167 (cost=0.22..4.01 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=18,152)

  • Index Cond: ((_fld45482rref = t168._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t168._marked) OR (t168._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
286. 0.099 0.099 ↑ 1.0 1 11

Index Only Scan using _document470_pkey on _document470 t169 (cost=0.12..0.14 rows=1 width=19) (actual time=0.009..0.009 rows=1 loops=11)

  • Index Cond: (_idrref = t168._fld27211_rrref)
  • Filter: ((t168._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t168._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000001d6'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
287. 0.002 11.610 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.39 rows=1 width=205) (actual time=11.610..11.610 rows=0 loops=1)

288. 1.027 11.608 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=11.608..11.608 rows=0 loops=1)

289. 3.791 3.791 ↑ 1.5 1,358 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t171 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.043..3.791 rows=1,358 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000001da'::bytea))
290. 6.790 6.790 ↓ 0.0 0 1,358

Index Scan using _inforg45481_bydims_rt on _inforg45481 t170 (cost=0.22..4.22 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=1,358)

  • Index Cond: ((_fld45482rref = t171._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t171._marked) OR (t171._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
291. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document474_pkey on _document474 t172 (cost=0.11..0.14 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t171._fld27211_rrref)
  • Filter: ((t171._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t171._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000001da'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
292. 0.002 47.046 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.42 rows=1 width=205) (actual time=47.046..47.046 rows=0 loops=1)

293. 6.117 47.044 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=47.044..47.044 rows=0 loops=1)

294. 15.023 15.023 ↓ 3.2 6,476 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t174 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.022..15.023 rows=6,476 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000051b8'::bytea))
295. 25.904 25.904 ↓ 0.0 0 6,476

Index Scan using _inforg45481_bydims_rt on _inforg45481 t173 (cost=0.22..4.22 rows=1 width=114) (actual time=0.004..0.004 rows=0 loops=6,476)

  • Index Cond: ((_fld45482rref = t174._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t174._marked) OR (t174._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
296. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document20920_pkey on _document20920 t175 (cost=0.11..0.17 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t174._fld27211_rrref)
  • Filter: ((t174._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t174._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000051b8'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
297. 0.002 18.475 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..10,614.40 rows=1 width=205) (actual time=18.475..18.475 rows=0 loops=1)

298. 0.182 18.473 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=18.473..18.473 rows=0 loops=1)

299. 5.589 5.589 ↓ 1.0 2,117 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t177 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.029..5.589 rows=2,117 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000001dc'::bytea))
300. 12.702 12.702 ↓ 0.0 0 2,117

Index Scan using _inforg45481_bydims_rt on _inforg45481 t176 (cost=0.22..4.22 rows=1 width=114) (actual time=0.006..0.006 rows=0 loops=2,117)

  • Index Cond: ((_fld45482rref = t177._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t177._marked) OR (t177._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
301. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document476_pkey on _document476 t178 (cost=0.11..0.15 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t177._fld27211_rrref)
  • Filter: ((t177._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t177._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000001dc'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
302. 0.002 5.602 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.62..10,616.00 rows=1 width=203) (actual time=5.602..5.602 rows=0 loops=1)

303. 0.292 5.600 ↓ 0.0 0 1

Nested Loop (cost=0.45..10,614.24 rows=1 width=152) (actual time=5.600..5.600 rows=0 loops=1)

304. 1.552 1.552 ↑ 1.6 1,252 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t180 (cost=0.22..2,005.06 rows=2,036 width=58) (actual time=0.036..1.552 rows=1,252 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000001e0'::bytea))
305. 3.756 3.756 ↓ 0.0 0 1,252

Index Scan using _inforg45481_bydims_rt on _inforg45481 t179 (cost=0.22..4.22 rows=1 width=114) (actual time=0.003..0.003 rows=0 loops=1,252)

  • Index Cond: ((_fld45482rref = t180._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t180._marked) OR (t180._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
306. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document480ng_pkey1 on _document480 t181 (cost=0.17..1.75 rows=1 width=17) (never executed)

  • Index Cond: (_idrref = t180._fld27211_rrref)
  • Filter: ((t180._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t180._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000001e0'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
307. 0.091 304.778 ↑ 1.4 32 1

Nested Loop Left Join (cost=0.62..168,988.61 rows=44 width=205) (actual time=88.975..304.778 rows=32 loops=1)

308. 4.396 304.207 ↑ 1.4 32 1

Nested Loop (cost=0.45..168,979.36 rows=44 width=152) (actual time=88.879..304.207 rows=32 loops=1)

309. 274.436 274.436 ↓ 29.9 5,075 1

Index Scan using _inforg45481_byperiod_tr on _inforg45481 t182 (cost=0.22..168,256.52 rows=170 width=114) (actual time=1.182..274.436 rows=5,075 loops=1)

  • Index Cond: ((_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea))
  • Rows Removed by Filter: 224856
310. 25.375 25.375 ↓ 0.0 0 5,075

Index Scan using _document27198ng_pkey on _document27198 t183 (cost=0.22..4.24 rows=1 width=58) (actual time=0.005..0.005 rows=0 loops=5,075)

  • Index Cond: (_idrref = t182._fld45482rref)
  • Filter: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000001e3'::bytea) AND ((NOT _marked) OR (_marked AND (t182._fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 1
311. 0.480 0.480 ↑ 1.0 1 32

Index Only Scan using _document483ng_pkey on _document483 t184 (cost=0.17..0.20 rows=1 width=19) (actual time=0.015..0.015 rows=1 loops=32)

  • Index Cond: (_idrref = t183._fld27211_rrref)
  • Filter: ((t183._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t183._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000001e3'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
312. 0.031 218.380 ↓ 3.0 3 1

Nested Loop Left Join (cost=0.61..131,485.85 rows=1 width=205) (actual time=189.687..218.380 rows=3 loops=1)

313. 9.312 218.283 ↓ 3.0 3 1

Nested Loop (cost=0.45..131,485.64 rows=1 width=152) (actual time=189.608..218.283 rows=3 loops=1)

314. 69.731 69.731 ↓ 1.0 27,848 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t186 (cost=0.22..25,730.00 rows=26,877 width=58) (actual time=0.029..69.731 rows=27,848 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x0000b6f7'::bytea))
315. 139.240 139.240 ↓ 0.0 0 27,848

Index Scan using _inforg45481_bydims_rt on _inforg45481 t185 (cost=0.22..3.92 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=27,848)

  • Index Cond: ((_fld45482rref = t186._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t186._marked) OR (t186._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
316. 0.066 0.066 ↑ 1.0 1 3

Index Only Scan using _document46839_pkey on _document46839 t187 (cost=0.17..0.20 rows=1 width=19) (actual time=0.022..0.022 rows=1 loops=3)

  • Index Cond: (_idrref = t186._fld27211_rrref)
  • Filter: ((t186._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t186._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x0000b6f7'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
317. 0.001 92.838 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..68,326.90 rows=1 width=205) (actual time=92.838..92.838 rows=0 loops=1)

318. 0.717 92.837 ↓ 0.0 0 1

Nested Loop (cost=0.45..68,326.75 rows=1 width=152) (actual time=92.837..92.837 rows=0 loops=1)

319. 23.315 23.315 ↓ 1.0 13,761 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t189 (cost=0.22..13,126.94 rows=13,513 width=58) (actual time=0.027..23.315 rows=13,761 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x000059e0'::bytea))
320. 68.805 68.805 ↓ 0.0 0 13,761

Index Scan using _inforg45481_bydims_rt on _inforg45481 t188 (cost=0.22..4.07 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=13,761)

  • Index Cond: ((_fld45482rref = t189._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t189._marked) OR (t189._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
321. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document23008_pkey on _document23008 t190 (cost=0.11..0.14 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t189._fld27211_rrref)
  • Filter: ((t189._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t189._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x000059e0'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
322. 0.003 55.636 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..34,394.92 rows=1 width=205) (actual time=55.636..55.636 rows=0 loops=1)

323. 2.992 55.633 ↓ 0.0 0 1

Nested Loop (cost=0.45..34,394.76 rows=1 width=152) (actual time=55.633..55.633 rows=0 loops=1)

324. 16.706 16.706 ↓ 1.1 7,187 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t192 (cost=0.22..6,540.85 rows=6,682 width=58) (actual time=0.032..16.706 rows=7,187 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x0000cef0'::bytea))
325. 35.935 35.935 ↓ 0.0 0 7,187

Index Scan using _inforg45481_bydims_rt on _inforg45481 t191 (cost=0.22..4.16 rows=1 width=114) (actual time=0.005..0.005 rows=0 loops=7,187)

  • Index Cond: ((_fld45482rref = t192._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t192._marked) OR (t192._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 1
326. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document52976ng_pkey on _document52976 t193 (cost=0.11..0.15 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t192._fld27211_rrref)
  • Filter: ((t192._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t192._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x0000cef0'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
327. 0.002 50.703 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.56..46,791.70 rows=1 width=205) (actual time=50.703..50.703 rows=0 loops=1)

328. 7.416 50.701 ↓ 0.0 0 1

Nested Loop (cost=0.45..46,791.55 rows=1 width=152) (actual time=50.701..50.701 rows=0 loops=1)

329. 14.353 14.353 ↓ 1.1 9,644 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t195 (cost=0.22..8,932.30 rows=9,150 width=58) (actual time=0.023..14.353 rows=9,644 loops=1)

  • Index Cond: ((_fld27211_type = '\\x08'::bytea) AND (_fld27211_rtref = '\\x0000cd0b'::bytea))
330. 28.932 28.932 ↓ 0.0 0 9,644

Index Scan using _inforg45481_bydims_rt on _inforg45481 t194 (cost=0.22..4.13 rows=1 width=114) (actual time=0.003..0.003 rows=0 loops=9,644)

  • Index Cond: ((_fld45482rref = t195._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t195._marked) OR (t195._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
331. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _document52491ng_pkey1 on _document52491 t196 (cost=0.11..0.14 rows=1 width=19) (never executed)

  • Index Cond: (_idrref = t195._fld27211_rrref)
  • Filter: ((t195._fld27211_type = CASE WHEN (_idrref IS NOT NULL) THEN '\\x08'::bytea ELSE NULL::bytea END) AND (t195._fld27211_rtref = CASE WHEN (_idrref IS NOT NULL) THEN '\\x0000cd0b'::bytea ELSE NULL::bytea END))
  • Heap Fetches: 0
332. 0.659 250.573 ↓ 0.0 0 1

Nested Loop (cost=0.45..18.87 rows=1 width=218) (actual time=250.573..250.573 rows=0 loops=1)

333. 100.988 100.988 ↓ 16,547.3 49,642 1

Index Scan using _documen27198_byfield27379_rr on _document27198 t198 (cost=0.22..6.11 rows=3 width=28) (actual time=0.051..100.988 rows=49,642 loops=1)

  • Index Cond: ((_fld27211_type = '\\x01'::bytea) AND (_fld27211_rtref = '\\x00000000'::bytea) AND (_fld27211_rrref = '\\x00000000000000000000000000000000'::bytea))
334. 148.926 148.926 ↓ 0.0 0 49,642

Index Scan using _inforg45481_bydims_rt on _inforg45481 t197 (cost=0.22..4.25 rows=1 width=114) (actual time=0.003..0.003 rows=0 loops=49,642)

  • Index Cond: ((_fld45482rref = t198._idrref) AND (_period >= '2019-01-22 00:00:00'::timestamp without time zone) AND (_period <= '2019-03-18 23:59:59'::timestamp without time zone))
  • Filter: ((_fld45483rref = '\\xba391ec89d1719dc41b512f97dfc04d7'::bytea) AND (_fld45484rref = '\\xae5874e6e2c8933c11e7ae51405d359d'::bytea) AND ((NOT t198._marked) OR (t198._marked AND (_fld45483rref = '\\x817def78422c6c924eb42a7d1b618787'::bytea))))
  • Rows Removed by Filter: 0
335. 50.690 50.690 ↓ 0.0 0 5,069

Index Scan using _document27198ng_pkey on _document27198 t203 (cost=0.22..4.24 rows=1 width=19) (actual time=0.010..0.010 rows=0 loops=5,069)

  • Index Cond: (_idrref = t2._fld45482rref)
  • Filter: ((_date_time >= '2019-01-22 12:00:00'::timestamp without time zone) AND (_date_time < '2019-03-18 12:30:00'::timestamp without time zone) AND (_fld27212rref = '\\x9f5a000423c15db211dbe72eb611ed31'::bytea))
  • Rows Removed by Filter: 1
336. 135,211.866 574,729.056 ↑ 1.0 1 258

Hash Join (cost=566,064.86..626,332.28 rows=1 width=19) (actual time=1,217.725..2,227.632 rows=1 loops=258)

  • Hash Cond: ((t201._fld45482rref = t202._fld45482rref) AND ((max(t201._period)) = t202._period))
337. 432,043.293 439,509.708 ↓ 1.6 4,097,705 258

HashAggregate (cost=566,062.51..592,265.73 rows=2,620,322 width=27) (actual time=38.610..1,703.526 rows=4,097,705 loops=258)

  • Group Key: t201._fld45482rref
338. 7,466.415 7,466.415 ↓ 1.0 4,157,716 1

Seq Scan on _inforg45481 t201 (cost=0.00..557,758.20 rows=4,152,157 width=27) (actual time=0.022..7,466.415 rows=4,157,716 loops=1)

  • Filter: (_fld45483rref = '\\x9b9685c46b67eebb434a73c3872855e6'::bytea)
  • Rows Removed by Filter: 10805485
339. 1.806 7.482 ↑ 1.0 4 258

Hash (cost=2.30..2.30 rows=4 width=27) (actual time=0.029..0.029 rows=4 loops=258)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
340. 5.676 5.676 ↑ 1.0 4 258

Index Only Scan using _inforg45481_bydims_rt on _inforg45481 t202 (cost=0.22..2.30 rows=4 width=27) (actual time=0.020..0.022 rows=4 loops=258)

  • Index Cond: (_fld45482rref = t2._fld45482rref)
  • Heap Fetches: 92
Planning time : 126.823 ms
Execution time : 582,436.366 ms