explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ZfLV

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 137,587.498 ↓ 0.0 0 1

Limit (cost=4,953,434.09..4,966,684.72 rows=1 width=416) (actual time=137,587.498..137,587.498 rows=0 loops=1)

  • Buffers: shared hit=923845
2. 0.001 137,587.497 ↓ 0.0 0 1

Nested Loop Semi Join (cost=4,953,434.09..4,966,684.72 rows=1 width=416) (actual time=137,587.497..137,587.497 rows=0 loops=1)

  • Join Filter: ((CASE WHEN (alternatives: SubPlan 1 or hashed SubPlan 2) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 3 or hashed SubPlan 4) THEN true ELSE false END) AND (CASE WHEN (alternatives: SubPlan 8 or hashed SubPlan 9) THEN tr (...)
  • Buffers: shared hit=923845
3. 0.000 137,587.496 ↓ 0.0 0 1

Nested Loop (cost=4,953,429.71..4,966,658.95 rows=1 width=433) (actual time=137,587.496..137,587.496 rows=0 loops=1)

  • Join Filter: (t37._idrref = t59._fld17711rref)
  • Buffers: shared hit=923845
4. 182.335 137,587.496 ↓ 0.0 0 1

Nested Loop (cost=4,953,429.28..4,966,657.60 rows=1 width=316) (actual time=137,587.496..137,587.496 rows=0 loops=1)

  • Join Filter: (t37._idrref = t60._fld20554rref)
  • Rows Removed by Join Filter: 2565536
  • Buffers: shared hit=923845
5. 132.680 136,232.745 ↓ 32.0 32 1

Nested Loop (cost=4,953,429.28..4,958,011.03 rows=1 width=274) (actual time=8,568.261..136,232.745 rows=32 loops=1)

  • Join Filter: (t38._fld20189rref = t40._fld20189rref)
  • Rows Removed by Join Filter: 1133527
  • Buffers: shared hit=819205
6. 31.386 166.738 ↓ 8,523.0 8,523 1

Nested Loop (cost=0.96..586.37 rows=1 width=291) (actual time=0.158..166.738 rows=8,523 loops=1)

  • Buffers: shared hit=50248
7. 41.095 41.095 ↓ 57.5 10,473 1

Index Scan using _document300_bydocdate_trls on _document300 t37 (cost=0.55..135.79 rows=182 width=257) (actual time=0.076..41.095 rows=10,473 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_date_time > '2019-08-31 11:26:46'::timestamp without time zone))
  • Buffers: shared hit=10122
8. 94.257 94.257 ↑ 1.0 1 10,473

Index Scan using _inforg20187_bydims_r on _inforg20187 t38 (cost=0.41..2.47 rows=1 width=34) (actual time=0.008..0.009 rows=1 loops=10,473)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld20188rref = t37._idrref))
  • Buffers: shared hit=40126
9. 118,716.867 135,933.327 ↑ 103.8 133 8,523

GroupAggregate (cost=4,953,428.32..4,957,114.14 rows=13,801 width=18) (actual time=0.101..15.949 rows=133 loops=8,523)

  • Group Key: t40._fld20189rref
  • Filter: min(CASE WHEN ((max(t42.fld15641_)) IS NULL) THEN false WHEN (t58._fld20230 IS NOT NULL) THEN false ELSE true END)
  • Rows Removed by Filter: 14432
  • Buffers: shared hit=768957
10. 16,442.777 17,216.460 ↓ 1.1 14,692 8,523

Sort (cost=4,953,428.32..4,953,463.10 rows=13,913 width=57) (actual time=0.092..2.020 rows=14,692 loops=8,523)

  • Sort Key: t40._fld20189rref
  • Sort Method: quicksort Memory: 1532kB
  • Buffers: shared hit=768957
11. 1.796 773.683 ↓ 1.1 14,692 1

Hash Right Join (cost=4,940,027.08..4,952,470.81 rows=13,913 width=57) (actual time=771.194..773.683 rows=14,692 loops=1)

  • Hash Cond: (t42.fld15638_rrref = t40._fld20188rref)
  • Buffers: shared hit=768954
12. 0.968 764.584 ↑ 34.0 135 1

GroupAggregate (cost=4,939,452.01..4,951,786.63 rows=4,594 width=57) (actual time=763.843..764.584 rows=135 loops=1)

  • Group Key: t42.fld15638_type, t42.fld15638_rtref, t42.fld15638_rrref
  • Filter: min(CASE WHEN ((t42.fld15643balance_ = t42.fld15644balance_) AND (t42.fld15643balance_ > '0'::numeric)) THEN true ELSE false END)
  • Rows Removed by Filter: 180
  • Buffers: shared hit=768784
