explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eXKX

Settings
# exclusive inclusive rows x rows loops node
1. 0.043 274,828.916 ↑ 1.0 1,000 1

Limit (cost=1,920,576.43..1,920,586.43 rows=1,000 width=167) (actual time=274,828.085..274,828.916 rows=1,000 loops=1)

2. 0.456 274,828.873 ↑ 10.9 1,000 1

Group (cost=1,920,576.43..1,920,685.33 rows=10,890 width=167) (actual time=274,828.084..274,828.873 rows=1,000 loops=1)

  • Group Key: t21._description, t19._fld54602rref, (COALESCE(t4._fld55072, false)), t1._document1055_idrref, t4._date_time, t4._fld38471rref, t4._fld38477rref, ((t4._fld38491)::mvarchar(1024))
3. 829.744 274,828.417 ↑ 9.1 1,194 1

Sort (cost=1,920,576.43..1,920,587.32 rows=10,890 width=167) (actual time=274,828.082..274,828.417 rows=1,194 loops=1)

  • Sort Key: t21._description, t19._fld54602rref, (COALESCE(t4._fld55072, false)) DESC, t1._document1055_idrref, t4._date_time, t4._fld38471rref, t4._fld38477rref, ((t4._fld38491)::mvarchar(1024))
  • Sort Method: quicksort Memory: 52842kB
4. 276.443 273,998.673 ↓ 15.7 170,579 1

Hash Left Join (cost=71,484.37..1,920,284.34 rows=10,890 width=167) (actual time=64.083..273,998.673 rows=170,579 loops=1)

  • Hash Cond: (t4._fld38471rref = t21._idrref)
5. 318.857 273,703.756 ↓ 15.7 170,579 1

Nested Loop Semi Join (cost=1,122.03..1,849,840.33 rows=10,890 width=98) (actual time=45.589..273,703.756 rows=170,579 loops=1)

  • Join Filter: ((CASE WHEN (alternatives: SubPlan 12 or hashed SubPlan 13) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 14 or hashed SubPlan 15) THEN true ELSE false END) AND (CASE WHEN (SubPlan 16) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 17 or hashed SubPlan 18) THEN true ELSE false END))
6. 178,744.796 271,849.464 ↓ 3.9 170,579 1

Nested Loop Left Join (cost=1,121.12..1,364,712.16 rows=43,562 width=138) (actual time=45.182..271,849.464 rows=170,579 loops=1)

  • Join Filter: ((t4._fld38469rref = t18._fld55477rref) AND (t4._fld54715 = t18._fld55586))
  • Rows Removed by Join Filter: 2271723301
7. 35.446 4,233.009 ↓ 3.9 170,579 1

Nested Loop Left Join (cost=1.41..1,361,990.83 rows=43,562 width=162) (actual time=0.550..4,233.009 rows=170,579 loops=1)

8. 131.352 3,174.089 ↓ 3.9 170,579 1

Nested Loop (cost=1.25..1,353,428.61 rows=43,562 width=142) (actual time=0.539..3,174.089 rows=170,579 loops=1)

9. 26.370 2,410.342 ↓ 4.3 126,479 1

Nested Loop (cost=1.08..1,345,733.68 rows=29,732 width=165) (actual time=0.515..2,410.342 rows=126,479 loops=1)

10. 296.572 1,625.098 ↓ 4.3 126,479 1

Nested Loop Semi Join (cost=0.91..1,337,055.88 rows=29,732 width=102) (actual time=0.505..1,625.098 rows=126,479 loops=1)

  • Join Filter: ((CASE WHEN (alternatives: SubPlan 1 or hashed SubPlan 2) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 3 or hashed SubPlan 4) THEN true ELSE false END) AND (CASE WHEN (SubPlan 5) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 6 or hashed SubPlan 7) THEN true ELSE false END))
  • Rows Removed by Join Filter: 1368
11. 189.529 189.529 ↓ 1.1 127,163 1

Seq Scan on _document1055 t4 (cost=0.00..12,644.23 rows=118,927 width=122) (actual time=0.012..189.529 rows=127,163 loops=1)

  • Filter: ((_fld38471rref <> '\\x80c400155dfadb3211e6aa35161c10bc'::bytea) AND (_fld38471rref <> '\\x80c400155dfadb3211e6aa35161c10bc'::bytea) AND (_fld1998 = '0'::numeric))
  • Rows Removed by Filter: 8855
12. 0.000 0.000 ↑ 1.0 1 127,163

