explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LItA

Settings
# exclusive inclusive rows x rows loops node
1. 0.070 31,710.511 ↑ 1.3 78 1

Sort (cost=470,222.32..470,222.58 rows=104 width=199) (actual time=31,709.868..31,710.511 rows=78 loops=1)

  • Sort Key: e.last_used DESC
  • Sort Method: quicksort Memory: 45kB
2. 47.174 31,710.441 ↑ 1.3 78 1

GroupAggregate (cost=469,707.45..470,218.83 rows=104 width=199) (actual time=31,643.225..31,710.441 rows=78 loops=1)

  • Group Key: e.id
3. 216.255 31,663.267 ↓ 17.8 73,410 1

Sort (cost=469,707.45..469,717.76 rows=4,124 width=116) (actual time=31,642.071..31,663.267 rows=73,410 loops=1)

  • Sort Key: e.id
  • Sort Method: external merge Disk: 8,208kB
4. 161.303 31,447.012 ↓ 17.8 73,410 1

Hash Left Join (cost=260,592.42..469,459.80 rows=4,124 width=116) (actual time=226.907..31,447.012 rows=73,410 loops=1)

  • Hash Cond: (i.id = not_classified.invoice_id)
5. 13,387.794 31,118.109 ↓ 17.8 73,410 1

