explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eES9

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 216.636 ↓ 1.1 8 1

Limit (cost=307,722.37..313,045.67 rows=7 width=152) (actual time=176.228..216.636 rows=8 loops=1)

2. 2.539 216.630 ↓ 1.1 8 1

Nested Loop Left Join (cost=307,722.37..313,045.67 rows=7 width=152) (actual time=176.226..216.630 rows=8 loops=1)

  • Join Filter: (t1._idrref = t2.q_001_f_000rref)
  • Rows Removed by Join Filter: 29224
3. 0.137 37.987 ↓ 1.1 8 1

Nested Loop Semi Join (cost=1.08..3,971.21 rows=7 width=99) (actual time=0.736..37.987 rows=8 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))
4. 37.235 37.235 ↑ 3.4 8 1

Index Scan Backward using _document1054_bydocdate_trl on _document1054 t1 (cost=0.17..3,659.69 rows=27 width=119) (actual time=0.118..37.235 rows=8 loops=1)

  • Index Cond: (_fld1998 = '0'::numeric)
  • Filter: ((_fld38446rref = ANY ('{"\\\\xaf9b0ad4e839414e4267d9e15f2e66f6","\\\\xa4cf3375a3ee3b1140d0ba06fccda97a"}'::bytea[])) AND (_fld54539rref = '\\x80cd00155dfadb3211e7def0a260b5be'::bytea))
  • Rows Removed by Filter: 35032
5. 0.008 0.136 ↑ 1.0 1 8

Materialize (cost=0.91..10.84 rows=1 width=19) (actual time=0.017..0.017 rows=1 loops=8)

6. 0.003 0.128 ↑ 1.0 1 1

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

7. 0.002 0.043 ↑ 4.0 1 1

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

8. 0.002 0.035 ↑ 4.0 1 1

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

9. 0.021 0.021 ↑ 1.0 1 1

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

  • Index Cond: (_fld5963 = 'Документ.пр_ЗаявкаНаВыполнениеРабот'::mvarchar)
  • Heap Fetches: 0
10. 0.012 0.012 ↑ 12.0 1 1

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

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld48097rref = t16._idrref))
  • Heap Fetches: 0
11. 0.006 0.006 ↑ 1.0 1 1

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

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_idrref = t18._fld48098rref))
  • Heap Fetches: 0
12. 0.012 0.082 ↑ 1.0 1 1

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

  • Hash Cond: ((t20._fld47547_type = t19._fld4561_type) AND (t20._fld47547_rtref = t19._fld4561_rtref) AND (t20._fld47547_rrref = t19._fld4561_rrref))
13. 0.014 0.014 ↑ 2.5 2 1

Index Only Scan using _inforg47546_bydims47550_rr on _inforg47546 t20 (cost=0.11..1.31 rows=5 width=33) (actual time=0.013..0.014 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
14. 0.016 0.056 ↓ 4.6 46 1

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

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
15. 0.040 0.040 ↓ 4.6 46 1

Index Scan using _reference131_vt4559_intkeyind on _reference131_vt4559 t19 (cost=0.11..0.28 rows=10 width=49) (actual time=0.016..0.040 rows=46 loops=1)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_reference131_idrref = t18._fld48098rref))
16.          

SubPlan (for Nested Loop Semi Join)

17. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43965rref = t17._idrref) AND (_fld43966_type = '\\x08'::bytea) AND (_fld43966_rtref = '\\x00000110'::bytea) AND (_fld43966_rrref = t1._fld38445rref))
  • Heap Fetches: 0
18. 0.101 0.101 ↑ 1.0 91 1

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

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

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

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

Index Only Scan using _inforg43971_byresource43980_lrr on _inforg43971 t22_1 (cost=0.11..10.67 rows=12 width=19) (actual time=0.034..0.159 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
21. 0.024 0.120 ↑ 1.0 1 8

Nested Loop (cost=0.27..4.13 rows=1 width=0) (actual time=0.015..0.015 rows=1 loops=8)

  • Join Filter: ((t23._fld43966_type = t24._fld43027_type) AND (t23._fld43966_rtref = t24._fld43027_rtref) AND (t23._fld43966_rrref = t24._fld43027_rrref))
22. 0.064 0.064 ↑ 1.0 1 8

Index Only Scan using _inforg43025_bydims_rrn on _inforg43025 t24 (cost=0.16..1.28 rows=1 width=33) (actual time=0.008..0.008 rows=1 loops=8)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43026_type = '\\x08'::bytea) AND (_fld43026_rtref = '\\x00000134'::bytea) AND (_fld43026_rrref = t1._fld38434rref))
  • Heap Fetches: 0