Materialize (cost=0.91..10.84 rows=1 width=19) (actual time=0.000..0.000 rows=1 loops=127,163)

13. 0.012 0.265 ↓ 2.0 2 1

Nested Loop Semi Join (cost=0.91..10.84 rows=1 width=19) (actual time=0.110..0.265 rows=2 loops=1)

14. 0.006 0.057 ↑ 1.0 4 1

Nested Loop (cost=0.39..5.37 rows=4 width=38) (actual time=0.041..0.057 rows=4 loops=1)

15. 0.003 0.039 ↑ 1.0 4 1

Nested Loop (cost=0.33..5.07 rows=4 width=19) (actual time=0.035..0.039 rows=4 loops=1)

16. 0.023 0.023 ↑ 1.0 1 1

Index Only Scan using _reference185_byfieldfld5963 on _reference185 t5 (cost=0.16..2.38 rows=1 width=19) (actual time=0.022..0.023 rows=1 loops=1)

  • Index Cond: (_fld5963 = 'Документ.пр_ЗаданиеНаРаботу'::mvarchar)
  • Heap Fetches: 0
17. 0.013 0.013 ↑ 3.0 4 1

Index Only Scan using _inforg48096_bydims on _inforg48096 t7 (cost=0.16..2.57 rows=12 width=38) (actual time=0.011..0.013 rows=4 loops=1)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld48097rref = t5._idrref))
  • Heap Fetches: 0
18. 0.012 0.012 ↑ 1.0 1 4

Index Only Scan using _reference131hpk on _reference131 t6 (cost=0.06..0.08 rows=1 width=19) (actual time=0.003..0.003 rows=1 loops=4)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_idrref = t7._fld48098rref))
  • Heap Fetches: 1
19. 0.032 0.196 ↓ 0.0 0 4

Hash Join (cost=0.52..1.75 rows=1 width=19) (actual time=0.049..0.049 rows=0 loops=4)

  • Hash Cond: ((t9._fld47547_type = t8._fld4561_type) AND (t9._fld47547_rtref = t8._fld4561_rtref) AND (t9._fld47547_rrref = t8._fld4561_rrref))
20. 0.028 0.028 ↑ 1.2 4 4

Index Only Scan using _inforg47546_bydims47550_rr on _inforg47546 t9 (cost=0.11..1.31 rows=5 width=33) (actual time=0.007..0.007 rows=4 loops=4)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld47548_type = '\\x08'::bytea) AND (_fld47548_rtref = '\\x0000015b'::bytea) AND (_fld47548_rrref = '\\x80cd00155dfadb3211e7def0a260b5be'::bytea))
  • Heap Fetches: 0
21. 0.036 0.136 ↓ 4.1 41 4

Hash (cost=0.28..0.28 rows=10 width=49) (actual time=0.034..0.034 rows=41 loops=4)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
22. 0.100 0.100 ↓ 4.1 41 4

Index Scan using _reference131_vt4559_intkeyind on _reference131_vt4559 t8 (cost=0.11..0.28 rows=10 width=49) (actual time=0.010..0.025 rows=41 loops=4)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_reference131_idrref = t7._fld48098rref))
23.          

SubPlan (for Nested Loop Semi Join)

24. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg43964_bydims_rr on _inforg43964 t10 (cost=0.11..2.33 rows=1 width=0) (never executed)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43965rref = t6._idrref) AND (_fld43966_type = '\\x08'::bytea) AND (_fld43966_rtref = '\\x00000110'::bytea) AND (_fld43966_rrref = t4._fld75496rref))
  • Heap Fetches: 0
25. 0.070 0.070 ↑ 1.0 91 1

Seq Scan on _inforg43964 t10_1 (cost=0.00..5.74 rows=91 width=38) (actual time=0.012..0.070 rows=91 loops=1)

  • Filter: ((_fld1998 = '0'::numeric) AND (_fld43966_type = '\\x08'::bytea) AND (_fld43966_rtref = '\\x00000110'::bytea))
  • Rows Removed by Filter: 120
26. 0.000 0.000 ↓ 0.0 0

Index Scan using _inforg43971_bydims_rr on _inforg43971 t11 (cost=0.11..2.33 rows=1 width=0) (never executed)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43972rref = t6._idrref) AND (_fld43973_type = '\\x08'::bytea) AND (_fld43973_rtref = '\\x00000110'::bytea))
  • Filter: (NOT _fld43974)
27. 0.126 0.126 ↓ 7.4 89 1