13. 0.249 763.616 ↑ 73.0 629 1

Sort (cost=4,939,452.01..4,939,566.86 rows=45,939 width=92) (actual time=763.577..763.616 rows=629 loops=1)

  • Sort Key: t42.fld15638_rrref
  • Sort Method: quicksort Memory: 74kB
  • Buffers: shared hit=768781
14. 0.049 763.367 ↑ 73.0 629 1

Subquery Scan on t42 (cost=4,933,428.31..4,935,894.62 rows=45,939 width=92) (actual time=763.006..763.367 rows=629 loops=1)

  • Buffers: shared hit=768781
15. 0.297 763.318 ↑ 73.0 629 1

GroupAggregate (cost=4,933,428.31..4,935,435.23 rows=45,939 width=92) (actual time=763.005..763.318 rows=629 loops=1)

  • Group Key: t43._fld15641, t43._fld15638_type, t43._fld15638_rtref, t43._fld15638_rrref
  • Filter: ((sum(t43._fld15643) <> '0'::numeric) OR (sum(t43._fld15644) <> '0'::numeric))
  • Buffers: shared hit=768781
16. 0.733 763.021 ↑ 76.9 629 1

Sort (cost=4,933,428.31..4,933,549.21 rows=48,362 width=35) (actual time=762.993..763.021 rows=629 loops=1)

  • Sort Key: t43._fld15641, t43._fld15638_rrref
  • Sort Method: quicksort Memory: 74kB
  • Buffers: shared hit=768781
17. 192.507 762.288 ↑ 76.9 629 1