23. 0.032 0.032 ↑ 2.0 1 8

Index Only Scan using _inforg43964_bydims_rr on _inforg43964 t23 (cost=0.11..2.82 rows=2 width=30) (actual time=0.004..0.004 rows=1 loops=8)

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

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

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

Index Only Scan using _inforg43971_byresource43980_lrr on _inforg43971 t25_1 (cost=0.11..10.67 rows=12 width=19) (actual time=0.025..0.099 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
26. 1.502 176.104 ↑ 1.8 3,653 8

Materialize (cost=307,721.29..308,531.88 rows=6,537 width=52) (actual time=21.190..22.013 rows=3,653 loops=8)

27. 0.282 174.602 ↑ 1.8 3,653 1

Subquery Scan on t2 (cost=307,721.29..308,518.81 rows=6,537 width=52) (actual time=169.509..174.602 rows=3,653 loops=1)

28. 4.493 174.320 ↑ 1.8 3,653 1

GroupAggregate (cost=307,721.29..308,453.44 rows=6,537 width=52) (actual time=169.508..174.320 rows=3,653 loops=1)

  • Group Key: t3._document1054_idrref
29. 2.033 169.827 ↑ 1.8 3,672 1

Sort (cost=307,721.29..307,727.83 rows=6,537 width=40) (actual time=169.478..169.827 rows=3,672 loops=1)

  • Sort Key: t3._document1054_idrref
  • Sort Method: quicksort Memory: 383kB
30. 5.666 167.794 ↑ 1.8 3,672 1

Nested Loop Semi Join (cost=14,428.39..307,555.59 rows=6,537 width=40) (actual time=121.067..167.794 rows=3,672 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) AND (CASE WHEN (SubPlan 12) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 13 or hashed SubPlan 14) THEN true ELSE false END))
  • Rows Removed by Join Filter: 6
31. 2.122 139.826 ↑ 7.1 3,675 1

Hash Join (cost=14,427.48..16,342.94 rows=26,149 width=80) (actual time=120.632..139.826 rows=3,675 loops=1)

  • Hash Cond: (t3._document1054_idrref = t4._idrref)
32. 8.884 105.602 ↑ 7.1 3,675 1

Hash Join (cost=11,024.60..12,651.13 rows=26,149 width=43) (actual time=88.454..105.602 rows=3,675 loops=1)

  • Hash Cond: (t3._fld54540rref = t5._idrref)
33. 8.489 8.489 ↑ 1.0 38,210 1

Seq Scan on _document1054_vt38457 t3 (cost=0.00..1,204.31 rows=38,210 width=43) (actual time=0.011..8.489 rows=38,210 loops=1)

  • Filter: (_fld1998 = '0'::numeric)
34. 15.835 88.229 ↓ 1.0 77,351 1

Hash (cost=10,177.27..10,177.27 rows=77,030 width=20) (actual time=88.229..88.229 rows=77,351 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 4726kB
35. 72.394 72.394 ↓ 1.0 77,351 1

Seq Scan on _reference54431 t5 (cost=0.00..10,177.27 rows=77,030 width=20) (actual time=0.011..72.394 rows=77,351 loops=1)

  • Filter: ((_fld1998 = '0'::numeric) AND ((_fld54451rref = '\\x80c400155dfadb3211e6d22bd9580001'::bytea) OR (_fld54451rref = '\\x80c200155dfadb3111e6d322727dae16'::bytea)))
  • Rows Removed by Filter: 35208
36. 8.016 32.102 ↑ 1.0 35,040 1

Hash (cost=3,017.44..3,017.44 rows=35,040 width=63) (actual time=32.102..32.102 rows=35,040 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 3455kB
37. 24.086 24.086 ↑ 1.0 35,040 1

Seq Scan on _document1054 t4 (cost=0.00..3,017.44 rows=35,040 width=63) (actual time=0.008..24.086 rows=35,040 loops=1)

  • Filter: (_fld1998 = '0'::numeric)
38. 0.000 0.000 ↑ 1.0 1 3,675

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

39. 0.011 0.272 ↓ 2.0 2 1

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

40. 0.006 0.061 ↓ 1.2 5 1

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

41. 0.008 0.040 ↓ 1.2 5 1

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

42. 0.021 0.021 ↑ 1.0 1 1

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

  • Index Cond: (_fld5963 = 'Документ.пр_ЗаявкаНаВыполнениеРабот'::mvarchar)
  • Heap Fetches: 0
43. 0.011 0.011 ↑ 2.4 5 1

Index Only Scan using _inforg48096_bydims on _inforg48096 t8 (cost=0.16..2.57 rows=12 width=38) (actual time=0.010..0.011 rows=5 loops=1)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld48097rref = t6._idrref))
  • Heap Fetches: 0