Index Only Scan using _inforg43971_byresource43980_lrr on _inforg43971 t11_1 (cost=0.11..10.67 rows=12 width=19) (actual time=0.030..0.126 rows=89 loops=1)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43974 = false) AND (_fld43973_type = '\\x08'::bytea) AND (_fld43973_rtref = '\\x00000110'::bytea))
  • Filter: (NOT _fld43974)
  • Heap Fetches: 80
28. 126.525 1,138.725 ↑ 1.0 1 126,525

Nested Loop (cost=0.27..4.13 rows=1 width=0) (actual time=0.009..0.009 rows=1 loops=126,525)

  • Join Filter: ((t12._fld43966_type = t13._fld43027_type) AND (t12._fld43966_rtref = t13._fld43027_rtref) AND (t12._fld43966_rrref = t13._fld43027_rrref))
  • Rows Removed by Join Filter: 0
29. 759.150 759.150 ↑ 1.0 1 126,525

Index Only Scan using _inforg43025_bydims_rrn on _inforg43025 t13 (cost=0.16..1.28 rows=1 width=33) (actual time=0.006..0.006 rows=1 loops=126,525)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43026_type = '\\x08'::bytea) AND (_fld43026_rtref = '\\x00000134'::bytea) AND (_fld43026_rrref = t4._fld38471rref))
  • Heap Fetches: 0
30. 253.050 253.050 ↑ 2.0 1 126,525

Index Only Scan using _inforg43964_bydims_rr on _inforg43964 t12 (cost=0.11..2.82 rows=2 width=30) (actual time=0.002..0.002 rows=1 loops=126,525)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43965rref = t6._idrref))
  • Heap Fetches: 957
31. 0.000 0.000 ↓ 0.0 0

Index Scan using _inforg43971_bydims_rr on _inforg43971 t14 (cost=0.11..2.33 rows=1 width=0) (never executed)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43972rref = t6._idrref) AND (_fld43973_type = '\\x08'::bytea) AND (_fld43973_rtref = '\\x00000134'::bytea))
  • Filter: (NOT _fld43974)
32. 0.076 0.076 ↓ 1.9 23 1

Index Only Scan using _inforg43971_byresource43980_lrr on _inforg43971 t14_1 (cost=0.11..10.67 rows=12 width=19) (actual time=0.019..0.076 rows=23 loops=1)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43974 = false) AND (_fld43973_type = '\\x08'::bytea) AND (_fld43973_rtref = '\\x00000134'::bytea))
  • Filter: (NOT _fld43974)
  • Heap Fetches: 19
33. 758.874 758.874 ↑ 1.0 1 126,479

Index Scan using _document1055hpk on _document1055 t2 (cost=0.17..0.29 rows=1 width=63) (actual time=0.006..0.006 rows=1 loops=126,479)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_idrref = t4._idrref))
34. 632.395 632.395 ↑ 3.0 1 126,479

Index Only Scan using _document1055_vt54551_intkeyind on _document1055_vt54551 t1 (cost=0.17..0.23 rows=3 width=23) (actual time=0.005..0.005 rows=1 loops=126,479)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_document1055_idrref = t2._idrref))
  • Heap Fetches: 0
35. 1,023.474 1,023.474 ↑ 1.0 1 170,579

Index Scan using _inforg54600_bydims_r on _inforg54600 t19 (cost=0.17..0.20 rows=1 width=40) (actual time=0.006..0.006 rows=1 loops=170,579)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld54601rref = t1._document1055_idrref))
36. 88,830.373 88,871.659 ↓ 13,318.0 13,318 170,579

Materialize (cost=1,119.71..2,155.02 rows=1 width=24) (actual time=0.000..0.521 rows=13,318 loops=170,579)

37. 9.957 41.286 ↓ 13,318.0 13,318 1

Hash Join (cost=1,119.71..2,155.02 rows=1 width=24) (actual time=25.930..41.286 rows=13,318 loops=1)

  • Hash Cond: ((t18._fld55477rref = t17._fld55477rref) AND (t18._fld55478rref = t17._fld55478rref) AND (t18._fld55586 = t17._fld55586) AND (t18._period = (max(t17._period))))
38. 5.440 5.440 ↑ 1.0 26,203 1

Seq Scan on _inforg55476 t18 (cost=0.00..663.23 rows=26,203 width=52) (actual time=0.005..5.440 rows=26,203 loops=1)

  • Filter: (_fld1998 = '0'::numeric)
39. 3.731 25.889 ↓ 1.3 13,318 1