Index Scan using _accumrg15647_bydims_trrrnr on _accumrgt15647 t43 (cost=0.55..4,929,665.36 rows=48,362 width=35) (actual time=3.496..762.288 rows=629 loops=1)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_period = '3999-11-01 00:00:00'::timestamp without time zone) AND ('\\010'::bytea = _fld15638_type) AND ('\\000\\000\\001,'::bytea = (...)
  • Filter: (((_fld15643 <> '0'::numeric) OR (_fld15644 <> '0'::numeric)) AND ((_fld15643 <> '0'::numeric) OR (_fld15644 <> '0'::numeric)) AND (SubPlan 23))
  • Rows Removed by Filter: 166637
  • Buffers: shared hit=768778
18.          

SubPlan (for Index Scan)

19. 8.523 569.781 ↓ 0.0 0 21,103

Nested Loop Semi Join (cost=5.23..32.05 rows=1 width=0) (actual time=0.027..0.027 rows=0 loops=21,103)

  • 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 (...)
  • Buffers: shared hit=641312
20. 42.206 189.927 ↑ 1.0 1 21,103

Nested Loop Left Join (cost=0.84..6.18 rows=1 width=68) (actual time=0.009..0.009 rows=1 loops=21,103)

  • Join Filter: ((t43._fld15638_type = '\\010'::bytea) AND (t43._fld15638_rtref = '\\000\\000\\001,'::bytea))
  • Filter: ((CASE WHEN (CASE WHEN ((t43._fld15638_type = '\\010'::bytea) AND (t43._fld15638_rtref = '\\000\\000\\0012'::bytea)) THEN t44._fld8248rref WHEN ((t43._fld (...)
  • Buffers: shared hit=148130
21. 0.000 42.206 ↑ 1.0 1 21,103

Nested Loop Left Join (cost=0.42..3.07 rows=1 width=34) (actual time=0.002..0.002 rows=1 loops=21,103)

  • Join Filter: ((t43._fld15638_type = '\\010'::bytea) AND (t43._fld15638_rtref = '\\000\\000\\0012'::bytea))
  • Buffers: shared hit=63374
22. 0.000 0.000 ↑ 1.0 1 21,103

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

23. 42.206 42.206 ↓ 0.0 0 21,103

Index Scan using _document306hpk on _document306 t44 (cost=0.42..3.04 rows=1 width=34) (actual time=0.002..0.002 rows=0 loops=21,103)

  • Index Cond: ((_fld717 = '0'::numeric) AND (t43._fld15638_rrref = _idrref))
  • Buffers: shared hit=63374
24. 105.515 105.515 ↑ 1.0 1 21,103

Index Scan using _document300hpk on _document300 t45 (cost=0.43..3.05 rows=1 width=34) (actual time=0.005..0.005 rows=1 loops=21,103)

  • Index Cond: ((_fld717 = '0'::numeric) AND (t43._fld15638_rrref = _idrref))
  • Buffers: shared hit=84756
25. 0.000 358.751 ↓ 0.0 0 21,103

Materialize (cost=4.38..13.16 rows=1 width=17) (actual time=0.017..0.017 rows=0 loops=21,103)

  • Buffers: shared hit=483687
26. 0.000 358.751 ↓ 0.0 0 21,103

Nested Loop (cost=4.38..13.15 rows=1 width=17) (actual time=0.017..0.017 rows=0 loops=21,103)

  • Buffers: shared hit=483687
27. 63.309 211.030 ↑ 1.0 1 21,103

Nested Loop (cost=4.11..8.08 rows=1 width=38) (actual time=0.007..0.010 rows=1 loops=21,103)

  • Buffers: shared hit=292941
  • -> Index Only Scan using _reference105_byfield2798_sr on _reference105 t48 (cost=0.41..1.72 rows=1 width=20) (actual time=0.002..0.002 rows=1 loops= (...)
  • Index Cond: (_fld2789 = 'РегистрНакопления.ЗаказыКлиентов'::mvarchar)
  • Heap Fetches: 0
  • Buffers: shared hit=63313
28. 147.721 147.721 ↑ 1.0 1 21,103

Nested Loop (cost=3.71..6.35 rows=1 width=57) (actual time=0.005..0.007 rows=1 loops=21,103)

  • Buffers: shared hit=229628
  • -> Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t47 (cost=0.42..3.04 rows=1 width=38) (actual time=0.002..0.002 rows=0 lo (...)
29. 0.000 0.000 ↓ 3.0 3 21,103

HashAggregate (cost=3.29..3.30 rows=1 width=19) (actual time=0.000..0.000 rows=3 loops=21,103)

  • Group Key: t49._reference73_idrref
  • Buffers: shared hit=10
  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t49._reference73_idrref) AND (_fld14846rref = t48._idrref))
  • Heap Fetches: 21103
  • Buffers: shared hit=229618
30. 0.096 0.096 ↓ 3.0 3 1

Nested Loop (cost=0.56..3.29 rows=1 width=19) (actual time=0.082..0.096 rows=3 loops=1)

  • Buffers: shared hit=10
  • -> Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t50 (cost=0.28..1.60 rows=1 width=24) (actual time=0.044..0.0 (...)
  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14728_type = '\\010'::bytea) AND (_fld14728_rtref = '\\000\\000\\000\\254'::byt (...)
  • Heap Fetches: 2
  • Buffers: shared hit=4
  • -> Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t49 (cost=0.28..1.65 rows=3 width=49) (actual t (...)
  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld2105_type = t50._fld14727_type) AND (_fld2105_rtref = t50._fld14727_rtref) AND (...)
  • Heap Fetches: 1
  • Buffers: shared hit=6
31. 147.721 147.721 ↓ 0.0 0 21,103

Index Only Scan using _reference73hpk on _reference73 t46 (cost=0.27..5.06 rows=1 width=17) (actual time=0.007..0.007 rows=0 loops=21,103)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t47._fld14847rref))
  • Filter: (CASE WHEN (alternatives: SubPlan 16 or hashed SubPlan 17) THEN true ELSE false END = CASE WHEN (alternatives: SubPlan 18 or hashed SubPlan 19 (...)
  • Rows Removed by Filter: 1
  • Heap Fetches: 21103
  • Buffers: shared hit=190746
  • -> Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t53 (cost=0.41..3.03 rows=1 width=0) (actual time=0.003..0.003 rows=0 loops=2 (...)
  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\340'::bytea) AND (_fld139 (...)
  • Heap Fetches: 0
  • Buffers: shared hit=64126
  • -> Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t54 (cost=0.41..1.74 rows=1 width=0) (actual time=0.002..0.002 rows=1 lo (...)
  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13939rref = t46._idrref) AND (_fld13940_type = '\\010'::bytea) AND (_fl (...)
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
  • Buffers: shared hit=63310
32.          

SubPlan (for Index Only Scan)

33. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t53_1 (cost=0.41..3.03 rows=1 width=18) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\340'::bytea) AND (_fld139 (...)
  • Heap Fetches: 0
34. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t54_1 (cost=0.41..82.55 rows=46 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\3 (...)
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
35.          

SubPlan (for Nested Loop Semi Join)

36. 1.887 1.887 ↑ 1.0 1 629

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t51 (cost=0.43..3.06 rows=1 width=0) (actual time=0.003..0.003 rows=1 loops=629)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = CASE WHEN (CASE WHEN ((t43._fld15638_type = '\\010'::bytea) AND (t43._fld15638_rtref = '\\000\\000\\ (...)
  • Heap Fetches: 0
  • Buffers: shared hit=1888
37. 0.000 0.000 ↓ 0.0 0

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

  • Filter: (_fld717 = '0'::numeric)
38. 1.258 1.258 ↑ 1.0 1 629

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t52 (cost=0.43..1.76 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=629)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13939rref = t46._idrref) AND (_fld13940_type = CASE WHEN (CASE WHEN ((t43._fld15638_type (...)
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
  • Buffers: shared hit=1888
39. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t52_1 (cost=0.41..87.65 rows=1,112 width=24) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
40. 1.887 8.177 ↑ 1.0 1 629

Nested Loop (cost=0.86..6.12 rows=1 width=0) (actual time=0.013..0.013 rows=1 loops=629)

  • Buffers: shared hit=3831
41. 4.403 4.403 ↑ 1.0 1 629

Index Only Scan using _inforg13761_bydims_rrn on _inforg13761 t56 (cost=0.45..3.08 rows=1 width=24) (actual time=0.007..0.007 rows=1 loops=629)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13762_type = CASE WHEN (CASE WHEN ((t43._fld15638_type = '\\010'::bytea) AND (t43._fld15638_rtref = '\\000\ (...)
  • Heap Fetches: 54
  • Buffers: shared hit=1943
42. 1.887 1.887 ↑ 1.0 1 629

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t55 (cost=0.41..3.03 rows=1 width=27) (actual time=0.003..0.003 rows=1 loops=629)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = t56._fld13763_type) AND (_fld13933_rtref = t56._fld13763_rtref) AND (_fld13933_rrref = t56._fl (...)
  • Heap Fetches: 0
  • Buffers: shared hit=1888
43. 1.258 1.258 ↑ 1.0 1 629

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t57 (cost=0.43..1.76 rows=1 width=0) (actual time=0.002..0.002 rows=1 loops=629)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13939rref = t46._idrref) AND (_fld13940_type = CASE WHEN (CASE WHEN ((t43._fld15638_type (...)
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
  • Buffers: shared hit=1888
44. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t57_1 (cost=0.41..87.65 rows=1,112 width=24) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
45. 2.234 7.303 ↓ 1.1 14,692 1

Hash (cost=401.16..401.16 rows=13,913 width=42) (actual time=7.303..7.303 rows=14,692 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 1078kB
  • Buffers: shared hit=170
46. 1.666 5.069 ↓ 1.1 14,692 1

Hash Left Join (cost=8.62..401.16 rows=13,913 width=42) (actual time=0.121..5.069 rows=14,692 loops=1)

  • Hash Cond: (t40._fld20188rref = t58._fld20229rref)
  • Buffers: shared hit=170
47. 3.302 3.302 ↓ 1.1 14,692 1

Seq Scan on _inforg20187 t40 (cost=0.00..338.91 rows=13,913 width=34) (actual time=0.014..3.302 rows=14,692 loops=1)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=165
48. 0.022 0.101 ↓ 1.1 154 1

Hash (cost=6.81..6.81 rows=145 width=25) (actual time=0.101..0.101 rows=154 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
  • Buffers: shared hit=5
49. 0.079 0.079 ↓ 1.1 154 1

Seq Scan on _inforg20228 t58 (cost=0.00..6.81 rows=145 width=25) (actual time=0.012..0.079 rows=154 loops=1)

  • Filter: (_fld717 = '0'::numeric)
  • Buffers: shared hit=5
50. 1,172.416 1,172.416 ↑ 1.0 80,173 32

Seq Scan on _inforg20553 t60 (cost=0.00..7,641.78 rows=80,383 width=42) (actual time=0.027..36.638 rows=80,173 loops=32)

  • Filter: ((_fld20557 >= '2019-08-01 00:00:00'::timestamp without time zone) AND (_fld20557 <= '2019-08-31 23:59:59'::timestamp without time zone) AND (_fld717 = '0'::numeric))
  • Rows Removed by Filter: 170395
  • Buffers: shared hit=104640
51. 0.000 0.000 ↓ 0.0 0

Index Scan using _inforg17710_bydims_r on _inforg17710 t59 (cost=0.43..1.34 rows=1 width=168) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld17711rref = t60._fld20554rref))
52. 0.000 0.000 ↓ 0.0 0

Materialize (cost=4.38..8.39 rows=1 width=17) (never executed)

53. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=4.38..8.38 rows=1 width=17) (never executed)

54. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=4.11..8.08 rows=1 width=38) (never executed)

55. 0.000 0.000 ↓ 0.0 0

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

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

Nested Loop (cost=3.71..6.35 rows=1 width=57) (never executed)

57. 0.000 0.000 ↓ 0.0 0

HashAggregate (cost=3.29..3.30 rows=1 width=19) (never executed)

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

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

59. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg14726_bydims14730_rr on _inforg14726 t65 (cost=0.28..1.60 rows=1 width=24) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14728_type = '\\010'::bytea) AND (_fld14728_rtref = '\\000\\000\\000\\254'::bytea) AND (_fld14728_rrref = '\\002\\2140Z:wN\\241\\021\\351\\276\\230\\011A\\206\ (...)
  • Heap Fetches: 0
60. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference73_vt2103_byfield2106_rr on _reference73_vt2103 t64 (cost=0.28..1.65 rows=3 width=49) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld2105_type = t65._fld14727_type) AND (_fld2105_rtref = t65._fld14727_rtref) AND (_fld2105_rrref = t65._fld14727_rrref))
  • Heap Fetches: 0
61. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg14845_bydims14850_rr on _inforg14845 t62 (cost=0.42..3.04 rows=1 width=38) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld14847rref = t64._reference73_idrref) AND (_fld14846rref = t63._idrref))
  • Heap Fetches: 0
62. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _reference73hpk on _reference73 t61 (cost=0.27..0.29 rows=1 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_idrref = t62._fld14847rref))
  • Heap Fetches: 0
63.          

SubPlan (for Nested Loop Semi Join)

64. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t66 (cost=0.41..3.03 rows=1 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\340'::bytea) AND (_fld13933_rrref = t37._fld7786rref) AND (_fld13932rref = t61._idrref))
  • Heap Fetches: 0
65. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t66_1 (cost=0.41..34.26 rows=266 width=36) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\340'::bytea))
  • Heap Fetches: 0
66. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t67 (cost=0.41..1.74 rows=1 width=0) (never executed)

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

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t67_1 (cost=0.41..82.55 rows=46 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\340'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
68. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t71 (cost=0.41..3.03 rows=1 width=0) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\361'::bytea) AND (_fld13933_rrref = t37._fld7818rref) AND (_fld13932rref = t61._idrref))
  • Heap Fetches: 0
69. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t71_1 (cost=0.41..23.18 rows=178 width=36) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = '\\010'::bytea) AND (_fld13933_rtref = '\\000\\000\\000\\361'::bytea))
  • Heap Fetches: 0
70. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t72 (cost=0.41..1.74 rows=1 width=0) (never executed)

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

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t72_1 (cost=0.41..82.55 rows=46 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\361'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
72. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.83..6.09 rows=1 width=0) (never executed)

73. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13761_bydims_rrn on _inforg13761 t69 (cost=0.42..3.05 rows=1 width=24) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13762_type = '\\010'::bytea) AND (_fld13762_rtref = '\\000\\000\\000\\242'::bytea) AND (_fld13762_rrref = t37._fld7777rref))
  • Heap Fetches: 0
74. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13931_bydims13935_rr on _inforg13931 t68 (cost=0.41..3.03 rows=1 width=27) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13933_type = t69._fld13763_type) AND (_fld13933_rtref = t69._fld13763_rtref) AND (_fld13933_rrref = t69._fld13763_rrref) AND (_fld13932rref = t61._idrref))
  • Heap Fetches: 0
75. 0.000 0.000 ↓ 0.0 0

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t70 (cost=0.41..1.74 rows=1 width=0) (never executed)

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

Index Only Scan using _inforg13938_byresource13945_lrr on _inforg13938 t70_1 (cost=0.41..82.55 rows=46 width=17) (never executed)

  • Index Cond: ((_fld717 = '0'::numeric) AND (_fld13941 = false) AND (_fld13940_type = '\\010'::bytea) AND (_fld13940_rtref = '\\000\\000\\000\\242'::bytea))
  • Filter: (NOT _fld13941)
  • Heap Fetches: 0
Planning time : 16.574 ms
Execution time : 137,589.161 ms