44. 0.015 0.015 ↑ 1.0 1 5

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

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_idrref = t8._fld48098rref))
  • Heap Fetches: 1
45. 0.040 0.200 ↓ 0.0 0 5

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

  • Hash Cond: ((t10._fld47547_type = t9._fld4561_type) AND (t10._fld47547_rtref = t9._fld4561_rtref) AND (t10._fld47547_rrref = t9._fld4561_rrref))
46. 0.030 0.030 ↑ 1.2 4 5

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

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld47548_type = '\\x08'::bytea) AND (_fld47548_rtref = '\\x0000015b'::bytea) AND (_fld47548_rrref = '\\x80cd00155dfadb3211e7def0a260b5be'::bytea))
  • Heap Fetches: 0
47. 0.030 0.130 ↓ 3.3 33 5

Hash (cost=0.28..0.28 rows=10 width=49) (actual time=0.026..0.026 rows=33 loops=5)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
48. 0.100 0.100 ↓ 3.3 33 5

Index Scan using _reference131_vt4559_intkeyind on _reference131_vt4559 t9 (cost=0.11..0.28 rows=10 width=49) (actual time=0.008..0.020 rows=33 loops=5)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_reference131_idrref = t8._fld48098rref))
49.          

SubPlan (for Nested Loop Semi Join)

50. 0.000 0.000 ↓ 0.0 0

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

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

Seq Scan on _inforg43964 t11_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
52. 0.000 0.000 ↓ 0.0 0

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

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

Index Only Scan using _inforg43971_byresource43980_lrr on _inforg43971 t12_1 (cost=0.11..10.67 rows=12 width=19) (actual time=0.026..0.105 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
54. 3.678 22.068 ↑ 1.0 1 3,678

Nested Loop (cost=0.27..4.13 rows=1 width=0) (actual time=0.006..0.006 rows=1 loops=3,678)

  • Join Filter: ((t13._fld43966_type = t14._fld43027_type) AND (t13._fld43966_rtref = t14._fld43027_rtref) AND (t13._fld43966_rrref = t14._fld43027_rrref))
  • Rows Removed by Join Filter: 0
55. 14.712 14.712 ↑ 1.0 1 3,678

Index Only Scan using _inforg43025_bydims_rrn on _inforg43025 t14 (cost=0.16..1.28 rows=1 width=33) (actual time=0.004..0.004 rows=1 loops=3,678)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43026_type = '\\x08'::bytea) AND (_fld43026_rtref = '\\x00000134'::bytea) AND (_fld43026_rrref = t4._fld38434rref))
  • Heap Fetches: 0
56. 3.678 3.678 ↑ 2.0 1 3,678

Index Only Scan using _inforg43964_bydims_rr on _inforg43964 t13 (cost=0.11..2.82 rows=2 width=30) (actual time=0.001..0.001 rows=1 loops=3,678)

  • Index Cond: ((_fld1998 = '0'::numeric) AND (_fld43965rref = t7._idrref))
  • Heap Fetches: 104
57. 0.000 0.000 ↓ 0.0 0

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

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

Index Only Scan using _inforg43971_byresource43980_lrr on _inforg43971 t15_1 (cost=0.11..10.67 rows=12 width=19) (actual time=0.015..0.059 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