Gather Merge (cost=1,001.42..209,217.98 rows=4,124 width=116) (actual time=56.450..31,118.109 rows=73,410 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
6. 98.114 17,730.315 ↓ 15.1 36,705 2 / 2

Nested Loop Left Join (cost=1.41..207,754.02 rows=2,426 width=116) (actual time=3.219..17,730.315 rows=36,705 loops=2)

7. 93.231 14,622.391 ↓ 15.1 36,705 2 / 2

Nested Loop Left Join (cost=1.13..166,425.12 rows=2,426 width=123) (actual time=3.102..14,622.391 rows=36,705 loops=2)

8. 100.317 11,776.285 ↓ 15.1 36,705 2 / 2

Nested Loop Left Join (cost=0.99..139,246.80 rows=2,426 width=99) (actual time=2.684..11,776.285 rows=36,705 loops=2)

9. 89.968 7,528.303 ↓ 15.1 36,705 2 / 2

Nested Loop Left Join (cost=0.71..97,917.91 rows=2,426 width=90) (actual time=2.669..7,528.303 rows=36,705 loops=2)

10. 8.264 170.745 ↓ 15.1 36,705 2 / 2

Nested Loop (cost=0.43..56,589.01 rows=2,426 width=81) (actual time=1.927..170.745 rows=36,705 loops=2)

11. 25.461 25.461 ↑ 1.2 52 2 / 2

Parallel Index Scan using client_pkey on entity e (cost=0.29..3,047.15 rows=61 width=47) (actual time=1.118..25.461 rows=52 loops=2)

  • Filter: (identifier = ANY ('{10118,10286,10295,10327,16100,16478,17415,17603,31053,31105,33235,33514,33517,33566,33610,34137,35187,35431,35624,35806,36356,36485,36821,37806,37992,38294,38464,38482,38540,39216,39634,407794,428352,5053,50651,50674,50705,5088,5117,51406,51411,51510,5155,51982,52077,52776,53046,53114,53115,53736,53811,54093,54117,54553,54589,54608,54661,54793,54856,54968,55262,55277,55328,55537,55575,55576,55699,5570,55721,55816,5582,5791,57959,58063,58446,58965,58988,59010,59064,59084,59287,5932,5962,59727,59911,59922,60076,60140,60605,6061,60693,60694,61021,6327,6448,6612,6696,6698,7633,7945,9310,9311,9616,9950}'::text[]))
  • Rows Removed by Filter: 7,156
12. 7.332 137.020 ↑ 3.4 706 104 / 2

Append (cost=0.14..853.46 rows=2,428 width=50) (actual time=0.180..2.635 rows=706 loops=104)

13. 0.208 0.208 ↓ 0.0 0 104 / 2

Index Scan using document_167001_entity_id_idx on document_167001 d (cost=0.14..0.52 rows=1 width=50) (actual time=0.004..0.004 rows=0 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
14. 0.104 0.104 ↓ 0.0 0 104 / 2

Index Scan using document_201711_entity_id_idx on document_201711 d_1 (cost=0.14..0.24 rows=4 width=50) (actual time=0.002..0.002 rows=0 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
15. 0.104 0.104 ↓ 0.0 0 104 / 2

Index Scan using document_201712_entity_id_idx on document_201712 d_2 (cost=0.13..0.20 rows=2 width=50) (actual time=0.002..0.002 rows=0 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
16. 0.104 0.104 ↓ 0.0 0 104 / 2

Index Scan using document_201801_entity_id_idx on document_201801 d_3 (cost=0.14..1.45 rows=66 width=50) (actual time=0.002..0.002 rows=0 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
17. 0.104 0.104 ↓ 0.0 0 104 / 2

Index Scan using document_201802_entity_id_idx on document_201802 d_4 (cost=0.14..0.25 rows=4 width=50) (actual time=0.002..0.002 rows=0 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
18. 0.208 0.208 ↓ 0.0 0 104 / 2

Index Scan using document_201804_entity_id_idx on document_201804 d_5 (cost=0.27..1.77 rows=62 width=50) (actual time=0.004..0.004 rows=0 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
19. 0.364 0.364 ↑ 91.0 2 104 / 2

Index Scan using document_201805_entity_id_idx on document_201805 d_6 (cost=0.28..10.25 rows=182 width=50) (actual time=0.005..0.007 rows=2 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
20. 0.728 0.728 ↑ 15.6 7 104 / 2

Index Scan using document_201806_entity_id_idx on document_201806 d_7 (cost=0.28..7.51 rows=109 width=50) (actual time=0.005..0.014 rows=7 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
21. 3.380 3.380 ↑ 2.8 34 104 / 2

Index Scan using document_201807_entity_id_idx on document_201807 d_8 (cost=0.29..21.87 rows=95 width=50) (actual time=0.018..0.065 rows=34 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
22. 2.704 2.704 ↑ 3.0 34 104 / 2

Index Scan using document_201808_entity_id_idx on document_201808 d_9 (cost=0.29..18.83 rows=101 width=50) (actual time=0.007..0.052 rows=34 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
23. 1.976 1.976 ↑ 5.1 16 104 / 2

Index Scan using document_201809_entity_id_idx on document_201809 d_10 (cost=0.29..16.93 rows=82 width=50) (actual time=0.015..0.038 rows=16 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
24. 1.820 1.820 ↑ 3.0 20 104 / 2

Index Scan using document_201810_entity_id_idx on document_201810 d_11 (cost=0.29..13.25 rows=60 width=50) (actual time=0.007..0.035 rows=20 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
25. 2.444 2.444 ↑ 3.7 26 104 / 2

Index Scan using document_201811_entity_id_idx on document_201811 d_12 (cost=0.29..24.59 rows=96 width=50) (actual time=0.010..0.047 rows=26 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
26. 1.716 1.716 ↑ 3.4 17 104 / 2

Index Scan using document_201812_entity_id_idx on document_201812 d_13 (cost=0.29..13.39 rows=57 width=50) (actual time=0.007..0.033 rows=17 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
27. 3.484 3.484 ↑ 2.6 31 104 / 2

Index Scan using document_201901_entity_id_idx on document_201901 d_14 (cost=0.29..23.55 rows=80 width=50) (actual time=0.014..0.067 rows=31 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
28. 2.392 2.392 ↑ 2.5 22 104 / 2

Index Scan using document_201902_entity_id_idx on document_201902 d_15 (cost=0.29..15.22 rows=54 width=50) (actual time=0.008..0.046 rows=22 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
29. 3.328 3.328 ↑ 2.6 30 104 / 2

Index Scan using document_201903_entity_id_idx on document_201903 d_16 (cost=0.29..28.13 rows=79 width=50) (actual time=0.013..0.064 rows=30 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
30. 2.860 2.860 ↑ 2.7 23 104 / 2

Index Scan using document_201904_entity_id_idx on document_201904 d_17 (cost=0.29..21.05 rows=61 width=50) (actual time=0.012..0.055 rows=23 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
31. 3.016 3.016 ↑ 1.9 29 104 / 2

Index Scan using document_201905_entity_id_idx on document_201905 d_18 (cost=0.29..20.55 rows=56 width=50) (actual time=0.010..0.058 rows=29 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
32. 2.912 2.912 ↑ 2.5 21 104 / 2

Index Scan using document_201906_entity_id_idx on document_201906 d_19 (cost=0.29..18.43 rows=52 width=50) (actual time=0.014..0.056 rows=21 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
33. 3.900 3.900 ↑ 2.4 25 104 / 2

Index Scan using document_201907_entity_id_idx on document_201907 d_20 (cost=0.29..22.40 rows=61 width=50) (actual time=0.025..0.075 rows=25 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
34. 1.716 1.716 ↑ 3.1 16 104 / 2

Index Scan using document_201908_entity_id_idx on document_201908 d_21 (cost=0.29..14.25 rows=50 width=50) (actual time=0.007..0.033 rows=16 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
35. 3.432 3.432 ↑ 2.1 28 104 / 2

Index Scan using document_201909_entity_id_idx on document_201909 d_22 (cost=0.29..20.94 rows=59 width=50) (actual time=0.015..0.066 rows=28 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
36. 6.240 6.240 ↑ 1.9 35 104 / 2

Index Scan using document_201910_entity_id_idx on document_201910 d_23 (cost=0.29..24.70 rows=66 width=50) (actual time=0.059..0.120 rows=35 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
37. 2.444 2.444 ↑ 2.3 24 104 / 2

Index Scan using document_201911_entity_id_idx on document_201911 d_24 (cost=0.29..19.13 rows=56 width=50) (actual time=0.008..0.047 rows=24 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
38. 2.184 2.184 ↑ 3.3 19 104 / 2

Index Scan using document_201912_entity_id_idx on document_201912 d_25 (cost=0.29..19.60 rows=63 width=50) (actual time=0.008..0.042 rows=19 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
39. 4.160 4.160 ↑ 2.3 34 104 / 2

Index Scan using document_202001_entity_id_idx on document_202001 d_26 (cost=0.29..31.74 rows=79 width=50) (actual time=0.015..0.080 rows=34 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
40. 3.484 3.484 ↑ 2.8 28 104 / 2

Index Scan using document_202002_entity_id_idx on document_202002 d_27 (cost=0.29..32.24 rows=77 width=50) (actual time=0.015..0.067 rows=28 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
41. 3.432 3.432 ↑ 2.3 30 104 / 2

Index Scan using document_202003_entity_id_idx on document_202003 d_28 (cost=0.29..30.05 rows=70 width=50) (actual time=0.012..0.066 rows=30 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
42. 8.632 8.632 ↑ 4.7 25 104 / 2

Index Scan using document_202004_entity_id_idx on document_202004 d_29 (cost=0.42..91.85 rows=117 width=50) (actual time=0.044..0.166 rows=25 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
  • Rows Removed by Filter: 0
43. 5.928 5.928 ↑ 3.8 17 104 / 2

Index Scan using document_202005_entity_id_idx on document_202005 d_30 (cost=0.29..40.82 rows=64 width=50) (actual time=0.051..0.114 rows=17 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
44. 11.908 11.908 ↑ 2.9 27 104 / 2

Index Scan using document_202006_entity_id_idx on document_202006 d_31 (cost=0.29..49.50 rows=78 width=50) (actual time=0.125..0.229 rows=27 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
45. 6.500 6.500 ↑ 3.0 27 104 / 2

Index Scan using document_202007_entity_id_idx on document_202007 d_32 (cost=0.29..55.05 rows=80 width=50) (actual time=0.030..0.125 rows=27 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
46. 4.212 4.212 ↑ 3.7 15 104 / 2

Index Scan using document_202008_entity_id_idx on document_202008 d_33 (cost=0.29..33.64 rows=56 width=50) (actual time=0.016..0.081 rows=15 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
47. 11.076 11.076 ↑ 3.4 25 104 / 2

Index Scan using document_202009_entity_id_idx on document_202009 d_34 (cost=0.41..56.60 rows=86 width=50) (actual time=0.068..0.213 rows=25 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
48. 16.276 16.276 ↑ 3.2 19 104 / 2

Index Scan using document_202010_entity_id_idx on document_202010 d_35 (cost=0.41..40.25 rows=61 width=50) (actual time=0.113..0.313 rows=19 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
49. 0.104 0.104 ↓ 0.0 0 104 / 2

Index Scan using document_202011_entity_id_idx on document_202011 d_36 (cost=0.15..0.28 rows=1 width=72) (actual time=0.002..0.002 rows=0 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
50. 0.104 0.104 ↓ 0.0 0 104 / 2

Index Scan using document_default_entity_id_idx on document_default d_37 (cost=0.14..0.27 rows=1 width=50) (actual time=0.002..0.002 rows=0 loops=104)

  • Index Cond: (entity_id = e.id)
  • Filter: (NOT deleted)
51. 403.755 7,267.590 ↑ 38.0 1 73,410 / 2

Append (cost=0.28..16.66 rows=38 width=25) (actual time=0.176..0.198 rows=1 loops=73,410)

52. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_167001_unique_in_document_idx on field_167001 sub_type (cost=0.28..0.30 rows=1 width=24) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
53. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_201711_unique_in_document_idx on field_201711 sub_type_1 (cost=0.27..0.29 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
54. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_201712_unique_in_document_idx on field_201712 sub_type_2 (cost=0.14..0.16 rows=1 width=26) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
55. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_201801_unique_in_document_idx on field_201801 sub_type_3 (cost=0.28..0.30 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
56. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_201802_unique_in_document_idx on field_201802 sub_type_4 (cost=0.27..0.29 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
57. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_201804_unique_in_document_idx on field_201804 sub_type_5 (cost=0.28..0.30 rows=1 width=24) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
58. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201805_unique_in_document_idx on field_201805 sub_type_6 (cost=0.42..0.45 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
59. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201806_unique_in_document_idx on field_201806 sub_type_7 (cost=0.42..0.45 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
60. 183.525 183.525 ↓ 0.0 0 73,410 / 2

Index Scan using field_201807_unique_in_document_idx on field_201807 sub_type_8 (cost=0.42..0.48 rows=1 width=25) (actual time=0.005..0.005 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
61. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_201808_unique_in_document_idx on field_201808 sub_type_9 (cost=0.42..0.47 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
62. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_201809_unique_in_document_idx on field_201809 sub_type_10 (cost=0.42..0.46 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
63. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_201810_unique_in_document_idx on field_201810 sub_type_11 (cost=0.42..0.46 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
64. 146.820 146.820 ↓ 0.0 0 73,410 / 2

Index Scan using field_201811_unique_in_document_idx on field_201811 sub_type_12 (cost=0.42..0.48 rows=1 width=25) (actual time=0.004..0.004 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
65. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_201812_unique_in_document_idx on field_201812 sub_type_13 (cost=0.42..0.46 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
66. 256.935 256.935 ↓ 0.0 0 73,410 / 2

Index Scan using field_201901_unique_in_document_idx on field_201901 sub_type_14 (cost=0.42..0.48 rows=1 width=25) (actual time=0.007..0.007 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
67. 146.820 146.820 ↓ 0.0 0 73,410 / 2

Index Scan using field_201902_unique_in_document_idx on field_201902 sub_type_15 (cost=0.42..0.47 rows=1 width=25) (actual time=0.004..0.004 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
68. 220.230 220.230 ↓ 0.0 0 73,410 / 2

Index Scan using field_201903_unique_in_document_idx on field_201903 sub_type_16 (cost=0.42..0.49 rows=1 width=25) (actual time=0.006..0.006 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
69. 146.820 146.820 ↓ 0.0 0 73,410 / 2

Index Scan using field_201904_unique_in_document_idx on field_201904 sub_type_17 (cost=0.42..0.48 rows=1 width=25) (actual time=0.004..0.004 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
70. 146.820 146.820 ↓ 0.0 0 73,410 / 2

Index Scan using field_201905_unique_in_document_idx on field_201905 sub_type_18 (cost=0.42..0.48 rows=1 width=25) (actual time=0.004..0.004 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
71. 146.820 146.820 ↓ 0.0 0 73,410 / 2

Index Scan using field_201906_unique_in_document_idx on field_201906 sub_type_19 (cost=0.42..0.47 rows=1 width=25) (actual time=0.004..0.004 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
72. 183.525 183.525 ↓ 0.0 0 73,410 / 2

Index Scan using field_201907_unique_in_document_idx on field_201907 sub_type_20 (cost=0.42..0.48 rows=1 width=25) (actual time=0.005..0.005 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
73. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_201908_unique_in_document_idx on field_201908 sub_type_21 (cost=0.42..0.46 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
74. 183.525 183.525 ↓ 0.0 0 73,410 / 2

Index Scan using field_201909_unique_in_document_idx on field_201909 sub_type_22 (cost=0.42..0.47 rows=1 width=25) (actual time=0.005..0.005 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
75. 183.525 183.525 ↓ 0.0 0 73,410 / 2

Index Scan using field_201910_unique_in_document_idx on field_201910 sub_type_23 (cost=0.42..0.48 rows=1 width=25) (actual time=0.005..0.005 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
76. 146.820 146.820 ↓ 0.0 0 73,410 / 2

Index Scan using field_201911_unique_in_document_idx on field_201911 sub_type_24 (cost=0.42..0.47 rows=1 width=25) (actual time=0.004..0.004 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
77. 220.230 220.230 ↓ 0.0 0 73,410 / 2

Index Scan using field_201912_unique_in_document_idx on field_201912 sub_type_25 (cost=0.42..0.47 rows=1 width=25) (actual time=0.006..0.006 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
78. 220.230 220.230 ↓ 0.0 0 73,410 / 2

Index Scan using field_202001_unique_in_document_idx on field_202001 sub_type_26 (cost=0.42..0.49 rows=1 width=25) (actual time=0.006..0.006 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
79. 183.525 183.525 ↓ 0.0 0 73,410 / 2

Index Scan using field_202002_unique_in_document_idx on field_202002 sub_type_27 (cost=0.42..0.49 rows=1 width=25) (actual time=0.005..0.005 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
80. 220.230 220.230 ↓ 0.0 0 73,410 / 2

Index Scan using field_202003_unique_in_document_idx on field_202003 sub_type_28 (cost=0.42..0.48 rows=1 width=26) (actual time=0.006..0.006 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
81. 477.165 477.165 ↓ 0.0 0 73,410 / 2

Index Scan using field_202004_unique_in_document_idx on field_202004 sub_type_29 (cost=0.43..0.64 rows=1 width=25) (actual time=0.013..0.013 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
82. 330.345 330.345 ↓ 0.0 0 73,410 / 2

Index Scan using field_202005_unique_in_document_idx on field_202005 sub_type_30 (cost=0.42..0.50 rows=1 width=25) (actual time=0.009..0.009 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
83. 477.165 477.165 ↓ 0.0 0 73,410 / 2

Index Scan using field_202006_unique_in_document_idx on field_202006 sub_type_31 (cost=0.42..0.52 rows=1 width=25) (actual time=0.013..0.013 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
84. 513.870 513.870 ↓ 0.0 0 73,410 / 2

Index Scan using field_202007_unique_in_document_idx on field_202007 sub_type_32 (cost=0.42..0.52 rows=1 width=25) (actual time=0.014..0.014 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
85. 256.935 256.935 ↓ 0.0 0 73,410 / 2

Index Scan using field_202008_unique_in_document_idx on field_202008 sub_type_33 (cost=0.42..0.47 rows=1 width=25) (actual time=0.007..0.007 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
86. 550.575 550.575 ↓ 0.0 0 73,410 / 2

Index Scan using field_202009_unique_in_document_idx on field_202009 sub_type_34 (cost=0.42..0.51 rows=1 width=25) (actual time=0.015..0.015 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
87. 330.345 330.345 ↓ 0.0 0 73,410 / 2

Index Scan using field_202010_unique_in_document_idx on field_202010 sub_type_35 (cost=0.42..0.48 rows=1 width=25) (actual time=0.009..0.009 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
88. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_202011_unique_in_document_idx on field_202011 sub_type_36 (cost=0.12..0.15 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
89. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_unique_in_document_idx on field_default sub_type_37 (cost=0.12..0.15 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'invoice_type'::text))
90. 220.230 4,147.665 ↑ 38.0 1 73,410 / 2

Append (cost=0.28..16.66 rows=38 width=25) (actual time=0.088..0.113 rows=1 loops=73,410)

91. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_167001_unique_in_document_idx on field_167001 type_document (cost=0.28..0.30 rows=1 width=24) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
92. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_201711_unique_in_document_idx on field_201711 type_document_1 (cost=0.27..0.29 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
93. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_201712_unique_in_document_idx on field_201712 type_document_2 (cost=0.14..0.16 rows=1 width=26) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
94. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_201801_unique_in_document_idx on field_201801 type_document_3 (cost=0.28..0.30 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
95. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_201802_unique_in_document_idx on field_201802 type_document_4 (cost=0.27..0.29 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
96. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_201804_unique_in_document_idx on field_201804 type_document_5 (cost=0.28..0.30 rows=1 width=24) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
97. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_201805_unique_in_document_idx on field_201805 type_document_6 (cost=0.42..0.45 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
98. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_201806_unique_in_document_idx on field_201806 type_document_7 (cost=0.42..0.45 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
99. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_201807_unique_in_document_idx on field_201807 type_document_8 (cost=0.42..0.48 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
100. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201808_unique_in_document_idx on field_201808 type_document_9 (cost=0.42..0.47 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
101. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201809_unique_in_document_idx on field_201809 type_document_10 (cost=0.42..0.46 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
102. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201810_unique_in_document_idx on field_201810 type_document_11 (cost=0.42..0.46 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
103. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_201811_unique_in_document_idx on field_201811 type_document_12 (cost=0.42..0.48 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
104. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201812_unique_in_document_idx on field_201812 type_document_13 (cost=0.42..0.46 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
105. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_201901_unique_in_document_idx on field_201901 type_document_14 (cost=0.42..0.48 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
106. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_201902_unique_in_document_idx on field_201902 type_document_15 (cost=0.42..0.47 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
107. 146.820 146.820 ↓ 0.0 0 73,410 / 2

Index Scan using field_201903_unique_in_document_idx on field_201903 type_document_16 (cost=0.42..0.49 rows=1 width=25) (actual time=0.004..0.004 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
108. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_201904_unique_in_document_idx on field_201904 type_document_17 (cost=0.42..0.48 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
109. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_201905_unique_in_document_idx on field_201905 type_document_18 (cost=0.42..0.48 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
110. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_201906_unique_in_document_idx on field_201906 type_document_19 (cost=0.42..0.47 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
111. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_201907_unique_in_document_idx on field_201907 type_document_20 (cost=0.42..0.48 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
112. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201908_unique_in_document_idx on field_201908 type_document_21 (cost=0.42..0.46 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
113. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_201909_unique_in_document_idx on field_201909 type_document_22 (cost=0.42..0.47 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
114. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_201910_unique_in_document_idx on field_201910 type_document_23 (cost=0.42..0.48 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
115. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201911_unique_in_document_idx on field_201911 type_document_24 (cost=0.42..0.47 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
116. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_201912_unique_in_document_idx on field_201912 type_document_25 (cost=0.42..0.47 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
117. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_202001_unique_in_document_idx on field_202001 type_document_26 (cost=0.42..0.49 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
118. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_202002_unique_in_document_idx on field_202002 type_document_27 (cost=0.42..0.49 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
119. 146.820 146.820 ↓ 0.0 0 73,410 / 2

Index Scan using field_202003_unique_in_document_idx on field_202003 type_document_28 (cost=0.42..0.48 rows=1 width=26) (actual time=0.004..0.004 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
120. 256.935 256.935 ↓ 0.0 0 73,410 / 2

Index Scan using field_202004_unique_in_document_idx on field_202004 type_document_29 (cost=0.43..0.64 rows=1 width=25) (actual time=0.007..0.007 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
121. 183.525 183.525 ↓ 0.0 0 73,410 / 2

Index Scan using field_202005_unique_in_document_idx on field_202005 type_document_30 (cost=0.42..0.50 rows=1 width=25) (actual time=0.005..0.005 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
122. 220.230 220.230 ↓ 0.0 0 73,410 / 2

Index Scan using field_202006_unique_in_document_idx on field_202006 type_document_31 (cost=0.42..0.52 rows=1 width=25) (actual time=0.005..0.006 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
123. 220.230 220.230 ↓ 0.0 0 73,410 / 2

Index Scan using field_202007_unique_in_document_idx on field_202007 type_document_32 (cost=0.42..0.52 rows=1 width=25) (actual time=0.006..0.006 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
124. 146.820 146.820 ↓ 0.0 0 73,410 / 2

Index Scan using field_202008_unique_in_document_idx on field_202008 type_document_33 (cost=0.42..0.47 rows=1 width=25) (actual time=0.004..0.004 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
125. 220.230 220.230 ↓ 0.0 0 73,410 / 2

Index Scan using field_202009_unique_in_document_idx on field_202009 type_document_34 (cost=0.42..0.51 rows=1 width=25) (actual time=0.006..0.006 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
126. 146.820 146.820 ↓ 0.0 0 73,410 / 2

Index Scan using field_202010_unique_in_document_idx on field_202010 type_document_35 (cost=0.42..0.48 rows=1 width=25) (actual time=0.004..0.004 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
127. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_202011_unique_in_document_idx on field_202011 type_document_36 (cost=0.12..0.15 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
128. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_unique_in_document_idx on field_default type_document_37 (cost=0.12..0.15 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'type_document'::text))
129. 183.525 2,752.875 ↑ 39.0 1 73,410 / 2

Append (cost=0.14..10.81 rows=39 width=40) (actual time=0.060..0.075 rows=1 loops=73,410)

130. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_167001_unique_document_id_idx on invoice_167001 i (cost=0.14..0.16 rows=1 width=41) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
131. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201709_unique_document_id_idx on invoice_201709 i_1 (cost=0.12..0.14 rows=1 width=42) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
132. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201711_unique_document_id_idx on invoice_201711 i_2 (cost=0.13..0.15 rows=1 width=41) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
133. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201712_unique_document_id_idx on invoice_201712 i_3 (cost=0.13..0.15 rows=1 width=41) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
134. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201801_unique_document_id_idx on invoice_201801 i_4 (cost=0.14..0.16 rows=1 width=40) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
135. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201802_unique_document_id_idx on invoice_201802 i_5 (cost=0.13..0.15 rows=1 width=41) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
136. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201804_unique_document_id_idx on invoice_201804 i_6 (cost=0.27..0.29 rows=1 width=41) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
137. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201805_unique_document_id_idx on invoice_201805 i_7 (cost=0.28..0.30 rows=1 width=41) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
138. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201806_unique_document_id_idx on invoice_201806 i_8 (cost=0.28..0.30 rows=1 width=40) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
139. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201807_unique_document_id_idx on invoice_201807 i_9 (cost=0.29..0.30 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
140. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201808_unique_document_id_idx on invoice_201808 i_10 (cost=0.29..0.30 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
141. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201809_unique_document_id_idx on invoice_201809 i_11 (cost=0.28..0.30 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
142. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201810_unique_document_id_idx on invoice_201810 i_12 (cost=0.28..0.30 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
143. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201811_unique_document_id_idx on invoice_201811 i_13 (cost=0.29..0.30 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
144. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201812_unique_document_id_idx on invoice_201812 i_14 (cost=0.28..0.30 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
145. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201901_unique_document_id_idx on invoice_201901 i_15 (cost=0.29..0.30 rows=1 width=40) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
146. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201902_unique_document_id_idx on invoice_201902 i_16 (cost=0.28..0.30 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
147. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201903_unique_document_id_idx on invoice_201903 i_17 (cost=0.29..0.31 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
148. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201904_unique_document_id_idx on invoice_201904 i_18 (cost=0.29..0.30 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
149. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201905_unique_document_id_idx on invoice_201905 i_19 (cost=0.29..0.30 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
150. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201906_unique_document_id_idx on invoice_201906 i_20 (cost=0.28..0.30 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
151. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201907_unique_document_id_idx on invoice_201907 i_21 (cost=0.29..0.30 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
152. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201908_unique_document_id_idx on invoice_201908 i_22 (cost=0.28..0.30 rows=1 width=40) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
153. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201909_unique_document_id_idx on invoice_201909 i_23 (cost=0.29..0.30 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
154. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201910_unique_document_id_idx on invoice_201910 i_24 (cost=0.29..0.30 rows=1 width=41) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
155. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201911_unique_document_id_idx on invoice_201911 i_25 (cost=0.28..0.30 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
156. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_201912_unique_document_id_idx on invoice_201912 i_26 (cost=0.29..0.30 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
157. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_202001_unique_document_id_idx on invoice_202001 i_27 (cost=0.29..0.31 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
158. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_202002_unique_document_id_idx on invoice_202002 i_28 (cost=0.29..0.31 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
159. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_202003_unique_document_id_idx on invoice_202003 i_29 (cost=0.29..0.30 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
160. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_202004_unique_document_id_idx on invoice_202004 i_30 (cost=0.29..0.32 rows=1 width=41) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
161. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_202005_unique_document_id_idx on invoice_202005 i_31 (cost=0.29..0.31 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
162. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_202006_unique_document_id_idx on invoice_202006 i_32 (cost=0.29..0.31 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
163. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_202007_unique_document_id_idx on invoice_202007 i_33 (cost=0.29..0.31 rows=1 width=41) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
164. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_202008_unique_document_id_idx on invoice_202008 i_34 (cost=0.28..0.30 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
165. 146.820 146.820 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_202009_unique_document_id_idx on invoice_202009 i_35 (cost=0.29..0.31 rows=1 width=41) (actual time=0.004..0.004 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
166. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_202010_unique_document_id_idx on invoice_202010 i_36 (cost=0.28..0.31 rows=1 width=40) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
167. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_202011_unique_document_id_idx on invoice_202011 i_37 (cost=0.12..0.14 rows=1 width=64) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
168. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using invoice_default_unique_document_id_idx on invoice_default i_38 (cost=0.12..0.14 rows=1 width=40) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: (document_id = d.id)
169. 256.935 3,009.810 ↓ 0.0 0 73,410 / 2

Append (cost=0.28..16.66 rows=38 width=25) (actual time=0.069..0.082 rows=0 loops=73,410)

170. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_167001_unique_in_document_idx on field_167001 user_tag (cost=0.28..0.30 rows=1 width=24) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
171. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_201711_unique_in_document_idx on field_201711 user_tag_1 (cost=0.27..0.29 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
172. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_201712_unique_in_document_idx on field_201712 user_tag_2 (cost=0.14..0.16 rows=1 width=26) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
173. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_201801_unique_in_document_idx on field_201801 user_tag_3 (cost=0.28..0.30 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
174. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_201802_unique_in_document_idx on field_201802 user_tag_4 (cost=0.27..0.29 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
175. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_201804_unique_in_document_idx on field_201804 user_tag_5 (cost=0.28..0.30 rows=1 width=24) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
176. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_201805_unique_in_document_idx on field_201805 user_tag_6 (cost=0.42..0.45 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
177. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_201806_unique_in_document_idx on field_201806 user_tag_7 (cost=0.42..0.45 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
178. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201807_unique_in_document_idx on field_201807 user_tag_8 (cost=0.42..0.48 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
179. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201808_unique_in_document_idx on field_201808 user_tag_9 (cost=0.42..0.47 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
180. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201809_unique_in_document_idx on field_201809 user_tag_10 (cost=0.42..0.46 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
181. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201810_unique_in_document_idx on field_201810 user_tag_11 (cost=0.42..0.46 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
182. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201811_unique_in_document_idx on field_201811 user_tag_12 (cost=0.42..0.48 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
183. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201812_unique_in_document_idx on field_201812 user_tag_13 (cost=0.42..0.46 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
184. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201901_unique_in_document_idx on field_201901 user_tag_14 (cost=0.42..0.48 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
185. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201902_unique_in_document_idx on field_201902 user_tag_15 (cost=0.42..0.47 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
186. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201903_unique_in_document_idx on field_201903 user_tag_16 (cost=0.42..0.49 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
187. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201904_unique_in_document_idx on field_201904 user_tag_17 (cost=0.42..0.48 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
188. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201905_unique_in_document_idx on field_201905 user_tag_18 (cost=0.42..0.48 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
189. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201906_unique_in_document_idx on field_201906 user_tag_19 (cost=0.42..0.47 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
190. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201907_unique_in_document_idx on field_201907 user_tag_20 (cost=0.42..0.48 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
191. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201908_unique_in_document_idx on field_201908 user_tag_21 (cost=0.42..0.46 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
192. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201909_unique_in_document_idx on field_201909 user_tag_22 (cost=0.42..0.47 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
193. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201910_unique_in_document_idx on field_201910 user_tag_23 (cost=0.42..0.48 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
194. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201911_unique_in_document_idx on field_201911 user_tag_24 (cost=0.42..0.47 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
195. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_201912_unique_in_document_idx on field_201912 user_tag_25 (cost=0.42..0.47 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
196. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_202001_unique_in_document_idx on field_202001 user_tag_26 (cost=0.42..0.49 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
197. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_202002_unique_in_document_idx on field_202002 user_tag_27 (cost=0.42..0.49 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
198. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_202003_unique_in_document_idx on field_202003 user_tag_28 (cost=0.42..0.48 rows=1 width=26) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
199. 146.820 146.820 ↓ 0.0 0 73,410 / 2

Index Scan using field_202004_unique_in_document_idx on field_202004 user_tag_29 (cost=0.43..0.64 rows=1 width=25) (actual time=0.004..0.004 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
200. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_202005_unique_in_document_idx on field_202005 user_tag_30 (cost=0.42..0.50 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
201. 146.820 146.820 ↓ 0.0 0 73,410 / 2

Index Scan using field_202006_unique_in_document_idx on field_202006 user_tag_31 (cost=0.42..0.52 rows=1 width=25) (actual time=0.004..0.004 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
202. 146.820 146.820 ↓ 0.0 0 73,410 / 2

Index Scan using field_202007_unique_in_document_idx on field_202007 user_tag_32 (cost=0.42..0.52 rows=1 width=25) (actual time=0.004..0.004 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
203. 73.410 73.410 ↓ 0.0 0 73,410 / 2

Index Scan using field_202008_unique_in_document_idx on field_202008 user_tag_33 (cost=0.42..0.47 rows=1 width=25) (actual time=0.002..0.002 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
204. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_202009_unique_in_document_idx on field_202009 user_tag_34 (cost=0.42..0.51 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
205. 110.115 110.115 ↓ 0.0 0 73,410 / 2

Index Scan using field_202010_unique_in_document_idx on field_202010 user_tag_35 (cost=0.42..0.48 rows=1 width=25) (actual time=0.003..0.003 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
206. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_202011_unique_in_document_idx on field_202011 user_tag_36 (cost=0.12..0.15 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
207. 36.705 36.705 ↓ 0.0 0 73,410 / 2

Index Scan using field_unique_in_document_idx on field_default user_tag_37 (cost=0.12..0.15 rows=1 width=25) (actual time=0.001..0.001 rows=0 loops=73,410)

  • Index Cond: ((document_id = d.id) AND (name = 'user_tag'::text))
208. 0.234 167.600 ↑ 228.4 443 1

Hash (cost=257,832.50..257,832.50 rows=101,160 width=16) (actual time=167.305..167.600 rows=443 loops=1)

  • Buckets: 32,768 Batches: 4 Memory Usage: 261kB
209. 0.069 167.366 ↑ 228.4 443 1

Subquery Scan on not_classified (cost=256,315.10..257,832.50 rows=101,160 width=16) (actual time=166.729..167.366 rows=443 loops=1)

210. 0.185 167.297 ↑ 228.4 443 1

Unique (cost=256,315.10..256,820.90 rows=101,160 width=46) (actual time=166.727..167.297 rows=443 loops=1)

211. 0.713 167.112 ↑ 93.8 1,078 1

Sort (cost=256,315.10..256,568.00 rows=101,160 width=46) (actual time=166.726..167.112 rows=1,078 loops=1)

  • Sort Key: l.invoice_id
  • Sort Method: quicksort Memory: 176kB
212. 8.076 166.399 ↑ 93.8 1,078 1

Finalize GroupAggregate (cost=185,269.00..246,081.03 rows=101,160 width=46) (actual time=150.878..166.399 rows=1,078 loops=1)

  • Group Key: l.id, cla.classification_label
  • Filter: (COALESCE((NOT bool_or(cla.is_training)), true) AND COALESCE(((max(cla.ratio) * '100'::double precision) <= '80'::double precision), true))
  • Rows Removed by Filter: 10,876
213. 84.592 158.323 ↑ 33.8 11,954 1

Gather Merge (cost=185,269.00..235,965.04 rows=404,640 width=55) (actual time=150.857..158.323 rows=11,954 loops=1)

  • Workers Planned: 6
  • Workers Launched: 6
214. 1.047 73.731 ↑ 39.5 1,708 7 / 7

Partial GroupAggregate (cost=184,268.90..185,786.30 rows=67,440 width=55) (actual time=72.465..73.731 rows=1,708 loops=7)

  • Group Key: l.id, cla.classification_label
215. 1.162 72.684 ↑ 39.0 1,731 7 / 7

Sort (cost=184,268.90..184,437.50 rows=67,440 width=55) (actual time=72.458..72.684 rows=1,731 loops=7)

  • Sort Key: l.id, cla.classification_label
  • Sort Method: quicksort Memory: 571kB
  • Worker 0: Sort Method: quicksort Memory: 225kB
  • Worker 1: Sort Method: quicksort Memory: 217kB
  • Worker 2: Sort Method: quicksort Memory: 278kB
  • Worker 3: Sort Method: quicksort Memory: 416kB
  • Worker 4: Sort Method: quicksort Memory: 118kB
  • Worker 5: Sort Method: quicksort Memory: 290kB
216. 0.728 71.522 ↑ 39.0 1,731 7 / 7

Nested Loop Left Join (cost=0.29..177,508.82 rows=67,440 width=55) (actual time=12.401..71.522 rows=1,731 loops=7)

217. 0.831 53.115 ↑ 25.4 570 7 / 7

Nested Loop (cost=0.29..81,952.89 rows=14,468 width=32) (actual time=12.221..53.115 rows=570 loops=7)

218. 0.271 37.480 ↑ 23.2 779 7 / 7

Nested Loop (cost=0.29..55,266.25 rows=18,054 width=48) (actual time=5.470..37.480 rows=779 loops=7)

219. 0.026 7.729 ↑ 6.5 96 7 / 7

Parallel Append (cost=0.29..1,527.24 rows=627 width=16) (actual time=4.623..7.729 rows=96 loops=7)

220. 1.029 1.029 ↑ 96.2 6 2 / 7

Parallel Index Scan using invoice_202004_exported_status_idx on invoice_202004 i_69 (cost=0.41..274.08 rows=577 width=16) (actual time=1.802..3.603 rows=6 loops=2)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
221. 1.152 1.152 ↑ 163.7 3 3 / 7

Parallel Index Scan using invoice_202009_exported_status_idx on invoice_202009 i_74 (cost=0.29..358.87 rows=491 width=16) (actual time=0.828..2.689 rows=3 loops=3)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
222. 0.242 0.242 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_202007_exported_status_idx on invoice_202007 i_72 (cost=0.29..251.96 rows=360 width=16) (actual time=1.692..1.692 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
223. 0.420 0.420 ↑ 5.1 38 2 / 7

Parallel Index Scan using invoice_202006_exported_status_idx on invoice_202006 i_71 (cost=0.29..98.76 rows=193 width=16) (actual time=0.368..1.470 rows=38 loops=2)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
224. 0.577 0.577 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_202005_exported_status_idx on invoice_202005 i_70 (cost=0.29..51.28 rows=115 width=16) (actual time=4.039..4.039 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
225. 0.079 0.079 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201910_exported_status_idx on invoice_201910 i_63 (cost=0.29..5.81 rows=16 width=16) (actual time=0.553..0.553 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
226. 0.346 0.346 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_202003_exported_status_idx on invoice_202003 i_68 (cost=0.29..5.58 rows=14 width=16) (actual time=2.424..2.424 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
227. 0.187 0.187 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201811_exported_status_idx on invoice_201811 i_52 (cost=0.29..5.43 rows=14 width=16) (actual time=1.307..1.307 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
228. 0.162 0.162 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201808_exported_status_idx on invoice_201808 i_49 (cost=0.29..4.06 rows=10 width=16) (actual time=1.134..1.134 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
229. 0.356 0.356 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201807_exported_status_idx on invoice_201807 i_48 (cost=0.29..2.54 rows=2 width=16) (actual time=2.491..2.491 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
230. 0.092 0.092 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201901_exported_status_idx on invoice_201901 i_54 (cost=0.29..2.50 rows=1 width=16) (actual time=0.644..0.644 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
231. 0.052 0.052 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201907_exported_status_idx on invoice_201907 i_60 (cost=0.29..2.50 rows=1 width=16) (actual time=0.361..0.361 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
232. 0.125 0.125 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_202001_exported_status_idx on invoice_202001 i_66 (cost=0.29..2.50 rows=1 width=16) (actual time=0.878..0.878 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
233. 0.193 0.193 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_202002_exported_status_idx on invoice_202002 i_67 (cost=0.29..1.40 rows=1 width=16) (actual time=1.350..1.350 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
234. 0.075 0.075 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201905_exported_status_idx on invoice_201905 i_58 (cost=0.29..1.40 rows=1 width=16) (actual time=0.528..0.528 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
235. 0.100 0.100 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201904_exported_status_idx on invoice_201904 i_57 (cost=0.29..1.40 rows=1 width=16) (actual time=0.699..0.700 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
236. 0.104 0.104 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201903_exported_status_idx on invoice_201903 i_56 (cost=0.29..1.40 rows=1 width=16) (actual time=0.729..0.729 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
237. 0.065 0.065 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201909_exported_status_idx on invoice_201909 i_62 (cost=0.29..1.40 rows=1 width=16) (actual time=0.453..0.454 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
238. 0.085 0.085 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201912_exported_status_idx on invoice_201912 i_65 (cost=0.29..1.40 rows=1 width=16) (actual time=0.597..0.598 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
239. 1.310 1.310 ↑ 4.1 82 7 / 7

Parallel Index Scan using invoice_202010_exported_status_idx on invoice_202010 i_75 (cost=0.28..381.11 rows=334 width=16) (actual time=0.066..1.310 rows=82 loops=7)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
240. 0.050 0.050 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201805_exported_status_idx on invoice_201805 i_46 (cost=0.28..29.11 rows=54 width=16) (actual time=0.351..0.351 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
241. 0.369 0.369 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_202008_exported_status_idx on invoice_202008 i_73 (cost=0.28..5.13 rows=10 width=16) (actual time=2.585..2.585 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
242. 0.030 0.030 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201810_exported_status_idx on invoice_201810 i_51 (cost=0.28..2.50 rows=1 width=16) (actual time=0.210..0.211 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
243. 0.066 0.066 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201812_exported_status_idx on invoice_201812 i_53 (cost=0.28..2.50 rows=1 width=16) (actual time=0.460..0.460 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
244. 0.064 0.064 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201902_exported_status_idx on invoice_201902 i_55 (cost=0.28..1.40 rows=1 width=16) (actual time=0.446..0.447 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
245. 0.120 0.120 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201809_exported_status_idx on invoice_201809 i_50 (cost=0.28..1.40 rows=1 width=16) (actual time=0.841..0.841 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
246. 0.045 0.045 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201911_exported_status_idx on invoice_201911 i_64 (cost=0.28..1.40 rows=1 width=16) (actual time=0.314..0.314 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
247. 0.039 0.039 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201906_exported_status_idx on invoice_201906 i_59 (cost=0.28..1.40 rows=1 width=16) (actual time=0.275..0.275 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
248. 0.036 0.036 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201908_exported_status_idx on invoice_201908 i_61 (cost=0.28..1.40 rows=1 width=16) (actual time=0.253..0.254 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
249. 0.088 0.088 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201806_exported_status_idx on invoice_201806 i_47 (cost=0.28..4.62 rows=10 width=16) (actual time=0.613..0.613 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
250. 0.022 0.022 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201711_source_file_idx on invoice_201711 i_41 (cost=0.28..2.59 rows=5 width=16) (actual time=0.153..0.153 rows=0 loops=1)

  • Index Cond: (source_file = 'pdf'::text)
  • Filter: (exported_status = 'AVAILABLE'::text)
  • Rows Removed by Filter: 8
251. 0.001 0.001 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201709_source_file_idx on invoice_201709 i_40 (cost=0.28..2.49 rows=1 width=16) (actual time=0.008..0.009 rows=0 loops=1)

  • Index Cond: (source_file = 'pdf'::text)
  • Filter: (exported_status = 'AVAILABLE'::text)
252. 0.001 0.001 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_201804_exported_status_idx on invoice_201804 i_45 (cost=0.27..1.39 rows=1 width=16) (actual time=0.009..0.010 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
253. 0.000 0.000 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_default_exported_status_idx on invoice_default i_77 (cost=0.14..3.48 rows=2 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
254. 0.001 0.001 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_202011_exported_status_idx on invoice_202011 i_76 (cost=0.14..2.36 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
255. 0.003 0.003 ↓ 0.0 0 1 / 7

Parallel Index Scan using invoice_167001_exported_status_idx on invoice_167001 i_39 (cost=0.14..1.25 rows=1 width=16) (actual time=0.022..0.022 rows=0 loops=1)

  • Index Cond: (exported_status = 'AVAILABLE'::text)
  • Filter: (source_file = 'pdf'::text)
256. 0.011 0.011 ↓ 0.0 0 1 / 7

Parallel Seq Scan on invoice_201801 i_43 (cost=0.00..2.19 rows=1 width=16) (actual time=0.073..0.074 rows=0 loops=1)

  • Filter: ((source_file = 'pdf'::text) AND (exported_status = 'AVAILABLE'::text))
  • Rows Removed by Filter: 21
257. 0.001 0.001 ↓ 0.0 0 1 / 7

Parallel Seq Scan on invoice_201802 i_44 (cost=0.00..1.06 rows=1 width=16) (actual time=0.010..0.010 rows=0 loops=1)

  • Filter: ((source_file = 'pdf'::text) AND (exported_status = 'AVAILABLE'::text))
  • Rows Removed by Filter: 7
258. 0.003 0.003 ↓ 0.0 0 1 / 7

Parallel Seq Scan on invoice_201712 i_42 (cost=0.00..1.04 rows=1 width=16) (actual time=0.019..0.019 rows=0 loops=1)

  • Filter: ((source_file = 'pdf'::text) AND (exported_status = 'AVAILABLE'::text))
  • Rows Removed by Filter: 5
259. 0.957 29.480 ↑ 265.1 8 670 / 7

Append (cost=0.00..64.50 rows=2,121 width=48) (actual time=0.237..0.308 rows=8 loops=670)

260. 0.096 0.096 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_167001_invoice_id_idx on invoice_line_167001 l (cost=0.00..0.40 rows=22 width=48) (actual time=0.001..0.001 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
261. 4.403 4.403 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201709_invoice_id_idx on invoice_line_201709 l_1 (cost=0.00..37.26 rows=1,947 width=48) (actual time=0.046..0.046 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
262. 0.191 0.191 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201711_invoice_id_idx on invoice_line_201711 l_2 (cost=0.00..0.09 rows=4 width=48) (actual time=0.002..0.002 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
263. 0.096 0.096 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201712_invoice_id_idx on invoice_line_201712 l_3 (cost=0.00..0.05 rows=3 width=48) (actual time=0.001..0.001 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
264. 0.096 0.096 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201801_invoice_id_idx on invoice_line_201801 l_4 (cost=0.00..0.11 rows=6 width=48) (actual time=0.001..0.001 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
265. 0.096 0.096 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201802_invoice_id_idx on invoice_line_201802 l_5 (cost=0.00..0.04 rows=2 width=48) (actual time=0.001..0.001 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
266. 0.191 0.191 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201804_invoice_id_idx on invoice_line_201804 l_6 (cost=0.00..0.08 rows=3 width=48) (actual time=0.002..0.002 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
267. 0.479 0.479 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201805_invoice_id_idx on invoice_line_201805 l_7 (cost=0.00..0.35 rows=3 width=48) (actual time=0.005..0.005 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
268. 0.287 0.287 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201806_invoice_id_idx on invoice_line_201806 l_8 (cost=0.00..0.28 rows=3 width=48) (actual time=0.003..0.003 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
269. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201807_invoice_id_idx on invoice_line_201807 l_9 (cost=0.00..0.56 rows=4 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
270. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201808_invoice_id_idx on invoice_line_201808 l_10 (cost=0.00..0.40 rows=4 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
271. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201809_invoice_id_idx on invoice_line_201809 l_11 (cost=0.00..0.32 rows=4 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
272. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201810_invoice_id_idx on invoice_line_201810 l_12 (cost=0.00..0.32 rows=4 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
273. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201811_invoice_id_idx on invoice_line_201811 l_13 (cost=0.00..0.48 rows=5 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
274. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201812_invoice_id_idx on invoice_line_201812 l_14 (cost=0.00..0.31 rows=4 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
275. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201901_invoice_id_idx on invoice_line_201901 l_15 (cost=0.00..0.51 rows=4 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
276. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201902_invoice_id_idx on invoice_line_201902 l_16 (cost=0.00..0.34 rows=4 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
277. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201903_invoice_id_idx on invoice_line_201903 l_17 (cost=0.00..0.55 rows=4 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
278. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201904_invoice_id_idx on invoice_line_201904 l_18 (cost=0.00..0.54 rows=5 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
279. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201905_invoice_id_idx on invoice_line_201905 l_19 (cost=0.00..0.41 rows=4 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
280. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201906_invoice_id_idx on invoice_line_201906 l_20 (cost=0.00..0.37 rows=4 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
281. 0.287 0.287 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201907_invoice_id_idx on invoice_line_201907 l_21 (cost=0.00..0.40 rows=4 width=48) (actual time=0.003..0.003 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
282. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201908_invoice_id_idx on invoice_line_201908 l_22 (cost=0.00..0.29 rows=4 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
283. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201909_invoice_id_idx on invoice_line_201909 l_23 (cost=0.00..0.42 rows=5 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
284. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201910_invoice_id_idx on invoice_line_201910 l_24 (cost=0.00..0.47 rows=4 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
285. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201911_invoice_id_idx on invoice_line_201911 l_25 (cost=0.00..0.35 rows=4 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
286. 0.287 0.287 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_201912_invoice_id_idx on invoice_line_201912 l_26 (cost=0.00..0.37 rows=4 width=48) (actual time=0.003..0.003 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
287. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_202001_invoice_id_idx on invoice_line_202001 l_27 (cost=0.00..0.61 rows=5 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
288. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_202002_invoice_id_idx on invoice_line_202002 l_28 (cost=0.00..0.57 rows=5 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
289. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_202003_invoice_id_idx on invoice_line_202003 l_29 (cost=0.00..0.49 rows=4 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
290. 2.297 2.297 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_202004_invoice_id_idx on invoice_line_202004 l_30 (cost=0.00..1.86 rows=7 width=48) (actual time=0.024..0.024 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
291. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_202005_invoice_id_idx on invoice_line_202005 l_31 (cost=0.00..0.65 rows=5 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
292. 0.766 0.766 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_202006_invoice_id_idx on invoice_line_202006 l_32 (cost=0.00..0.88 rows=5 width=48) (actual time=0.006..0.008 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
293. 0.861 0.861 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_202007_invoice_id_idx on invoice_line_202007 l_33 (cost=0.00..1.03 rows=6 width=48) (actual time=0.009..0.009 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
294. 0.383 0.383 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_202008_invoice_id_idx on invoice_line_202008 l_34 (cost=0.00..0.39 rows=4 width=48) (actual time=0.004..0.004 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
295. 0.670 0.670 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_202009_invoice_id_idx on invoice_line_202009 l_35 (cost=0.00..0.84 rows=5 width=48) (actual time=0.007..0.007 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
296. 9.189 9.189 ↓ 1.6 8 670 / 7

Index Scan using invoice_line_202010_invoice_id_idx on invoice_line_202010 l_36 (cost=0.00..0.46 rows=5 width=48) (actual time=0.036..0.096 rows=8 loops=670)

  • Index Cond: (invoice_id = i_69.id)
297. 0.096 0.096 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_202011_invoice_id_idx on invoice_line_202011 l_37 (cost=0.00..0.02 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
298. 0.096 0.096 ↓ 0.0 0 670 / 7

Index Scan using invoice_line_default_invoice_id_idx on invoice_line_default l_38 (cost=0.00..0.02 rows=1 width=48) (actual time=0.001..0.001 rows=0 loops=670)

  • Index Cond: (invoice_id = i_69.id)
299. 0.991 14.804 ↑ 38.0 1 5,454 / 7

Append (cost=0.00..1.10 rows=38 width=16) (actual time=0.009..0.019 rows=1 loops=5,454)

300. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_167001_id_idx on document_167001 d_38 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
301. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201711_id_idx on document_201711 d_39 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
302. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201712_id_idx on document_201712 d_40 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
303. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201801_id_idx on document_201801 d_41 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
304. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201802_id_idx on document_201802 d_42 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
305. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201804_id_idx on document_201804 d_43 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
306. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201805_id_idx on document_201805 d_44 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
307. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201806_id_idx on document_201806 d_45 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
308. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201807_id_idx on document_201807 d_46 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
309. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201808_id_idx on document_201808 d_47 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
310. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201809_id_idx on document_201809 d_48 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
311. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201810_id_idx on document_201810 d_49 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
312. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201811_id_idx on document_201811 d_50 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
313. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201812_id_idx on document_201812 d_51 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
314. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201901_id_idx on document_201901 d_52 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
315. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201902_id_idx on document_201902 d_53 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
316. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201903_id_idx on document_201903 d_54 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
317. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201904_id_idx on document_201904 d_55 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
318. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201905_id_idx on document_201905 d_56 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
319. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201906_id_idx on document_201906 d_57 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
320. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201907_id_idx on document_201907 d_58 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
321. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201908_id_idx on document_201908 d_59 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
322. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201909_id_idx on document_201909 d_60 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
323. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201910_id_idx on document_201910 d_61 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
324. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201911_id_idx on document_201911 d_62 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
325. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_201912_id_idx on document_201912 d_63 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
326. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_202001_id_idx on document_202001 d_64 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
327. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_202002_id_idx on document_202002 d_65 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
328. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_202003_id_idx on document_202003 d_66 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
329. 0.197 0.197 ↓ 0.0 0 17 / 7

Index Scan using document_202004_id_idx on document_202004 d_67 (cost=0.00..0.03 rows=1 width=16) (actual time=0.081..0.081 rows=0 loops=17)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
  • Rows Removed by Filter: 1
330. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_202005_id_idx on document_202005 d_68 (cost=0.00..0.03 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
331. 0.731 0.731 ↓ 0.0 0 256 / 7

Index Scan using document_202006_id_idx on document_202006 d_69 (cost=0.00..0.03 rows=1 width=16) (actual time=0.020..0.020 rows=0 loops=256)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
  • Rows Removed by Filter: 1
332. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_202007_id_idx on document_202007 d_70 (cost=0.00..0.03 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
333. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_202008_id_idx on document_202008 d_71 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
334. 0.341 0.341 ↑ 1.0 1 16 / 7

Index Scan using document_202009_id_idx on document_202009 d_72 (cost=0.00..0.03 rows=1 width=16) (actual time=0.124..0.149 rows=1 loops=16)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
335. 12.544 12.544 ↑ 1.0 1 5,165 / 7

Index Scan using document_202010_id_idx on document_202010 d_73 (cost=0.00..0.03 rows=1 width=16) (actual time=0.007..0.017 rows=1 loops=5,165)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
  • Rows Removed by Filter: 0
336. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_202011_id_idx on document_202011 d_74 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
337. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using document_default_id_idx on document_default d_75 (cost=0.00..0.02 rows=1 width=16) (never executed)

  • Index Cond: (id = l.document_id)
  • Filter: (((status)::text <> ALL ('{IGNORED,ERRORED}'::text[])) AND (error_status = 'VALIDATED'::text))
338. 0.379 17.679 ↑ 66.3 3 3,992 / 7

Append (cost=0.00..4.61 rows=199 width=39) (actual time=0.015..0.031 rows=3 loops=3,992)

339. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_167001_source_id_idx on classification_167001 cla (cost=0.00..0.09 rows=5 width=39) (never executed)

  • Index Cond: (source_id = l.id)
340. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201709_source_id_idx on classification_201709 cla_1 (cost=0.00..0.07 rows=3 width=38) (never executed)

  • Index Cond: (source_id = l.id)
341. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201711_source_id_idx on classification_201711 cla_2 (cost=0.00..0.05 rows=3 width=38) (never executed)

  • Index Cond: (source_id = l.id)
342. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201712_source_id_idx on classification_201712 cla_3 (cost=0.00..0.09 rows=5 width=38) (never executed)

  • Index Cond: (source_id = l.id)
343. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201801_source_id_idx on classification_201801 cla_4 (cost=0.00..0.09 rows=5 width=39) (never executed)

  • Index Cond: (source_id = l.id)
344. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201802_source_id_idx on classification_201802 cla_5 (cost=0.00..0.11 rows=6 width=39) (never executed)

  • Index Cond: (source_id = l.id)
345. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201804_source_id_idx on classification_201804 cla_6 (cost=0.00..0.11 rows=6 width=38) (never executed)

  • Index Cond: (source_id = l.id)
346. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201805_source_id_idx on classification_201805 cla_7 (cost=0.00..0.11 rows=6 width=39) (never executed)

  • Index Cond: (source_id = l.id)
347. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201806_source_id_idx on classification_201806 cla_8 (cost=0.00..0.11 rows=6 width=38) (never executed)

  • Index Cond: (source_id = l.id)
348. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201807_source_id_idx on classification_201807 cla_9 (cost=0.00..0.11 rows=6 width=39) (never executed)

  • Index Cond: (source_id = l.id)
349. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201808_source_id_idx on classification_201808 cla_10 (cost=0.00..0.11 rows=6 width=38) (never executed)

  • Index Cond: (source_id = l.id)
350. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201809_source_id_idx on classification_201809 cla_11 (cost=0.00..0.11 rows=6 width=38) (never executed)

  • Index Cond: (source_id = l.id)
351. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201810_source_id_idx on classification_201810 cla_12 (cost=0.00..0.11 rows=6 width=39) (never executed)

  • Index Cond: (source_id = l.id)
352. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201811_source_id_idx on classification_201811 cla_13 (cost=0.00..0.11 rows=6 width=38) (never executed)

  • Index Cond: (source_id = l.id)
353. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201812_source_id_idx on classification_201812 cla_14 (cost=0.00..0.11 rows=6 width=39) (never executed)

  • Index Cond: (source_id = l.id)
354. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201901_source_id_idx on classification_201901 cla_15 (cost=0.00..0.11 rows=6 width=38) (never executed)

  • Index Cond: (source_id = l.id)
355. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201902_source_id_idx on classification_201902 cla_16 (cost=0.00..0.11 rows=6 width=38) (never executed)

  • Index Cond: (source_id = l.id)
356. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201903_source_id_idx on classification_201903 cla_17 (cost=0.00..0.11 rows=6 width=38) (never executed)

  • Index Cond: (source_id = l.id)
357. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201904_source_id_idx on classification_201904 cla_18 (cost=0.00..0.11 rows=6 width=38) (never executed)

  • Index Cond: (source_id = l.id)
358. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201905_source_id_idx on classification_201905 cla_19 (cost=0.00..0.11 rows=6 width=39) (never executed)

  • Index Cond: (source_id = l.id)
359. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201906_source_id_idx on classification_201906 cla_20 (cost=0.00..0.09 rows=5 width=39) (never executed)

  • Index Cond: (source_id = l.id)
360. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201907_source_id_idx on classification_201907 cla_21 (cost=0.00..0.09 rows=5 width=39) (never executed)

  • Index Cond: (source_id = l.id)
361. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201908_source_id_idx on classification_201908 cla_22 (cost=0.00..0.09 rows=5 width=39) (never executed)

  • Index Cond: (source_id = l.id)
362. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201909_source_id_idx on classification_201909 cla_23 (cost=0.00..0.09 rows=5 width=39) (never executed)

  • Index Cond: (source_id = l.id)
363. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201910_source_id_idx on classification_201910 cla_24 (cost=0.00..0.09 rows=5 width=39) (never executed)

  • Index Cond: (source_id = l.id)
364. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201911_source_id_idx on classification_201911 cla_25 (cost=0.00..0.09 rows=5 width=39) (never executed)

  • Index Cond: (source_id = l.id)
365. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_201912_source_id_idx on classification_201912 cla_26 (cost=0.00..0.09 rows=5 width=39) (never executed)

  • Index Cond: (source_id = l.id)
366. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_202001_source_id_idx on classification_202001 cla_27 (cost=0.00..0.09 rows=5 width=39) (never executed)

  • Index Cond: (source_id = l.id)
367. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_202002_source_id_idx on classification_202002 cla_28 (cost=0.00..0.09 rows=5 width=39) (never executed)

  • Index Cond: (source_id = l.id)
368. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_202003_source_id_idx on classification_202003 cla_29 (cost=0.00..0.09 rows=5 width=39) (never executed)

  • Index Cond: (source_id = l.id)
369. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_202004_source_id_idx on classification_202004 cla_30 (cost=0.00..0.10 rows=5 width=39) (never executed)

  • Index Cond: (source_id = l.id)
370. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_202005_source_id_idx on classification_202005 cla_31 (cost=0.00..0.09 rows=5 width=39) (never executed)

  • Index Cond: (source_id = l.id)
371. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_202006_source_id_idx on classification_202006 cla_32 (cost=0.00..0.09 rows=5 width=39) (never executed)

  • Index Cond: (source_id = l.id)
372. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_202007_source_id_idx on classification_202007 cla_33 (cost=0.00..0.10 rows=5 width=39) (never executed)

  • Index Cond: (source_id = l.id)
373. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_202008_source_id_idx on classification_202008 cla_34 (cost=0.00..0.09 rows=5 width=39) (never executed)

  • Index Cond: (source_id = l.id)
374. 1.963 1.963 ↑ 1.7 3 16 / 7

Index Scan using classification_202009_source_id_idx on classification_202009 cla_35 (cost=0.00..0.10 rows=5 width=39) (actual time=0.362..0.859 rows=3 loops=16)

  • Index Cond: (source_id = l.id)
375. 15.336 15.336 ↑ 1.7 3 3,976 / 7

Index Scan using classification_202010_source_id_idx on classification_202010 cla_36 (cost=0.00..0.09 rows=5 width=39) (actual time=0.013..0.027 rows=3 loops=3,976)

  • Index Cond: (source_id = l.id)
376. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_202011_source_id_idx on classification_202011 cla_37 (cost=0.00..0.04 rows=2 width=57) (never executed)

  • Index Cond: (source_id = l.id)
377. 0.000 0.000 ↓ 0.0 0 / 7

Index Scan using classification_default_source_id_idx on classification_default cla_38 (cost=0.00..0.02 rows=1 width=39) (never executed)

  • Index Cond: (source_id = l.id)
Planning time : 60.145 ms
Execution time : 31,713.395 ms