Hash (cost=974.90..974.90 rows=10,343 width=52) (actual time=25.889..25.889 rows=13,318 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1169kB
40. 15.204 22.158 ↓ 1.3 13,318 1

HashAggregate (cost=768.04..871.47 rows=10,343 width=52) (actual time=18.545..22.158 rows=13,318 loops=1)

  • Group Key: t17._fld55477rref, t17._fld55478rref, t17._fld55586
41. 6.954 6.954 ↑ 1.0 26,203 1

Seq Scan on _inforg55476 t17 (cost=0.00..663.23 rows=26,203 width=52) (actual time=0.003..6.954 rows=26,203 loops=1)

  • Filter: (_fld1998 = '0'::numeric)
42. 0.000 0.000 ↑ 1.0 1 170,579

Materialize (cost=0.91..10.84 rows=1 width=19) (actual time=0.000..0.000 rows=1 loops=170,579)

43. 0.002 0.102 ↑ 1.0 1 1

Nested Loop Semi Join (cost=0.91..10.84 rows=1 width=19) (actual time=0.102..0.102 rows=1 loops=1)

44. 0.002 0.039 ↑ 4.0 1 1

Nested Loop (cost=0.39..5.37 rows=4 width=38) (actual time=0.039..0.039 rows=1 loops=1)

45. 0.004 0.033 ↑ 4.0 1 1

Nested Loop (cost=0.33..5.07 rows=4 width=19) (actual time=0.033..0.033 rows=1 loops=1)

46. 0.020 0.020 ↑ 1.0 1 1

Index Only Scan using _reference185_byfieldfld5963 on _reference185 t29 (cost=0.16..2.38 rows=1 width=19) (actual time=0.020..0.020 rows=1 loops=1)

  • Index Cond: (_fld5963 = 'Документ.пр_ЗаданиеНаРаботу'::mvarchar)
  • Heap Fetches: 0
47. 0.009 0.009 ↑ 12.0 1 1

Index Only Scan using _inforg48096_bydims on _inforg48096 t31 (cost=0.16..2.57 rows=12 width=38) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld48097rref = t29._idrref))
  • Heap Fetches: 0
48. 0.004 0.004 ↑ 1.0 1 1

Index Only Scan using _reference131hpk on _reference131 t30 (cost=0.06..0.08 rows=1 width=19) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_idrref = t31._fld48098rref))
  • Heap Fetches: 0
49. 0.013 0.061 ↑ 1.0 1 1

Hash Join (cost=0.52..1.75 rows=1 width=19) (actual time=0.061..0.061 rows=1 loops=1)

  • Hash Cond: ((t33._fld47547_type = t32._fld4561_type) AND (t33._fld47547_rtref = t32._fld4561_rtref) AND (t33._fld47547_rrref = t32._fld4561_rrref))
50. 0.011 0.011 ↑ 2.5 2 1

Index Only Scan using _inforg47546_bydims47550_rr on _inforg47546 t33 (cost=0.11..1.31 rows=5 width=33) (actual time=0.011..0.011 rows=2 loops=1)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld47548_type = '\\x08'::bytea) AND (_fld47548_rtref = '\\x0000015b'::bytea) AND (_fld47548_rrref = '\\x80cd00155dfadb3211e7def0a260b5be'::bytea))
  • Heap Fetches: 0
51. 0.009 0.037 ↓ 4.6 46 1

Hash (cost=0.28..0.28 rows=10 width=49) (actual time=0.037..0.037 rows=46 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
52. 0.028 0.028 ↓ 4.6 46 1

Index Scan using _reference131_vt4559_intkeyind on _reference131_vt4559 t32 (cost=0.11..0.28 rows=10 width=49) (actual time=0.012..0.028 rows=46 loops=1)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_reference131_idrref = t31._fld48098rref))
53.          

SubPlan (for Nested Loop Semi Join)

54. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg43964_bydims_rr on _inforg43964 t34 (cost=0.11..2.33 rows=1 width=0) (never executed)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43965rref = t30._idrref) AND (_fld43966_type = '\\x08'::bytea) AND (_fld43966_rtref = '\\x00000110'::bytea) AND (_fld43966_rrref = t2._fld75496rref))
  • Heap Fetches: 0
55. 0.062 0.062 ↑ 1.0 91 1

Seq Scan on _inforg43964 t34_1 (cost=0.00..5.74 rows=91 width=38) (actual time=0.010..0.062 rows=91 loops=1)

  • Filter: ((_fld1998 = '0'::numeric) AND (_fld43966_type = '\\x08'::bytea) AND (_fld43966_rtref = '\\x00000110'::bytea))
  • Rows Removed by Filter: 120
56. 0.000 0.000 ↓ 0.0 0

Index Scan using _inforg43971_bydims_rr on _inforg43971 t35 (cost=0.11..2.33 rows=1 width=0) (never executed)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43972rref = t30._idrref) AND (_fld43973_type = '\\x08'::bytea) AND (_fld43973_rtref = '\\x00000110'::bytea))
  • Filter: (NOT _fld43974)
57. 0.104 0.104 ↓ 7.4 89 1

Index Only Scan using _inforg43971_byresource43980_lrr on _inforg43971 t35_1 (cost=0.11..10.67 rows=12 width=19) (actual time=0.024..0.104 rows=89 loops=1)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43974 = false) AND (_fld43973_type = '\\x08'::bytea) AND (_fld43973_rtref = '\\x00000110'::bytea))
  • Filter: (NOT _fld43974)
  • Heap Fetches: 80
58. 341.158 1,535.211 ↑ 1.0 1 170,579

Nested Loop (cost=0.27..4.13 rows=1 width=0) (actual time=0.009..0.009 rows=1 loops=170,579)

  • Join Filter: ((t36._fld43966_type = t37._fld43027_type) AND (t36._fld43966_rtref = t37._fld43027_rtref) AND (t36._fld43966_rrref = t37._fld43027_rrref))
  • Rows Removed by Join Filter: 0
59. 852.895 852.895 ↑ 1.0 1 170,579

Index Only Scan using _inforg43025_bydims_rrn on _inforg43025 t37 (cost=0.16..1.28 rows=1 width=33) (actual time=0.005..0.005 rows=1 loops=170,579)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43026_type = '\\x08'::bytea) AND (_fld43026_rtref = '\\x00000134'::bytea) AND (_fld43026_rrref = t2._fld38471rref))
  • Heap Fetches: 0
60. 341.158 341.158 ↑ 2.0 1 170,579

Index Only Scan using _inforg43964_bydims_rr on _inforg43964 t36 (cost=0.11..2.82 rows=2 width=30) (actual time=0.002..0.002 rows=1 loops=170,579)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43965rref = t30._idrref))
  • Heap Fetches: 1280
61. 0.000 0.000 ↓ 0.0 0

Index Scan using _inforg43971_bydims_rr on _inforg43971 t38 (cost=0.11..2.33 rows=1 width=0) (never executed)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43972rref = t30._idrref) AND (_fld43973_type = '\\x08'::bytea) AND (_fld43973_rtref = '\\x00000134'::bytea))
  • Filter: (NOT _fld43974)
62. 0.058 0.058 ↓ 1.9 23 1

Index Only Scan using _inforg43971_byresource43980_lrr on _inforg43971 t38_1 (cost=0.11..10.67 rows=12 width=19) (actual time=0.015..0.058 rows=23 loops=1)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43974 = false) AND (_fld43973_type = '\\x08'::bytea) AND (_fld43973_rtref = '\\x00000134'::bytea))
  • Filter: (NOT _fld43974)
  • Heap Fetches: 19
63. 2.537 18.474 ↓ 2.0 14,657 1

Hash (cost=70,281.07..70,281.07 rows=7,388 width=66) (actual time=18.474..18.474 rows=14,657 loops=1)

  • Buckets: 16384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 1489kB
64. 8.224 15.937 ↓ 2.0 14,657 1

Nested Loop Semi Join (cost=0.91..70,281.07 rows=7,388 width=66) (actual time=0.192..15.937 rows=14,657 loops=1)

  • Join Filter: (CASE WHEN (alternatives: SubPlan 8 or hashed SubPlan 9) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 10 or hashed SubPlan 11) THEN true ELSE false END)
  • Rows Removed by Join Filter: 238
65. 7.627 7.627 ↑ 1.0 14,776 1

Seq Scan on _reference308 t21 (cost=0.00..1,251.54 rows=14,776 width=86) (actual time=0.005..7.627 rows=14,776 loops=1)

  • Filter: (_fld1998 = '0'::numeric)
66. 0.000 0.000 ↑ 1.0 1 14,776

Materialize (cost=0.91..10.84 rows=1 width=19) (actual time=0.000..0.000 rows=1 loops=14,776)

67. 0.018 0.459 ↓ 2.0 2 1

Nested Loop Semi Join (cost=0.91..10.84 rows=1 width=19) (actual time=0.079..0.459 rows=2 loops=1)

68. 0.000 0.061 ↓ 4.8 19 1

Nested Loop (cost=0.39..5.37 rows=4 width=38) (actual time=0.022..0.061 rows=19 loops=1)

69. 0.004 0.025 ↓ 4.8 19 1

Nested Loop (cost=0.33..5.07 rows=4 width=19) (actual time=0.018..0.025 rows=19 loops=1)

70. 0.009 0.009 ↑ 1.0 1 1

Index Only Scan using _reference185_byfieldfld5963 on _reference185 t22 (cost=0.16..2.38 rows=1 width=19) (actual time=0.009..0.009 rows=1 loops=1)

  • Index Cond: (_fld5963 = 'Справочник.Партнеры'::mvarchar)
  • Heap Fetches: 0
71. 0.012 0.012 ↓ 1.6 19 1

Index Only Scan using _inforg48096_bydims on _inforg48096 t24 (cost=0.16..2.57 rows=12 width=38) (actual time=0.008..0.012 rows=19 loops=1)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld48097rref = t22._idrref))
  • Heap Fetches: 0
72. 0.038 0.038 ↑ 1.0 1 19

Index Only Scan using _reference131hpk on _reference131 t23 (cost=0.06..0.08 rows=1 width=19) (actual time=0.002..0.002 rows=1 loops=19)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_idrref = t24._fld48098rref))
  • Heap Fetches: 6
73. 0.057 0.380 ↓ 0.0 0 19

Hash Join (cost=0.52..1.75 rows=1 width=19) (actual time=0.020..0.020 rows=0 loops=19)

  • Hash Cond: ((t26._fld47547_type = t25._fld4561_type) AND (t26._fld47547_rtref = t25._fld4561_rtref) AND (t26._fld47547_rrref = t25._fld4561_rrref))
74. 0.076 0.076 ↑ 1.0 5 19

Index Only Scan using _inforg47546_bydims47550_rr on _inforg47546 t26 (cost=0.11..1.31 rows=5 width=33) (actual time=0.003..0.004 rows=5 loops=19)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld47548_type = '\\x08'::bytea) AND (_fld47548_rtref = '\\x0000015b'::bytea) AND (_fld47548_rrref = '\\x80cd00155dfadb3211e7def0a260b5be'::bytea))
  • Heap Fetches: 0
75. 0.057 0.247 ↓ 2.1 21 19

Hash (cost=0.28..0.28 rows=10 width=49) (actual time=0.013..0.013 rows=21 loops=19)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
76. 0.190 0.190 ↓ 2.1 21 19

Index Scan using _reference131_vt4559_intkeyind on _reference131_vt4559 t25 (cost=0.11..0.28 rows=10 width=49) (actual time=0.004..0.010 rows=21 loops=19)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_reference131_idrref = t24._fld48098rref))
77.          

SubPlan (for Nested Loop Semi Join)

78. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg43964_bydims_rr on _inforg43964 t27 (cost=0.11..2.33 rows=1 width=0) (never executed)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43965rref = t23._idrref) AND (_fld43966_type = '\\x08'::bytea) AND (_fld43966_rtref = '\\x00000085'::bytea) AND (_fld43966_rrref = t21._fld8913rref))
  • Heap Fetches: 0
79. 0.026 0.026 ↑ 1.0 48 1

Index Only Scan using _inforg43964_bydims43968_rr on _inforg43964 t27_1 (cost=0.11..4.75 rows=48 width=38) (actual time=0.014..0.026 rows=48 loops=1)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43966_type = '\\x08'::bytea) AND (_fld43966_rtref = '\\x00000085'::bytea))
  • Heap Fetches: 45
80. 0.000 0.000 ↓ 0.0 0

Index Scan using _inforg43971_bydims_rr on _inforg43971 t28 (cost=0.11..2.33 rows=1 width=0) (never executed)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43972rref = t23._idrref) AND (_fld43973_type = '\\x08'::bytea) AND (_fld43973_rtref = '\\x00000134'::bytea))
  • Filter: (NOT _fld43974)
81. 0.060 0.060 ↓ 1.9 23 1

Index Only Scan using _inforg43971_byresource43980_lrr on _inforg43971 t28_1 (cost=0.11..10.67 rows=12 width=19) (actual time=0.015..0.060 rows=23 loops=1)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43974 = false) AND (_fld43973_type = '\\x08'::bytea) AND (_fld43973_rtref = '\\x00000134'::bytea))
  • Filter: (NOT _fld43974)
  • Heap Fetches: 19