explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DBRI : qq

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 100,603.277 ↑ 30.0 1 1

Nested Loop Left Join (cost=227,149.60..5,652,457,099.23 rows=30 width=8,944) (actual time=80,779.837..100,603.277 rows=1 loops=1)

  • Buffers: shared hit=12422547 dirtied=1
2. 0.005 100,603.204 ↑ 30.0 1 1

Nested Loop Left Join (cost=227,139.57..5,652,453,528.53 rows=30 width=7,503) (actual time=80,779.765..100,603.204 rows=1 loops=1)

  • Buffers: shared hit=12422539 dirtied=1
3. 0.006 100,603.196 ↑ 30.0 1 1

Nested Loop Left Join (cost=227,137.44..5,652,453,072.29 rows=30 width=7,491) (actual time=80,779.757..100,603.196 rows=1 loops=1)

  • Buffers: shared hit=12422539 dirtied=1
4. 0.004 100,601.686 ↑ 30.0 1 1

Merge Left Join (cost=227,107.32..5,652,452,167.65 rows=30 width=7,459) (actual time=80,778.248..100,601.686 rows=1 loops=1)

  • Merge Cond: (req.pasport_root_id = own_1.pasport_root_id)
  • Join Filter: (osp.request_id = req.request_id)
  • Buffers: shared hit=12422521 dirtied=1
5. 0.004 100,601.666 ↑ 30.0 1 1

Nested Loop Left Join (cost=225,831.22..5,652,450,891.45 rows=30 width=7,384) (actual time=80,778.229..100,601.666 rows=1 loops=1)

  • Join Filter: ((res.start_request_id = req.request_id) AND (req.pasport_root_id = res.passport_root_id))
  • Buffers: shared hit=12422520 dirtied=1
6. 0.007 100,601.649 ↑ 30.0 1 1

Nested Loop Left Join (cost=225,821.25..5,652,450,777.49 rows=30 width=7,284) (actual time=80,778.212..100,601.649 rows=1 loops=1)

  • Buffers: shared hit=12422518 dirtied=1
7. 0.004 100,601.345 ↑ 30.0 1 1

Nested Loop Left Join (cost=225,820.83..5,652,450,724.06 rows=30 width=7,226) (actual time=80,777.910..100,601.345 rows=1 loops=1)

  • Join Filter: (p.id = nsi.c_person_type_individual_id())
  • Buffers: shared hit=12422508 dirtied=1
8. 0.197 100,601.336 ↑ 30.0 1 1

Nested Loop Left Join (cost=225,820.68..5,652,450,706.71 rows=30 width=7,193) (actual time=80,777.901..100,601.336 rows=1 loops=1)

  • Join Filter: (p.id = nsi.c_person_type_legal_person_id())
  • Rows Removed by Join Filter: 1
  • Buffers: shared hit=12422507 dirtied=1
9. 0.005 100,601.135 ↑ 30.0 1 1

Nested Loop Left Join (cost=225,820.41..5,652,450,640.74 rows=30 width=7,076) (actual time=80,777.701..100,601.135 rows=1 loops=1)

  • Buffers: shared hit=12422503 dirtied=1
10. 0.006 100,600.872 ↑ 30.0 1 1

Nested Loop Left Join (cost=225,811.62..5,652,447,556.28 rows=30 width=6,867) (actual time=80,777.438..100,600.872 rows=1 loops=1)

  • Buffers: shared hit=12422475
11. 0.005 100,600.863 ↑ 30.0 1 1

Nested Loop Left Join (cost=225,809.63..5,652,447,108.69 rows=30 width=6,834) (actual time=80,777.430..100,600.863 rows=1 loops=1)

  • Buffers: shared hit=12422475
12. 0.005 100,600.528 ↑ 30.0 1 1

Nested Loop Left Join (cost=225,801.69..5,652,445,723.81 rows=30 width=6,775) (actual time=80,777.101..100,600.528 rows=1 loops=1)

  • Buffers: shared hit=12422453
13. 0.003 100,600.516 ↑ 30.0 1 1

Nested Loop Left Join (cost=225,801.41..5,652,445,714.96 rows=30 width=6,658) (actual time=80,777.090..100,600.516 rows=1 loops=1)

  • Buffers: shared hit=12422450
14. 0.005 100,600.509 ↑ 30.0 1 1

Nested Loop Left Join (cost=225,801.14..5,652,445,701.64 rows=30 width=6,549) (actual time=80,777.083..100,600.509 rows=1 loops=1)

  • Buffers: shared hit=12422447
15. 0.005 100,600.491 ↑ 30.0 1 1

Nested Loop Left Join (cost=225,800.86..5,652,445,692.72 rows=30 width=6,541) (actual time=80,777.066..100,600.491 rows=1 loops=1)

  • Buffers: shared hit=12422443
16. 0.006 100,600.479 ↑ 30.0 1 1

Nested Loop Left Join (cost=225,800.58..5,652,445,683.86 rows=30 width=6,424) (actual time=80,777.054..100,600.479 rows=1 loops=1)

  • Buffers: shared hit=12422440
17. 0.008 100,600.357 ↑ 30.0 1 1

Nested Loop Left Join (cost=225,780.43..5,652,445,078.48 rows=30 width=6,392) (actual time=80,776.933..100,600.357 rows=1 loops=1)

  • Join Filter: (pv.country_add = c_21.id)
  • Rows Removed by Join Filter: 4
  • Buffers: shared hit=12422434
18. 392.596 100,599.944 ↑ 30.0 1 1

Nested Loop (cost=225,777.47..5,652,445,036.86 rows=30 width=6,325) (actual time=80,776.626..100,599.944 rows=1 loops=1)

  • Join Filter: (req.pasport_id = pv.id)
  • Rows Removed by Join Filter: 1964528
  • Buffers: shared hit=12422415
19. 37.789 37.789 ↑ 1.0 1 1

Index Scan using fdc_request_pts_root_i on fdc_request_pts req (cost=0.43..47,943.19 rows=1 width=1,278) (actual time=37.056..37.789 rows=1 loops=1)

  • Index Cond: (request_id = '13947810'::bigint)
  • Buffers: shared hit=7969
20. 1,849.601 100,169.559 ↑ 30.0 1,964,529 1

Nested Loop Left Join (cost=225,777.04..5,651,660,883.78 rows=58,896,791 width=5,047) (actual time=3,342.097..100,169.559 rows=1,964,529 loops=1)

  • Buffers: shared hit=12414446
21. 1,341.475 59,029.378 ↑ 30.0 1,964,529 1

Hash Left Join (cost=225,767.48..5,087,135,142.05 rows=58,896,791 width=5,015) (actual time=3,342.008..59,029.378 rows=1,964,529 loops=1)

  • Hash Cond: (engine.electromachine_type_id = c_19.id)
  • Buffers: shared hit=6020881
22. 1,329.680 57,685.473 ↑ 30.0 1,964,529 1

Hash Left Join (cost=225,648.88..5,085,515,361.68 rows=58,896,791 width=5,023) (actual time=3,339.562..57,685.473 rows=1,964,529 loops=1)

  • Hash Cond: (engine.max_power_unit_id = c_20.id)
  • Buffers: shared hit=6020490
23. 1,489.637 56,355.531 ↑ 30.0 1,964,529 1

Nested Loop Left Join (cost=225,077.19..5,084,704,959.11 rows=58,896,791 width=5,024) (actual time=3,339.288..56,355.531 rows=1,964,529 loops=1)

  • Buffers: shared hit=6020480
24. 1,171.750 27,362.488 ↑ 30.0 1,964,529 1

Hash Left Join (cost=225,031.37..1,779,610.19 rows=58,896,791 width=4,905) (actual time=3,339.221..27,362.488 rows=1,964,529 loops=1)

  • Hash Cond: (pv.ts_design_name_other_id = c_18.id)
  • Buffers: shared hit=125736
25. 1,211.068 26,186.758 ↑ 30.0 1,964,529 1

Hash Left Join (cost=224,984.94..674,680.68 rows=58,896,791 width=4,913) (actual time=3,335.219..26,186.758 rows=1,964,529 loops=1)

  • Hash Cond: (pv.base_ts_trademark_id = c_14.id)
  • Buffers: shared hit=125024
26. 1,330.522 24,854.878 ↑ 4.6 1,964,529 1

Hash Left Join (cost=224,274.57..572,847.48 rows=8,988,563 width=4,905) (actual time=3,214.385..24,854.878 rows=1,964,529 loops=1)

  • Hash Cond: (pv.id = pw.pasport_id)
  • Join Filter: (((pv.type_id = ANY ('{1,2}'::bigint[])) AND ((c_15.code)::text = '12'::text)) OR ((pv.type_id = '3'::bigint) AND ((c_15.code)::text = '27'::text)))
  • Buffers: shared hit=124054
27. 1,151.306 23,522.081 ↑ 4.6 1,964,529 1

Hash Left Join (cost=223,614.43..538,452.88 rows=8,988,563 width=4,893) (actual time=3,212.101..23,522.081 rows=1,964,529 loops=1)

  • Hash Cond: (pv.ts_design_name_id = c_17.id)
  • Buffers: shared hit=124009
28. 1,219.418 22,369.424 ↑ 4.6 1,964,529 1

Hash Left Join (cost=223,611.33..504,736.12 rows=8,988,563 width=4,901) (actual time=3,210.729..22,369.424 rows=1,964,529 loops=1)

  • Hash Cond: (pv.ts_trademark_id = c_12.id)
  • Buffers: shared hit=124007
29. 1,132.398 21,028.401 ↓ 1.4 1,964,529 1

Hash Left Join (cost=222,900.97..488,583.73 rows=1,371,794 width=4,893) (actual time=3,089.104..21,028.401 rows=1,964,529 loops=1)

  • Hash Cond: (pv.manufacture_place_id = c_13.id)
  • Buffers: shared hit=123037
30. 1,085.160 19,895.887 ↓ 1.4 1,964,529 1

Hash Left Join (cost=222,898.72..483,435.56 rows=1,371,794 width=4,830) (actual time=3,088.979..19,895.887 rows=1,964,529 loops=1)

  • Hash Cond: (pv.ts_cat_id = c_10.id)
  • Buffers: shared hit=123035
31. 1,076.736 18,809.311 ↓ 1.4 1,964,529 1

Hash Left Join (cost=222,810.62..478,201.19 rows=1,371,794 width=4,808) (actual time=3,087.548..18,809.311 rows=1,964,529 loops=1)

  • Hash Cond: (pv.ecologic_class_id = c_11.id)
  • Buffers: shared hit=123033
32. 1,156.154 17,730.671 ↓ 1.4 1,964,529 1

Hash Left Join (cost=222,737.48..472,982.70 rows=1,371,794 width=4,792) (actual time=3,085.639..17,730.671 rows=1,964,529 loops=1)

  • Hash Cond: (pv.ts_cu_cat_id = c_8.id)
  • Buffers: shared hit=123031
33. 1,188.668 16,567.470 ↓ 1.4 1,964,529 1

Hash Left Join (cost=222,409.67..467,508.60 rows=1,371,794 width=4,784) (actual time=3,078.579..16,567.470 rows=1,964,529 loops=1)

  • Hash Cond: (pv.ts_cu_cat_class_id = c_9.id)
  • Buffers: shared hit=123028
34. 1,122.456 15,378.783 ↓ 1.4 1,964,529 1

Hash Left Join (cost=222,353.33..462,308.02 rows=1,371,794 width=4,792) (actual time=3,078.549..15,378.783 rows=1,964,529 loops=1)

  • Hash Cond: (pv.reason_reg_id = c_6.id)
  • Buffers: shared hit=123027
35. 1,038.678 14,255.681 ↓ 1.4 1,964,529 1

Hash Left Join (cost=222,305.00..457,113.40 rows=1,371,794 width=4,615) (actual time=3,077.897..14,255.681 rows=1,964,529 loops=1)

  • Hash Cond: (pv.extra_reg_reason_id = c_7.id)
  • Buffers: shared hit=123025
36. 1,769.276 13,215.414 ↓ 1.4 1,964,529 1

Nested Loop Left Join (cost=222,208.33..451,872.50 rows=1,371,794 width=4,055) (actual time=3,076.295..13,215.414 rows=1,964,529 loops=1)

  • Buffers: shared hit=123020
37. 2,386.183 11,446.138 ↓ 2.9 1,964,529 1

Hash Left Join (cost=222,204.16..434,711.27 rows=685,897 width=3,963) (actual time=3,076.032..11,446.138 rows=1,964,529 loops=1)

  • Hash Cond: (pv.id = sh.pasport_id)
  • Buffers: shared hit=123014
38. 1,060.056 7,298.423 ↓ 3.0 1,964,529 1

Hash Left Join (cost=81,263.20..172,098.35 rows=644,559 width=3,927) (actual time=1,307.181..7,298.423 rows=1,964,529 loops=1)

  • Hash Cond: (pv.type_id = c_2.id)
  • Buffers: shared hit=86052
39. 1,156.639 6,237.824 ↓ 3.0 1,964,529 1

Hash Left Join (cost=81,224.46..169,641.50 rows=644,559 width=3,843) (actual time=1,306.633..6,237.824 rows=1,964,529 loops=1)

  • Hash Cond: (r.visa = c_1.id)
  • Buffers: shared hit=86050
40. 3,388.364 5,073.315 ↓ 3.0 1,964,529 1

Hash Join (cost=80,318.04..164,210.70 rows=644,559 width=3,851) (actual time=1,298.715..5,073.315 rows=1,964,529 loops=1)

  • Hash Cond: (pv.root_id = r.id)
  • Buffers: shared hit=84288
41. 389.929 389.929 ↓ 1.0 1,964,555 1

Seq Scan on fdc_pts_ver pv (cost=0.00..70,195.78 rows=1,933,678 width=3,774) (actual time=0.024..389.929 rows=1,964,555 loops=1)

  • Buffers: shared hit=50859
42. 531.869 1,295.022 ↓ 2.9 1,885,049 1

Hash (cost=72,120.14..72,120.14 rows=655,832 width=85) (actual time=1,295.022..1,295.022 rows=1,885,049 loops=1)

  • Buckets: 2097152 (originally 1048576) Batches: 1 (originally 1) Memory Usage: 101723kB
  • Buffers: shared hit=33426
43. 545.174 763.153 ↓ 2.9 1,885,049 1

Hash Join (cost=1.05..72,120.14 rows=655,832 width=85) (actual time=0.037..763.153 rows=1,885,049 loops=1)

  • Hash Cond: (r.passport_type_id = c.id)
  • Buffers: shared hit=33426
44. 217.968 217.968 ↑ 1.0 1,885,075 1

Seq Scan on fdc_pts_root r (cost=0.00..53,099.96 rows=1,967,496 width=93) (actual time=0.009..217.968 rows=1,885,075 loops=1)

  • Buffers: shared hit=33425
45. 0.004 0.011 ↑ 1.0 1 1

Hash (cost=1.04..1.04 rows=1 width=8) (actual time=0.011..0.011 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
46. 0.007 0.007 ↑ 1.0 1 1

Seq Scan on fdc_passport_type c (cost=0.00..1.04 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=1)

  • Filter: ((code)::text = '1'::text)
  • Rows Removed by Filter: 2
  • Buffers: shared hit=1
47. 0.033 7.870 ↑ 1.0 236 1

Hash (cost=903.47..903.47 rows=236 width=8) (actual time=7.870..7.870 rows=236 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
  • Buffers: shared hit=1762
48. 0.046 7.837 ↑ 1.0 236 1

Hash Left Join (cost=894.51..903.47 rows=236 width=8) (actual time=7.745..7.837 rows=236 loops=1)

  • Hash Cond: (c_1.id = sl.country_id)
  • Buffers: shared hit=1762
49. 0.044 7.780 ↑ 1.0 236 1

Hash Left Join (cost=893.40..901.43 rows=236 width=8) (actual time=7.725..7.780 rows=236 loops=1)

  • Hash Cond: (c_1.user_add = usr.id)
  • Buffers: shared hit=1761
50. 0.049 0.049 ↑ 1.0 236 1

Seq Scan on fdc_country c_1 (cost=0.00..5.36 rows=236 width=16) (actual time=0.026..0.049 rows=236 loops=1)

  • Buffers: shared hit=3
51. 0.044 7.687 ↑ 6.6 320 1

Hash (cost=866.81..866.81 rows=2,127 width=8) (actual time=7.687..7.687 rows=320 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 45kB
  • Buffers: shared hit=1758
52. 0.086 7.643 ↑ 6.6 320 1

Hash Right Join (cost=434.45..866.81 rows=2,127 width=8) (actual time=7.153..7.643 rows=320 loops=1)

  • Hash Cond: (ofp.id = per.id)
  • Buffers: shared hit=1758
53. 0.185 6.187 ↑ 44.4 350 1

Hash Right Join (cost=335.68..688.47 rows=15,547 width=8) (actual time=5.776..6.187 rows=350 loops=1)

  • Hash Cond: (leg_per.person_root_id = leg_ver.person_root_id)
  • Buffers: shared hit=1726
54. 0.251 0.251 ↑ 1.1 1,379 1

Seq Scan on fdc_person leg_per (cost=0.00..67.78 rows=1,524 width=8) (actual time=0.005..0.251 rows=1,379 loops=1)

  • Filter: ((NOT is_local_copy) AND (statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Rows Removed by Filter: 976
  • Buffers: shared hit=21
55. 0.054 5.751 ↑ 6.5 350 1

Hash (cost=307.07..307.07 rows=2,289 width=16) (actual time=5.751..5.751 rows=350 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 49kB
  • Buffers: shared hit=1705
56. 0.203 5.697 ↑ 6.5 350 1

Nested Loop Left Join (cost=150.35..307.07 rows=2,289 width=16) (actual time=1.603..5.697 rows=350 loops=1)

  • Buffers: shared hit=1705
57. 0.293 1.994 ↓ 1.0 350 1

Hash Right Join (cost=150.21..221.36 rows=337 width=24) (actual time=1.565..1.994 rows=350 loops=1)

  • Hash Cond: (ind_ver.id = ofp.individual_id)
  • Buffers: shared hit=67
58. 0.149 0.149 ↓ 1.0 2,355 1

Seq Scan on fdc_person ind_ver (cost=0.00..44.39 rows=2,339 width=16) (actual time=0.005..0.149 rows=2,355 loops=1)

  • Buffers: shared hit=21
59. 0.054 1.552 ↓ 1.0 350 1

Hash (cost=146.00..146.00 rows=337 width=24) (actual time=1.552..1.552 rows=350 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 28kB
  • Buffers: shared hit=46
60. 0.268 1.498 ↓ 1.0 350 1

Hash Join (cost=89.46..146.00 rows=337 width=24) (actual time=1.097..1.498 rows=350 loops=1)

  • Hash Cond: (per_1.id = ofp.id)
  • Buffers: shared hit=46
61. 0.145 0.145 ↓ 1.0 2,355 1

Seq Scan on fdc_person per_1 (cost=0.00..44.39 rows=2,339 width=8) (actual time=0.005..0.145 rows=2,355 loops=1)

  • Buffers: shared hit=21
62. 0.048 1.085 ↓ 1.0 350 1

Hash (cost=85.25..85.25 rows=337 width=24) (actual time=1.085..1.085 rows=350 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 28kB
  • Buffers: shared hit=25
63. 0.108 1.037 ↓ 1.0 350 1

Hash Left Join (cost=73.63..85.25 rows=337 width=24) (actual time=0.896..1.037 rows=350 loops=1)

  • Hash Cond: (ofp.legal_person_id = leg_ver.id)
  • Buffers: shared hit=25
64. 0.055 0.055 ↓ 1.0 350 1

Seq Scan on fdc_official_person ofp (cost=0.00..7.37 rows=337 width=24) (actual time=0.010..0.055 rows=350 loops=1)

  • Buffers: shared hit=4
65. 0.464 0.874 ↓ 1.0 2,355 1

Hash (cost=44.39..44.39 rows=2,339 width=16) (actual time=0.874..0.874 rows=2,355 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 143kB
  • Buffers: shared hit=21
66. 0.410 0.410 ↓ 1.0 2,355 1

Seq Scan on fdc_person leg_ver (cost=0.00..44.39 rows=2,339 width=16) (actual time=0.003..0.410 rows=2,355 loops=1)

  • Buffers: shared hit=21
67. 3.500 3.500 ↑ 1.0 1 350

Index Scan using fdc_person_root_date_uk on fdc_person ind_per (cost=0.14..0.24 rows=1 width=16) (actual time=0.007..0.010 rows=1 loops=350)

  • Index Cond: (person_root_id = ind_ver.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=1638
68. 0.088 1.370 ↑ 1.0 320 1

Hash (cost=94.78..94.78 rows=320 width=16) (actual time=1.370..1.370 rows=320 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
  • Buffers: shared hit=32
69. 0.271 1.282 ↑ 1.0 320 1

Hash Right Join (cost=18.20..94.78 rows=320 width=16) (actual time=0.519..1.282 rows=320 loops=1)

  • Hash Cond: (per.person_root_id = usr.person_root_id)
  • Buffers: shared hit=32
70. 0.509 0.509 ↑ 1.1 1,379 1

Seq Scan on fdc_person per (cost=0.00..67.78 rows=1,524 width=16) (actual time=0.009..0.509 rows=1,379 loops=1)

  • Filter: ((NOT is_local_copy) AND (statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Rows Removed by Filter: 976
  • Buffers: shared hit=21
71. 0.096 0.502 ↑ 1.0 320 1

Hash (cost=14.20..14.20 rows=320 width=16) (actual time=0.502..0.502 rows=320 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 23kB
  • Buffers: shared hit=11
72. 0.406 0.406 ↑ 1.0 320 1

Seq Scan on fdc_user usr (cost=0.00..14.20 rows=320 width=16) (actual time=0.012..0.406 rows=320 loops=1)

  • Buffers: shared hit=11
73. 0.004 0.011 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=8) (actual time=0.011..0.011 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
74. 0.007 0.007 ↑ 1.0 5 1

Seq Scan on fdc_server_list sl (cost=0.00..1.05 rows=5 width=8) (actual time=0.006..0.007 rows=5 loops=1)

  • Buffers: shared hit=1
75. 0.002 0.543 ↑ 1.0 3 1

Hash (cost=38.70..38.70 rows=3 width=92) (actual time=0.543..0.543 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
76. 0.004 0.541 ↑ 1.0 3 1

Nested Loop Left Join (cost=3.87..38.70 rows=3 width=92) (actual time=0.536..0.541 rows=3 loops=1)

  • Buffers: shared hit=2
77. 0.006 0.531 ↑ 1.0 3 1

Merge Join (cost=2.30..2.36 rows=3 width=100) (actual time=0.528..0.531 rows=3 loops=1)

  • Merge Cond: (c_2.id = t.kind_id)
  • Buffers: shared hit=2
78. 0.009 0.014 ↑ 1.0 3 1

Sort (cost=1.05..1.06 rows=3 width=18) (actual time=0.014..0.014 rows=3 loops=1)

  • Sort Key: c_2.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
79. 0.005 0.005 ↑ 1.0 3 1

Seq Scan on fdc_ts_kind c_2 (cost=0.00..1.03 rows=3 width=18) (actual time=0.005..0.005 rows=3 loops=1)

  • Buffers: shared hit=1
80. 0.005 0.511 ↑ 1.0 3 1

Sort (cost=1.25..1.26 rows=3 width=90) (actual time=0.511..0.511 rows=3 loops=1)

  • Sort Key: t.kind_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
81. 0.506 0.506 ↑ 1.0 3 1

Seq Scan on fdc_ts_kind_translation t (cost=0.00..1.23 rows=3 width=90) (actual time=0.101..0.506 rows=3 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 12
  • Buffers: shared hit=1
82. 0.000 0.006 ↓ 0.0 0 3

Nested Loop Left Join (cost=1.57..12.04 rows=7 width=8) (actual time=0.002..0.002 rows=0 loops=3)

83. 0.003 0.006 ↓ 0.0 0 3

Nested Loop Left Join (cost=0.29..7.54 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=3)

84. 0.003 0.003 ↓ 0.0 0 3

Index Scan using fdc_user_pk on fdc_user usr_1 (cost=0.15..6.83 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=3)

  • Index Cond: (c_2.user_add = id)
85. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_2 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_1.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
86. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

87. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

88. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

89. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

90. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

91. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_1 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_2.id)
92. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_3 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_1.id)
  • Heap Fetches: 0
93. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_1 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_1.individual_id)
94. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_1 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_1.legal_person_id)
95. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_1 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_1.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
96. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_1 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_1.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
97. 571.034 1,761.532 ↑ 1.0 1,964,536 1

Hash (cost=115,219.79..115,219.79 rows=2,057,693 width=44) (actual time=1,761.532..1,761.532 rows=1,964,536 loops=1)

  • Buckets: 2097152 Batches: 1 Memory Usage: 197459kB
  • Buffers: shared hit=36962
98. 380.038 1,190.498 ↑ 1.0 1,964,536 1

Hash Left Join (cost=96.60..115,219.79 rows=2,057,693 width=44) (actual time=1.811..1,190.498 rows=1,964,536 loops=1)

  • Hash Cond: (sh.reason_id = c_4.id)
  • Buffers: shared hit=36962
99. 470.787 810.433 ↑ 1.0 1,964,536 1

Hash Join (cost=93.82..107,500.66 rows=2,057,693 width=52) (actual time=1.778..810.433 rows=1,964,536 loops=1)

  • Hash Cond: (sh.status_id = c_3.id)
  • Buffers: shared hit=36960
100. 337.893 337.893 ↑ 1.0 1,964,536 1

Seq Scan on fdc_pts_status_history sh (cost=0.00..79,113.56 rows=2,057,693 width=24) (actual time=0.015..337.893 rows=1,964,536 loops=1)

  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Rows Removed by Filter: 44345
  • Buffers: shared hit=36958
101. 0.004 1.753 ↑ 1.0 10 1

Hash (cost=93.69..93.69 rows=10 width=36) (actual time=1.753..1.753 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
102. 0.008 1.749 ↑ 1.0 10 1

Nested Loop Left Join (cost=2.79..93.69 rows=10 width=36) (actual time=0.085..1.749 rows=10 loops=1)

  • Buffers: shared hit=2
103. 0.013 1.731 ↑ 1.0 10 1

Hash Right Join (cost=1.23..3.24 rows=10 width=44) (actual time=0.078..1.731 rows=10 loops=1)

  • Hash Cond: (t_1.status_id = c_3.id)
  • Buffers: shared hit=2
104. 1.707 1.707 ↑ 1.0 10 1

Seq Scan on fdc_status_pts_translation t_1 (cost=0.00..1.90 rows=10 width=33) (actual time=0.060..1.707 rows=10 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 50
  • Buffers: shared hit=1
105. 0.004 0.011 ↑ 1.0 10 1

Hash (cost=1.10..1.10 rows=10 width=19) (actual time=0.011..0.011 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
106. 0.007 0.007 ↑ 1.0 10 1

Seq Scan on fdc_status_pts c_3 (cost=0.00..1.10 rows=10 width=19) (actual time=0.005..0.007 rows=10 loops=1)

  • Buffers: shared hit=1
107. 0.000 0.010 ↓ 0.0 0 10

Nested Loop Left Join (cost=1.57..8.98 rows=7 width=8) (actual time=0.001..0.001 rows=0 loops=10)

108. 0.010 0.010 ↓ 0.0 0 10

Nested Loop Left Join (cost=0.29..4.47 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=10)

109. 0.000 0.000 ↓ 0.0 0 10

Index Scan using fdc_user_pk on fdc_user usr_2 (cost=0.15..3.76 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=10)

  • Index Cond: (c_3.user_add = id)
110. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_4 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_2.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
111. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

112. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

113. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

114. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

115. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

116. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_2 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_4.id)
117. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_5 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_2.id)
  • Heap Fetches: 0
118. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_2 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_2.individual_id)
119. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_2 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_2.legal_person_id)
120. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_2 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_2.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
121. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_2 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_2.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
122. 0.004 0.027 ↑ 1.0 22 1

Hash (cost=2.50..2.50 rows=22 width=8) (actual time=0.027..0.027 rows=22 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
123. 0.009 0.023 ↑ 1.0 22 1

Hash Join (cost=1.07..2.50 rows=22 width=8) (actual time=0.016..0.023 rows=22 loops=1)

  • Hash Cond: (c_4.object_type_id = c_5.id)
  • Buffers: shared hit=2
124. 0.007 0.007 ↑ 1.0 22 1

Seq Scan on fdc_change_status_reason c_4 (cost=0.00..1.22 rows=22 width=16) (actual time=0.006..0.007 rows=22 loops=1)

  • Buffers: shared hit=1
125. 0.002 0.007 ↑ 1.0 3 1

Hash (cost=1.03..1.03 rows=3 width=8) (actual time=0.007..0.007 rows=3 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
126. 0.005 0.005 ↑ 1.0 3 1

Seq Scan on fdc_object_type c_5 (cost=0.00..1.03 rows=3 width=8) (actual time=0.004..0.005 rows=3 loops=1)

  • Buffers: shared hit=1
127. 0.000 0.000 ↑ 2.0 1 1,964,529

Materialize (cost=4.18..13.81 rows=2 width=92) (actual time=0.000..0.000 rows=1 loops=1,964,529)

  • Buffers: shared hit=6
128. 0.016 0.257 ↑ 2.0 1 1

Bitmap Heap Scan on fdc_translate_messages m (cost=4.18..13.80 rows=2 width=92) (actual time=0.256..0.257 rows=1 loops=1)

  • Recheck Cond: (((code)::text = 'SYS.IS_MISSING'::text) AND (languages_id = lang.get_current_lang_id()))
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Rows Removed by Filter: 5
  • Heap Blocks: exact=3
  • Buffers: shared hit=6
129. 0.241 0.241 ↓ 2.0 6 1

Bitmap Index Scan on fdc_translate_messages_code_date_uk (cost=0.00..4.18 rows=3 width=0) (actual time=0.241..0.241 rows=6 loops=1)

  • Index Cond: (((code)::text = 'SYS.IS_MISSING'::text) AND (languages_id = lang.get_current_lang_id()))
  • Buffers: shared hit=3
130. 0.013 1.589 ↑ 1.0 10 1

Hash (cost=96.54..96.54 rows=10 width=568) (actual time=1.589..1.589 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
  • Buffers: shared hit=5
131. 0.009 1.576 ↑ 1.0 10 1

Nested Loop Left Join (cost=2.79..96.54 rows=10 width=568) (actual time=0.153..1.576 rows=10 loops=1)

  • Buffers: shared hit=5
132. 0.010 1.547 ↑ 1.0 10 1

Hash Join (cost=1.23..6.09 rows=10 width=576) (actual time=0.140..1.547 rows=10 loops=1)

  • Hash Cond: (t_3.reg_reason_id = c_7.id)
  • Buffers: shared hit=5
133. 1.522 1.522 ↑ 1.0 10 1

Seq Scan on fdc_pts_extra_reg_reason_translation t_3 (cost=0.00..4.75 rows=10 width=566) (actual time=0.120..1.522 rows=10 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 40
  • Buffers: shared hit=4
134. 0.008 0.015 ↑ 1.0 10 1

Hash (cost=1.10..1.10 rows=10 width=18) (actual time=0.015..0.015 rows=10 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
135. 0.007 0.007 ↑ 1.0 10 1

Seq Scan on fdc_pts_extra_reg_reason c_7 (cost=0.00..1.10 rows=10 width=18) (actual time=0.006..0.007 rows=10 loops=1)

  • Buffers: shared hit=1
136. 0.010 0.020 ↓ 0.0 0 10

Nested Loop Left Join (cost=1.57..8.98 rows=7 width=8) (actual time=0.002..0.002 rows=0 loops=10)

137. 0.000 0.010 ↓ 0.0 0 10

Nested Loop Left Join (cost=0.29..4.47 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=10)

138. 0.010 0.010 ↓ 0.0 0 10

Index Scan using fdc_user_pk on fdc_user usr_4 (cost=0.15..3.76 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=10)

  • Index Cond: (c_7.user_add = id)
139. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_8 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_4.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
140. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

141. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

142. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

143. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

144. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

145. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_4 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_8.id)
146. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_9 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_4.id)
  • Heap Fetches: 0
147. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_4 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_4.individual_id)
148. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_4 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_4.legal_person_id)
149. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_4 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_4.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
150. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_4 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_4.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
151. 0.002 0.646 ↑ 1.0 4 1

Hash (cost=48.28..48.28 rows=4 width=185) (actual time=0.646..0.646 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
152. 0.004 0.644 ↑ 1.0 4 1

Nested Loop Left Join (cost=3.99..48.28 rows=4 width=185) (actual time=0.636..0.644 rows=4 loops=1)

  • Buffers: shared hit=2
153. 0.008 0.636 ↑ 1.0 4 1

Merge Join (cost=2.42..2.50 rows=4 width=193) (actual time=0.631..0.636 rows=4 loops=1)

  • Merge Cond: (c_6.id = t_2.reg_reason_id)
  • Buffers: shared hit=2
154. 0.012 0.018 ↑ 1.0 4 1

Sort (cost=1.08..1.09 rows=4 width=19) (actual time=0.017..0.018 rows=4 loops=1)

  • Sort Key: c_6.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
155. 0.006 0.006 ↑ 1.0 4 1

Seq Scan on fdc_pts_reg_reason c_6 (cost=0.00..1.04 rows=4 width=19) (actual time=0.005..0.006 rows=4 loops=1)

  • Buffers: shared hit=1
156. 0.011 0.610 ↑ 1.0 4 1

Sort (cost=1.34..1.35 rows=4 width=182) (actual time=0.609..0.610 rows=4 loops=1)

  • Sort Key: t_2.reg_reason_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
157. 0.599 0.599 ↑ 1.0 4 1

Seq Scan on fdc_pts_reg_reason_translation t_2 (cost=0.00..1.30 rows=4 width=182) (actual time=0.058..0.599 rows=4 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 16
  • Buffers: shared hit=1
158. 0.000 0.004 ↓ 0.0 0 4

Nested Loop Left Join (cost=1.57..11.38 rows=7 width=8) (actual time=0.001..0.001 rows=0 loops=4)

159. 0.004 0.004 ↓ 0.0 0 4

Nested Loop Left Join (cost=0.29..6.87 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=4)

160. 0.000 0.000 ↓ 0.0 0 4

Index Scan using fdc_user_pk on fdc_user usr_3 (cost=0.15..6.17 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=4)

  • Index Cond: (c_6.user_add = id)
161. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_6 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_3.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
162. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

163. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

164. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

165. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

166. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

167. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_3 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_6.id)
168. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_7 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_3.id)
  • Heap Fetches: 0
169. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_3 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_3.individual_id)
170. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_3 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_3.legal_person_id)
171. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_3 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_3.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
172. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_3 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_3.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
173. 0.004 0.019 ↑ 1.0 5 1

Hash (cost=56.28..56.28 rows=5 width=8) (actual time=0.019..0.019 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
174. 0.005 0.015 ↑ 1.0 5 1

Nested Loop Left Join (cost=1.57..56.28 rows=5 width=8) (actual time=0.012..0.015 rows=5 loops=1)

  • Buffers: shared hit=1
175. 0.005 0.005 ↑ 1.0 5 1

Seq Scan on fdc_ts_cu_cat_class c_9 (cost=0.00..1.05 rows=5 width=16) (actual time=0.005..0.005 rows=5 loops=1)

  • Buffers: shared hit=1
176. 0.000 0.005 ↓ 0.0 0 5

Nested Loop Left Join (cost=1.57..10.98 rows=7 width=8) (actual time=0.001..0.001 rows=0 loops=5)

177. 0.000 0.005 ↓ 0.0 0 5

Nested Loop Left Join (cost=0.29..6.47 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=5)

178. 0.005 0.005 ↓ 0.0 0 5

Index Scan using fdc_user_pk on fdc_user usr_6 (cost=0.15..5.76 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=5)

  • Index Cond: (c_9.user_add = id)
179. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_12 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_6.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
180. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

181. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

182. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

183. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

184. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

185. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_6 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_12.id)
186. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_13 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_6.id)
  • Heap Fetches: 0
187. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_6 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_6.individual_id)
188. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_6 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_6.legal_person_id)
189. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_6 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_6.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
190. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_6 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_6.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
191. 0.019 7.047 ↑ 1.0 49 1

Hash (cost=327.20..327.20 rows=49 width=16) (actual time=7.047..7.047 rows=49 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=3
192. 0.013 7.028 ↑ 1.0 49 1

Nested Loop Left Join (cost=3.67..327.20 rows=49 width=16) (actual time=0.103..7.028 rows=49 loops=1)

  • Buffers: shared hit=3
193. 0.025 6.966 ↑ 1.0 49 1

Hash Join (cost=2.10..8.39 rows=49 width=24) (actual time=0.095..6.966 rows=49 loops=1)

  • Hash Cond: (t_4.ts_cat_id = c_8.id)
  • Buffers: shared hit=3
194. 6.914 6.914 ↑ 1.0 49 1

Seq Scan on fdc_ts_cu_cat_translation t_4 (cost=0.00..5.67 rows=49 width=11) (actual time=0.064..6.914 rows=49 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 196
  • Buffers: shared hit=2
195. 0.012 0.027 ↑ 1.0 49 1

Hash (cost=1.49..1.49 rows=49 width=21) (actual time=0.027..0.027 rows=49 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 11kB
  • Buffers: shared hit=1
196. 0.015 0.015 ↑ 1.0 49 1

Seq Scan on fdc_ts_cu_cat c_8 (cost=0.00..1.49 rows=49 width=21) (actual time=0.008..0.015 rows=49 loops=1)

  • Buffers: shared hit=1
197. 0.049 0.049 ↓ 0.0 0 49

Nested Loop Left Join (cost=1.57..6.44 rows=7 width=8) (actual time=0.001..0.001 rows=0 loops=49)

198. 0.000 0.000 ↓ 0.0 0 49

Nested Loop Left Join (cost=0.29..1.93 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=49)

199. 0.000 0.000 ↓ 0.0 0 49

Index Scan using fdc_user_pk on fdc_user usr_5 (cost=0.15..1.23 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=49)

  • Index Cond: (c_8.user_add = id)
200. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_10 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_5.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
201. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

202. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

203. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

204. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

205. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

206. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_5 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_10.id)
207. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_11 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_5.id)
  • Heap Fetches: 0
208. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_5 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_5.individual_id)
209. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_5 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_5.legal_person_id)
210. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_5 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_5.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
211. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_5 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_5.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
212. 0.005 1.904 ↑ 1.0 7 1

Hash (cost=73.05..73.05 rows=7 width=24) (actual time=1.904..1.904 rows=7 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
213. 0.008 1.899 ↑ 1.0 7 1

Nested Loop Left Join (cost=4.36..73.05 rows=7 width=24) (actual time=1.883..1.899 rows=7 loops=1)

  • Buffers: shared hit=2
214. 0.011 1.877 ↑ 1.0 7 1

Merge Join (cost=2.79..2.93 rows=7 width=32) (actual time=1.870..1.877 rows=7 loops=1)

  • Merge Cond: (c_11.id = t_6.ecolog_class_id)
  • Buffers: shared hit=2
215. 0.010 0.017 ↑ 1.0 7 1

Sort (cost=1.17..1.19 rows=7 width=19) (actual time=0.016..0.017 rows=7 loops=1)

  • Sort Key: c_11.id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
216. 0.007 0.007 ↑ 1.0 7 1

Seq Scan on fdc_ecolog_class c_11 (cost=0.00..1.07 rows=7 width=19) (actual time=0.007..0.007 rows=7 loops=1)

  • Buffers: shared hit=1
217. 0.009 1.849 ↑ 1.0 7 1

Sort (cost=1.62..1.64 rows=7 width=21) (actual time=1.849..1.849 rows=7 loops=1)

  • Sort Key: t_6.ecolog_class_id
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
218. 1.840 1.840 ↑ 1.0 7 1

Seq Scan on fdc_ecolog_class_translation t_6 (cost=0.00..1.52 rows=7 width=21) (actual time=0.054..1.840 rows=7 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 28
  • Buffers: shared hit=1
219. 0.007 0.014 ↓ 0.0 0 7

Nested Loop Left Join (cost=1.57..9.95 rows=7 width=8) (actual time=0.002..0.002 rows=0 loops=7)

220. 0.000 0.007 ↓ 0.0 0 7

Nested Loop Left Join (cost=0.29..5.44 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=7)

221. 0.007 0.007 ↓ 0.0 0 7

Index Scan using fdc_user_pk on fdc_user usr_8 (cost=0.15..4.74 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=7)

  • Index Cond: (c_11.user_add = id)
222. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_16 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_8.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
223. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

224. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

225. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

226. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

227. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

228. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_8 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_16.id)
229. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_17 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_8.id)
  • Heap Fetches: 0
230. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_8 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_8.individual_id)
231. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_8 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_8.legal_person_id)
232. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_8 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_8.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
233. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_8 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_8.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
234. 0.005 1.416 ↑ 1.0 9 1

Hash (cost=87.99..87.99 rows=9 width=30) (actual time=1.416..1.416 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
235. 0.011 1.411 ↑ 1.0 9 1

Nested Loop Left Join (cost=2.77..87.99 rows=9 width=30) (actual time=0.128..1.411 rows=9 loops=1)

  • Buffers: shared hit=2
236. 0.011 1.391 ↑ 1.0 9 1

Hash Join (cost=1.20..2.98 rows=9 width=38) (actual time=0.117..1.391 rows=9 loops=1)

  • Hash Cond: (t_5.ts_cat_id = c_10.id)
  • Buffers: shared hit=2
237. 1.364 1.364 ↑ 1.0 9 1

Seq Scan on fdc_ts_cat_translation t_5 (cost=0.00..1.67 rows=9 width=28) (actual time=0.095..1.364 rows=9 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 36
  • Buffers: shared hit=1
238. 0.006 0.016 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=18) (actual time=0.016..0.016 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
239. 0.010 0.010 ↑ 1.0 9 1

Seq Scan on fdc_ts_cat c_10 (cost=0.00..1.09 rows=9 width=18) (actual time=0.007..0.010 rows=9 loops=1)

  • Buffers: shared hit=1
240. 0.000 0.009 ↓ 0.0 0 9

Nested Loop Left Join (cost=1.57..9.38 rows=7 width=8) (actual time=0.001..0.001 rows=0 loops=9)

241. 0.000 0.009 ↓ 0.0 0 9

Nested Loop Left Join (cost=0.29..4.87 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=9)

242. 0.009 0.009 ↓ 0.0 0 9

Index Scan using fdc_user_pk on fdc_user usr_7 (cost=0.15..4.17 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=9)

  • Index Cond: (c_10.user_add = id)
243. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_14 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_7.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
244. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

245. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

246. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

247. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

248. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

249. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_7 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_14.id)
250. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_15 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_7.id)
  • Heap Fetches: 0
251. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_7 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_7.individual_id)
252. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_7 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_7.legal_person_id)
253. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_7 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_7.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
254. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_7 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_7.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
255. 0.001 0.116 ↑ 1.0 2 1

Hash (cost=2.22..2.22 rows=2 width=71) (actual time=0.116..0.116 rows=2 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
256. 0.004 0.115 ↑ 1.0 2 1

Nested Loop Left Join (cost=0.00..2.22 rows=2 width=71) (actual time=0.070..0.115 rows=2 loops=1)

  • Join Filter: (c_13.id = t_8.place_id)
  • Rows Removed by Join Filter: 1
  • Buffers: shared hit=2
257. 0.007 0.007 ↑ 1.0 2 1

Seq Scan on fdc_manufacture_place c_13 (cost=0.00..1.02 rows=2 width=10) (actual time=0.007..0.007 rows=2 loops=1)

  • Buffers: shared hit=1
258. 0.003 0.104 ↑ 1.0 2 2

Materialize (cost=0.00..1.16 rows=2 width=69) (actual time=0.030..0.052 rows=2 loops=2)

  • Buffers: shared hit=1
259. 0.101 0.101 ↑ 1.0 2 1

Seq Scan on fdc_manufacture_place_translation t_8 (cost=0.00..1.15 rows=2 width=69) (actual time=0.058..0.101 rows=2 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Buffers: shared hit=1
260. 0.182 121.605 ↑ 6.6 849 1

Hash (cost=640.83..640.83 rows=5,563 width=16) (actual time=121.605..121.605 rows=849 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 105kB
  • Buffers: shared hit=970
261. 0.170 121.423 ↑ 6.6 849 1

Merge Right Join (cost=316.24..640.83 rows=5,563 width=16) (actual time=120.105..121.423 rows=849 loops=1)

  • Merge Cond: (usr_9.id = c_12.user_add)
  • Buffers: shared hit=970
262. 0.020 1.517 ↑ 40.9 52 1

Nested Loop Left Join (cost=1.57..1,723.21 rows=2,127 width=8) (actual time=0.202..1.517 rows=52 loops=1)

  • Buffers: shared hit=825
263. 0.037 0.509 ↑ 6.2 52 1

Nested Loop Left Join (cost=0.29..282.37 rows=320 width=16) (actual time=0.062..0.509 rows=52 loops=1)

  • Buffers: shared hit=188
264. 0.056 0.056 ↑ 6.2 52 1

Index Scan using fdc_user_pk on fdc_user usr_9 (cost=0.15..55.97 rows=320 width=16) (actual time=0.016..0.056 rows=52 loops=1)

  • Buffers: shared hit=33
265. 0.416 0.416 ↑ 1.0 1 52

Index Scan using fdc_person_root_date_uk on fdc_person per_18 (cost=0.14..0.70 rows=1 width=16) (actual time=0.004..0.008 rows=1 loops=52)

  • Index Cond: (person_root_id = usr_9.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Buffers: shared hit=155
266. 0.015 0.988 ↑ 48.0 1 52

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (actual time=0.013..0.019 rows=1 loops=52)

  • Buffers: shared hit=637
267. 0.040 0.676 ↑ 7.0 1 52

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (actual time=0.009..0.013 rows=1 loops=52)

  • Buffers: shared hit=413
268. 0.050 0.312 ↑ 1.0 1 52

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (actual time=0.006..0.006 rows=1 loops=52)

  • Buffers: shared hit=275
269. 0.025 0.208 ↑ 1.0 1 52

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=52)

  • Buffers: shared hit=194
270. 0.023 0.156 ↑ 1.0 1 52

Nested Loop (cost=0.43..0.68 rows=1 width=24) (actual time=0.003..0.003 rows=1 loops=52)

  • Buffers: shared hit=113
271. 0.052 0.052 ↑ 1.0 1 52

Index Scan using fdc_official_person_pk on fdc_official_person ofp_9 (cost=0.15..0.18 rows=1 width=24) (actual time=0.001..0.001 rows=1 loops=52)

  • Index Cond: (id = per_18.id)
  • Buffers: shared hit=58
272. 0.081 0.081 ↑ 1.0 1 27

Index Only Scan using fdc_person_pk on fdc_person per_19 (cost=0.28..0.50 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=27)

  • Index Cond: (id = ofp_9.id)
  • Heap Fetches: 0
  • Buffers: shared hit=55
273. 0.027 0.027 ↑ 1.0 1 27

Index Scan using fdc_person_pk on fdc_person ind_ver_9 (cost=0.28..0.65 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=27)

  • Index Cond: (id = ofp_9.individual_id)
  • Buffers: shared hit=81
274. 0.054 0.054 ↑ 1.0 1 27

Index Scan using fdc_person_pk on fdc_person leg_ver_9 (cost=0.28..0.65 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=27)

  • Index Cond: (id = ofp_9.legal_person_id)
  • Buffers: shared hit=81
275. 0.324 0.324 ↑ 1.0 1 27

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_9 (cost=0.14..0.24 rows=1 width=16) (actual time=0.005..0.012 rows=1 loops=27)

  • Index Cond: (person_root_id = ind_ver_9.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=138
276. 0.297 0.297 ↑ 1.0 1 27

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_9 (cost=0.14..0.24 rows=1 width=8) (actual time=0.008..0.011 rows=1 loops=27)

  • Index Cond: (person_root_id = leg_ver_9.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Rows Removed by Filter: 8
  • Buffers: shared hit=224
277. 0.344 119.736 ↑ 1.0 849 1

Sort (cost=279.76..281.88 rows=849 width=24) (actual time=119.692..119.736 rows=849 loops=1)

  • Sort Key: c_12.user_add
  • Sort Method: quicksort Memory: 91kB
  • Buffers: shared hit=145
278. 0.534 119.392 ↑ 1.0 849 1

Hash Join (cost=31.10..238.46 rows=849 width=24) (actual time=0.506..119.392 rows=849 loops=1)

  • Hash Cond: (t_7.trademark_id = c_12.id)
  • Buffers: shared hit=145
279. 118.592 118.592 ↑ 1.0 849 1

Seq Scan on fdc_ts_trademark_translation t_7 (cost=0.00..196.64 rows=849 width=16) (actual time=0.233..118.592 rows=849 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 3394
  • Buffers: shared hit=133
280. 0.110 0.266 ↑ 1.0 849 1

Hash (cost=20.49..20.49 rows=849 width=16) (actual time=0.266..0.266 rows=849 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 48kB
  • Buffers: shared hit=12
281. 0.156 0.156 ↑ 1.0 849 1

Seq Scan on fdc_ts_trademark c_12 (cost=0.00..20.49 rows=849 width=16) (actual time=0.008..0.156 rows=849 loops=1)

  • Buffers: shared hit=12
282. 0.004 1.351 ↑ 1.0 9 1

Hash (cost=2.98..2.98 rows=9 width=8) (actual time=1.351..1.351 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
283. 0.008 1.347 ↑ 1.0 9 1

Hash Join (cost=1.20..2.98 rows=9 width=8) (actual time=0.097..1.347 rows=9 loops=1)

  • Hash Cond: (t_12.special_equipment_id = c_17.id)
  • Buffers: shared hit=2
284. 1.320 1.320 ↑ 1.0 9 1

Seq Scan on fdc_special_equipment_translation t_12 (cost=0.00..1.67 rows=9 width=8) (actual time=0.074..1.320 rows=9 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 36
  • Buffers: shared hit=1
285. 0.012 0.019 ↑ 1.0 9 1

Hash (cost=1.09..1.09 rows=9 width=8) (actual time=0.019..0.019 rows=9 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
286. 0.007 0.007 ↑ 1.0 9 1

Seq Scan on fdc_special_equipment c_17 (cost=0.00..1.09 rows=9 width=8) (actual time=0.006..0.007 rows=9 loops=1)

  • Buffers: shared hit=1
287. 0.070 2.275 ↓ 1.4 410 1

Hash (cost=656.47..656.47 rows=294 width=23) (actual time=2.275..2.275 rows=410 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 30kB
  • Buffers: shared hit=45
288. 0.097 2.205 ↓ 1.4 410 1

Hash Left Join (cost=573.54..656.47 rows=294 width=23) (actual time=1.294..2.205 rows=410 loops=1)

  • Hash Cond: (pw.measure_unit_id = c_16.id)
  • Buffers: shared hit=45
289. 0.069 1.849 ↓ 1.4 410 1

Nested Loop (cost=1.85..80.74 rows=294 width=24) (actual time=1.030..1.849 rows=410 loops=1)

  • Join Filter: (c_15.id = pw.weight_type_id)
  • Buffers: shared hit=35
290. 0.006 1.634 ↑ 1.0 2 1

Nested Loop (cost=1.57..31.22 rows=2 width=19) (actual time=1.013..1.634 rows=2 loops=1)

  • Join Filter: (c_15.id = t_10.weight_type_id)
  • Rows Removed by Join Filter: 20
  • Buffers: shared hit=3
291. 1.606 1.606 ↑ 1.0 11 1

Seq Scan on fdc_weight_type_translation t_10 (cost=0.00..2.83 rows=11 width=8) (actual time=0.394..1.606 rows=11 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 44
  • Buffers: shared hit=2
292. 0.007 0.022 ↑ 1.0 2 11

Materialize (cost=1.57..28.07 rows=2 width=11) (actual time=0.001..0.002 rows=2 loops=11)

  • Buffers: shared hit=1
293. 0.003 0.015 ↑ 1.0 2 1

Nested Loop Left Join (cost=1.57..28.06 rows=2 width=11) (actual time=0.013..0.015 rows=2 loops=1)

  • Buffers: shared hit=1
294. 0.008 0.008 ↑ 1.0 2 1

Seq Scan on fdc_weight_type c_15 (cost=0.00..1.17 rows=2 width=19) (actual time=0.007..0.008 rows=2 loops=1)

  • Filter: (((code)::text = '12'::text) OR ((code)::text = '27'::text))
  • Rows Removed by Filter: 9
  • Buffers: shared hit=1
295. 0.000 0.004 ↓ 0.0 0 2

Nested Loop Left Join (cost=1.57..13.38 rows=7 width=8) (actual time=0.002..0.002 rows=0 loops=2)

296. 0.002 0.004 ↓ 0.0 0 2

Nested Loop Left Join (cost=0.29..8.87 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=2)

297. 0.002 0.002 ↓ 0.0 0 2

Index Scan using fdc_user_pk on fdc_user usr_11 (cost=0.15..8.17 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=2)

  • Index Cond: (c_15.user_add = id)
298. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_22 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_11.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
299. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

300. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

301. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

302. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

303. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

304. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_11 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_22.id)
305. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_23 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_11.id)
  • Heap Fetches: 0
306. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_11 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_11.individual_id)
307. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_11 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_11.legal_person_id)
308. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_11 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_11.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
309. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_11 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_11.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
310. 0.146 0.146 ↑ 2.0 205 2

Index Scan using fdc_pts_weight_type_i on fdc_pts_weight pw (cost=0.28..19.71 rows=404 width=29) (actual time=0.009..0.073 rows=205 loops=2)

  • Index Cond: (weight_type_id = t_10.weight_type_id)
  • Buffers: shared hit=32
311. 0.015 0.259 ↑ 1.0 92 1

Hash (cost=570.54..570.54 rows=92 width=15) (actual time=0.259..0.259 rows=92 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
  • Buffers: shared hit=10
312. 0.072 0.244 ↑ 1.0 92 1

Nested Loop Left Join (cost=10.63..570.54 rows=92 width=15) (actual time=0.136..0.244 rows=92 loops=1)

  • Buffers: shared hit=10
313. 0.035 0.172 ↑ 1.0 92 1

Hash Join (cost=9.06..17.59 rows=92 width=23) (actual time=0.128..0.172 rows=92 loops=1)

  • Hash Cond: (t_11.measure_unit_id = c_16.id)
  • Buffers: shared hit=10
314. 0.036 0.099 ↑ 1.0 92 1

Bitmap Heap Scan on fdc_measure_unit_translation t_11 (cost=4.99..12.37 rows=92 width=15) (actual time=0.078..0.099 rows=92 loops=1)

  • Recheck Cond: (language_id = lang.get_current_lang_id())
  • Heap Blocks: exact=6
  • Buffers: shared hit=8
315. 0.063 0.063 ↑ 1.0 92 1

Bitmap Index Scan on fdc_measure_unit_translation_l_i (cost=0.00..4.97 rows=92 width=0) (actual time=0.063..0.063 rows=92 loops=1)

  • Index Cond: (language_id = lang.get_current_lang_id())
  • Buffers: shared hit=2
316. 0.014 0.038 ↑ 1.0 92 1

Hash (cost=2.92..2.92 rows=92 width=16) (actual time=0.038..0.038 rows=92 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared hit=2
317. 0.024 0.024 ↑ 1.0 92 1

Seq Scan on fdc_measure_unit c_16 (cost=0.00..2.92 rows=92 width=16) (actual time=0.008..0.024 rows=92 loops=1)

  • Buffers: shared hit=2
318. 0.000 0.000 ↓ 0.0 0 92

Nested Loop Left Join (cost=1.57..5.94 rows=7 width=8) (actual time=0.000..0.000 rows=0 loops=92)

319. 0.000 0.000 ↓ 0.0 0 92

Nested Loop Left Join (cost=0.29..1.44 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=92)

320. 0.000 0.000 ↓ 0.0 0 92

Index Scan using fdc_user_pk on fdc_user usr_12 (cost=0.15..0.73 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=92)

  • Index Cond: (c_16.user_add = id)
321. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_24 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_12.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
322. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

323. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

324. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

325. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

326. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

327. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_12 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_24.id)
328. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_25 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_12.id)
  • Heap Fetches: 0
329. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_12 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_12.individual_id)
330. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_12 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_12.legal_person_id)
331. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_12 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_12.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
332. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_12 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_12.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
333. 0.189 120.812 ↑ 6.6 849 1

Hash (cost=640.83..640.83 rows=5,563 width=16) (actual time=120.812..120.812 rows=849 loops=1)

  • Buckets: 8192 Batches: 1 Memory Usage: 105kB
  • Buffers: shared hit=970
334. 0.167 120.623 ↑ 6.6 849 1

Merge Right Join (cost=316.24..640.83 rows=5,563 width=16) (actual time=119.246..120.623 rows=849 loops=1)

  • Merge Cond: (usr_10.id = c_14.user_add)
  • Buffers: shared hit=970
335. 0.046 1.492 ↑ 40.9 52 1

Nested Loop Left Join (cost=1.57..1,723.21 rows=2,127 width=8) (actual time=0.129..1.492 rows=52 loops=1)

  • Buffers: shared hit=825
336. 0.041 0.510 ↑ 6.2 52 1

Nested Loop Left Join (cost=0.29..282.37 rows=320 width=16) (actual time=0.040..0.510 rows=52 loops=1)

  • Buffers: shared hit=188
337. 0.053 0.053 ↑ 6.2 52 1

Index Scan using fdc_user_pk on fdc_user usr_10 (cost=0.15..55.97 rows=320 width=16) (actual time=0.011..0.053 rows=52 loops=1)

  • Buffers: shared hit=33
338. 0.416 0.416 ↑ 1.0 1 52

Index Scan using fdc_person_root_date_uk on fdc_person per_20 (cost=0.14..0.70 rows=1 width=16) (actual time=0.003..0.008 rows=1 loops=52)

  • Index Cond: (person_root_id = usr_10.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Buffers: shared hit=155
339. 0.015 0.936 ↑ 48.0 1 52

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (actual time=0.013..0.018 rows=1 loops=52)

  • Buffers: shared hit=637
340. 0.013 0.624 ↑ 7.0 1 52

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (actual time=0.008..0.012 rows=1 loops=52)

  • Buffers: shared hit=413
341. 0.000 0.260 ↑ 1.0 1 52

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (actual time=0.005..0.005 rows=1 loops=52)

  • Buffers: shared hit=275
342. 0.077 0.208 ↑ 1.0 1 52

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (actual time=0.003..0.004 rows=1 loops=52)

  • Buffers: shared hit=194
343. 0.000 0.104 ↑ 1.0 1 52

Nested Loop (cost=0.43..0.68 rows=1 width=24) (actual time=0.002..0.002 rows=1 loops=52)

  • Buffers: shared hit=113
344. 0.052 0.052 ↑ 1.0 1 52

Index Scan using fdc_official_person_pk on fdc_official_person ofp_10 (cost=0.15..0.18 rows=1 width=24) (actual time=0.001..0.001 rows=1 loops=52)

  • Index Cond: (id = per_20.id)
  • Buffers: shared hit=58
345. 0.054 0.054 ↑ 1.0 1 27

Index Only Scan using fdc_person_pk on fdc_person per_21 (cost=0.28..0.50 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=27)

  • Index Cond: (id = ofp_10.id)
  • Heap Fetches: 0
  • Buffers: shared hit=55
346. 0.027 0.027 ↑ 1.0 1 27

Index Scan using fdc_person_pk on fdc_person ind_ver_10 (cost=0.28..0.65 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=27)

  • Index Cond: (id = ofp_10.individual_id)
  • Buffers: shared hit=81
347. 0.054 0.054 ↑ 1.0 1 27

Index Scan using fdc_person_pk on fdc_person leg_ver_10 (cost=0.28..0.65 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=27)

  • Index Cond: (id = ofp_10.legal_person_id)
  • Buffers: shared hit=81
348. 0.351 0.351 ↑ 1.0 1 27

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_10 (cost=0.14..0.24 rows=1 width=16) (actual time=0.005..0.013 rows=1 loops=27)

  • Index Cond: (person_root_id = ind_ver_10.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=138
349. 0.297 0.297 ↑ 1.0 1 27

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_10 (cost=0.14..0.24 rows=1 width=8) (actual time=0.008..0.011 rows=1 loops=27)

  • Index Cond: (person_root_id = leg_ver_10.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Rows Removed by Filter: 8
  • Buffers: shared hit=224
350. 0.343 118.964 ↑ 1.0 849 1

Sort (cost=279.76..281.88 rows=849 width=24) (actual time=118.920..118.964 rows=849 loops=1)

  • Sort Key: c_14.user_add
  • Sort Method: quicksort Memory: 91kB
  • Buffers: shared hit=145
351. 0.514 118.621 ↑ 1.0 849 1

Hash Join (cost=31.10..238.46 rows=849 width=24) (actual time=0.510..118.621 rows=849 loops=1)

  • Hash Cond: (t_9.trademark_id = c_14.id)
  • Buffers: shared hit=145
352. 117.830 117.830 ↑ 1.0 849 1

Seq Scan on fdc_ts_trademark_translation t_9 (cost=0.00..196.64 rows=849 width=16) (actual time=0.229..117.830 rows=849 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 3394
  • Buffers: shared hit=133
353. 0.116 0.277 ↑ 1.0 849 1

Hash (cost=20.49..20.49 rows=849 width=16) (actual time=0.277..0.277 rows=849 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 48kB
  • Buffers: shared hit=12
354. 0.161 0.161 ↑ 1.0 849 1

Seq Scan on fdc_ts_trademark c_14 (cost=0.00..20.49 rows=849 width=16) (actual time=0.008..0.161 rows=849 loops=1)

  • Buffers: shared hit=12
355. 0.003 3.980 ↑ 10.0 16 1

Hash (cost=44.43..44.43 rows=160 width=8) (actual time=3.980..3.980 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=712
356. 0.015 3.977 ↑ 10.0 16 1

Hash Join (cost=7.34..44.43 rows=160 width=8) (actual time=3.037..3.977 rows=16 loops=1)

  • Hash Cond: (c_18.id = t_13.special_equipment_id)
  • Buffers: shared hit=712
357. 0.012 1.233 ↑ 5.0 16 1

Merge Right Join (cost=2.91..39.02 rows=80 width=8) (actual time=0.297..1.233 rows=16 loops=1)

  • Merge Cond: (usr_13.id = c_18.user_add)
  • Buffers: shared hit=710
358. 0.030 1.194 ↑ 44.3 48 1

Nested Loop Left Join (cost=1.57..1,723.21 rows=2,127 width=8) (actual time=0.141..1.194 rows=48 loops=1)

  • Buffers: shared hit=709
359. 0.027 0.396 ↑ 6.7 48 1

Nested Loop Left Join (cost=0.29..282.37 rows=320 width=16) (actual time=0.051..0.396 rows=48 loops=1)

  • Buffers: shared hit=165
360. 0.033 0.033 ↑ 6.7 48 1

Index Scan using fdc_user_pk on fdc_user usr_13 (cost=0.15..55.97 rows=320 width=16) (actual time=0.012..0.033 rows=48 loops=1)

  • Buffers: shared hit=30
361. 0.336 0.336 ↑ 1.0 1 48

Index Scan using fdc_person_root_date_uk on fdc_person per_26 (cost=0.14..0.70 rows=1 width=16) (actual time=0.003..0.007 rows=1 loops=48)

  • Index Cond: (person_root_id = usr_13.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Buffers: shared hit=135
362. 0.000 0.768 ↓ 0.0 0 48

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (actual time=0.011..0.016 rows=0 loops=48)

  • Buffers: shared hit=544
363. 0.060 0.528 ↓ 0.0 0 48

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (actual time=0.007..0.011 rows=0 loops=48)

  • Buffers: shared hit=353
364. 0.025 0.192 ↓ 0.0 0 48

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (actual time=0.004..0.004 rows=0 loops=48)

  • Buffers: shared hit=235
365. 0.025 0.144 ↓ 0.0 0 48

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (actual time=0.003..0.003 rows=0 loops=48)

  • Buffers: shared hit=166
366. 0.025 0.096 ↓ 0.0 0 48

Nested Loop (cost=0.43..0.68 rows=1 width=24) (actual time=0.002..0.002 rows=0 loops=48)

  • Buffers: shared hit=97
367. 0.048 0.048 ↓ 0.0 0 48

Index Scan using fdc_official_person_pk on fdc_official_person ofp_13 (cost=0.15..0.18 rows=1 width=24) (actual time=0.001..0.001 rows=0 loops=48)

  • Index Cond: (id = per_26.id)
  • Buffers: shared hit=50
368. 0.023 0.023 ↑ 1.0 1 23

Index Only Scan using fdc_person_pk on fdc_person per_27 (cost=0.28..0.50 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=23)

  • Index Cond: (id = ofp_13.id)
  • Heap Fetches: 0
  • Buffers: shared hit=47
369. 0.023 0.023 ↑ 1.0 1 23

Index Scan using fdc_person_pk on fdc_person ind_ver_13 (cost=0.28..0.65 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=23)

  • Index Cond: (id = ofp_13.individual_id)
  • Buffers: shared hit=69
370. 0.023 0.023 ↑ 1.0 1 23

Index Scan using fdc_person_pk on fdc_person leg_ver_13 (cost=0.28..0.65 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=23)

  • Index Cond: (id = ofp_13.legal_person_id)
  • Buffers: shared hit=69
371. 0.276 0.276 ↑ 1.0 1 23

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_13 (cost=0.14..0.24 rows=1 width=16) (actual time=0.005..0.012 rows=1 loops=23)

  • Index Cond: (person_root_id = ind_ver_13.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Rows Removed by Filter: 0
  • Buffers: shared hit=118
372. 0.253 0.253 ↑ 1.0 1 23

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_13 (cost=0.14..0.24 rows=1 width=8) (actual time=0.008..0.011 rows=1 loops=23)

  • Index Cond: (person_root_id = leg_ver_13.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Rows Removed by Filter: 8
  • Buffers: shared hit=191
373. 0.013 0.027 ↓ 1.3 16 1

Sort (cost=1.34..1.37 rows=12 width=16) (actual time=0.026..0.027 rows=16 loops=1)

  • Sort Key: c_18.user_add
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1
374. 0.014 0.014 ↓ 1.3 16 1

Seq Scan on fdc_special_equipment_other c_18 (cost=0.00..1.12 rows=12 width=16) (actual time=0.011..0.014 rows=16 loops=1)

  • Buffers: shared hit=1
375. 0.006 2.729 ↑ 1.5 16 1

Hash (cost=4.13..4.13 rows=24 width=8) (actual time=2.729..2.729 rows=16 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=2
376. 2.723 2.723 ↑ 1.5 16 1

Seq Scan on fdc_special_equipment_other_translation t_13 (cost=0.00..4.13 rows=24 width=8) (actual time=0.073..2.723 rows=16 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 79
  • Buffers: shared hit=2
377. 1,964.529 27,503.406 ↓ 0.0 0 1,964,529

Limit (cost=45.82..86.28 rows=1 width=803) (actual time=0.014..0.014 rows=0 loops=1,964,529)

  • Buffers: shared hit=5894744
378. 0.000 25,538.877 ↓ 0.0 0 1,964,529

Nested Loop Left Join (cost=45.82..4,456.47 rows=109 width=803) (actual time=0.013..0.013 rows=0 loops=1,964,529)

  • Join Filter: (engine.max_power_speed_unit_id = c_44.id)
  • Rows Removed by Join Filter: 0
  • Buffers: shared hit=5894744
379. 0.000 25,538.877 ↓ 0.0 0 1,964,529

Nested Loop Left Join (cost=40.18..3,734.75 rows=109 width=135) (actual time=0.013..0.013 rows=0 loops=1,964,529)

  • Join Filter: (engine.max_torque_speed_unit_id = c_45.id)
  • Rows Removed by Join Filter: 0
  • Buffers: shared hit=5894737
380. 0.000 25,538.877 ↓ 0.0 0 1,964,529

Nested Loop Left Join (cost=34.54..3,013.03 rows=109 width=143) (actual time=0.013..0.013 rows=0 loops=1,964,529)

  • Join Filter: (engine.max_power_unit_id = c_42.id)
  • Rows Removed by Join Filter: 0
  • Buffers: shared hit=5894730
381. 1,960.805 25,538.877 ↓ 0.0 0 1,964,529

Nested Loop Left Join (cost=28.90..2,291.30 rows=109 width=143) (actual time=0.013..0.013 rows=0 loops=1,964,529)

  • Join Filter: (engine.volume_unit_id = c_43.id)
  • Rows Removed by Join Filter: 0
  • Buffers: shared hit=5894725
382. 0.000 23,574.348 ↓ 0.0 0 1,964,529

Nested Loop Left Join (cost=23.26..1,569.58 rows=109 width=151) (actual time=0.012..0.012 rows=0 loops=1,964,529)

  • Join Filter: (engine.voltage_unit_id = c_40.id)
  • Rows Removed by Join Filter: 0
  • Buffers: shared hit=5894721
383. 0.000 23,574.348 ↓ 0.0 0 1,964,529

Nested Loop Left Join (cost=17.62..847.85 rows=109 width=159) (actual time=0.012..0.012 rows=0 loops=1,964,529)

  • Join Filter: (engine.maximum_torque_unit_id = c_41.id)
  • Rows Removed by Join Filter: 0
  • Buffers: shared hit=5894713
384. 1,963.997 23,574.348 ↓ 0.0 0 1,964,529

Nested Loop Left Join (cost=11.98..126.13 rows=109 width=167) (actual time=0.012..0.012 rows=0 loops=1,964,529)

  • Buffers: shared hit=5894706
385. 0.000 21,609.819 ↓ 0.0 0 1,964,529

Nested Loop Left Join (cost=2.12..38.65 rows=5 width=167) (actual time=0.011..0.011 rows=0 loops=1,964,529)

  • Buffers: shared hit=5894706
386. 13,751.969 21,609.819 ↓ 0.0 0 1,964,529

Nested Loop (cost=0.28..20.36 rows=1 width=175) (actual time=0.011..0.011 rows=0 loops=1,964,529)

  • Join Filter: (engine.engine_kind_id = c_37.id)
  • Buffers: shared hit=5893853
387. 3,929.058 3,929.058 ↑ 1.0 2 1,964,529

Index Only Scan using fdc_engine_kind_pk on fdc_engine_kind c_37 (cost=0.13..12.16 rows=2 width=8) (actual time=0.001..0.002 rows=2 loops=1,964,529)

  • Heap Fetches: 3928792
  • Buffers: shared hit=3929058
388. 1,964.263 3,928.792 ↓ 0.0 0 3,928,792

Materialize (cost=0.15..8.17 rows=1 width=175) (actual time=0.001..0.001 rows=0 loops=3,928,792)

  • Buffers: shared hit=1964795
389. 1,964.529 1,964.529 ↓ 0.0 0 1,964,529

Index Scan using fdc_pts_engine_psp_i on fdc_pts_engine engine (cost=0.15..8.17 rows=1 width=175) (actual time=0.001..0.001 rows=0 loops=1,964,529)

  • Index Cond: (pasport_id = pv.id)
  • Buffers: shared hit=1964795
390. 0.535 19.152 ↑ 5.0 1 266

Nested Loop Left Join (cost=1.85..18.25 rows=5 width=8) (actual time=0.072..0.072 rows=1 loops=266)

  • Buffers: shared hit=853
391. 16.495 17.822 ↑ 1.0 1 266

Nested Loop (cost=0.28..9.17 rows=1 width=16) (actual time=0.067..0.067 rows=1 loops=266)

  • Buffers: shared hit=796
392. 0.532 0.532 ↑ 1.0 1 266

Index Scan using fdc_dvs_cylinder_arrangement_pk on fdc_dvs_cylinder_place c_38 (cost=0.14..8.15 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=266)

  • Index Cond: (engine.cylinder_place_id = id)
  • Buffers: shared hit=530
393. 0.795 0.795 ↑ 1.0 1 265

Index Only Scan using fdc_dvs_cylinder_place_translation_vl_i on fdc_dvs_cylinder_place_translation t_28 (cost=0.14..0.89 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=265)

  • Index Cond: ((cylinder_place_id = c_38.id) AND (language_id = lang.get_current_lang_id()))
  • Heap Fetches: 0
  • Buffers: shared hit=266
394. 0.366 0.795 ↓ 0.0 0 265

Nested Loop Left Join (cost=1.57..9.01 rows=7 width=8) (actual time=0.003..0.003 rows=0 loops=265)

  • Buffers: shared hit=57
395. 0.223 0.265 ↓ 0.0 0 265

Nested Loop Left Join (cost=0.29..4.51 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=265)

  • Buffers: shared hit=10
396. 0.000 0.000 ↓ 0.0 0 265

Index Scan using fdc_user_pk on fdc_user usr_31 (cost=0.15..3.80 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=265)

  • Index Cond: (c_38.user_add = id)
  • Buffers: shared hit=4
397. 0.042 0.042 ↑ 1.0 1 2

Index Scan using fdc_person_root_date_uk on fdc_person per_62 (cost=0.14..0.70 rows=1 width=16) (actual time=0.021..0.021 rows=1 loops=2)

  • Index Cond: (person_root_id = usr_31.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Buffers: shared hit=6
398. 0.002 0.164 ↑ 48.0 1 2

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (actual time=0.082..0.082 rows=1 loops=2)

  • Buffers: shared hit=47
399. 0.006 0.118 ↑ 7.0 1 2

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (actual time=0.059..0.059 rows=1 loops=2)

  • Buffers: shared hit=27
400. 0.002 0.076 ↑ 1.0 1 2

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (actual time=0.038..0.038 rows=1 loops=2)

  • Buffers: shared hit=21
401. 0.004 0.054 ↑ 1.0 1 2

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (actual time=0.027..0.027 rows=1 loops=2)

  • Buffers: shared hit=15
402. 0.004 0.042 ↑ 1.0 1 2

Nested Loop (cost=0.43..0.68 rows=1 width=24) (actual time=0.021..0.021 rows=1 loops=2)

  • Buffers: shared hit=9
403. 0.008 0.008 ↑ 1.0 1 2

Index Scan using fdc_official_person_pk on fdc_official_person ofp_31 (cost=0.15..0.18 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=2)

  • Index Cond: (id = per_62.id)
  • Buffers: shared hit=4
404. 0.030 0.030 ↑ 1.0 1 2

Index Only Scan using fdc_person_pk on fdc_person per_63 (cost=0.28..0.50 rows=1 width=8) (actual time=0.015..0.015 rows=1 loops=2)

  • Index Cond: (id = ofp_31.id)
  • Heap Fetches: 0
  • Buffers: shared hit=5
405. 0.008 0.008 ↑ 1.0 1 2

Index Scan using fdc_person_pk on fdc_person ind_ver_31 (cost=0.28..0.65 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=2)

  • Index Cond: (id = ofp_31.individual_id)
  • Buffers: shared hit=6
406. 0.020 0.020 ↑ 1.0 1 2

Index Scan using fdc_person_pk on fdc_person leg_ver_31 (cost=0.28..0.65 rows=1 width=16) (actual time=0.010..0.010 rows=1 loops=2)

  • Index Cond: (id = ofp_31.legal_person_id)
  • Buffers: shared hit=6
407. 0.036 0.036 ↑ 1.0 1 2

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_31 (cost=0.14..0.24 rows=1 width=16) (actual time=0.018..0.018 rows=1 loops=2)

  • Index Cond: (person_root_id = ind_ver_31.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Buffers: shared hit=6
408. 0.044 0.044 ↑ 1.0 1 2

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_31 (cost=0.14..0.24 rows=1 width=8) (actual time=0.022..0.022 rows=1 loops=2)

  • Index Cond: (person_root_id = leg_ver_31.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Rows Removed by Filter: 13
  • Buffers: shared hit=20
409. 0.266 0.532 ↓ 0.0 0 266

Hash Join (cost=9.85..25.17 rows=21 width=8) (actual time=0.002..0.002 rows=0 loops=266)

  • Hash Cond: (c_39.id = t_29.type_id)
410. 0.266 0.266 ↓ 0.0 0 266

Nested Loop Left Join (cost=1.71..16.93 rows=7 width=8) (actual time=0.001..0.001 rows=0 loops=266)

411. 0.000 0.000 ↓ 0.0 0 266

Index Scan using fdc_electromachine_type_pk on fdc_electromachine_type c_39 (cost=0.14..8.15 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=266)

  • Index Cond: (engine.electromachine_type_id = id)
412. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.57..8.71 rows=7 width=8) (never executed)

413. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.29..4.21 rows=1 width=16) (never executed)

414. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_user_pk on fdc_user usr_32 (cost=0.15..3.50 rows=1 width=16) (never executed)

  • Index Cond: (c_39.user_add = id)
415. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_64 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_32.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
416. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

417. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

418. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

419. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

420. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

421. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_32 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_64.id)
422. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_65 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_32.id)
  • Heap Fetches: 0
423. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_32 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_32.individual_id)
424. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_32 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_32.legal_person_id)
425. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_32 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_32.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
426. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_32 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_32.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
427. 0.000 0.000 ↓ 0.0 0

Hash (cost=7.70..7.70 rows=36 width=8) (never executed)

428. 0.000 0.000 ↓ 0.0 0

Seq Scan on fdc_electromachine_type_translation t_29 (cost=0.00..7.70 rows=36 width=8) (never executed)

  • Filter: (language_id = lang.get_current_lang_id())
429. 1.287 13.832 ↑ 1.0 88 266

Materialize (cost=5.64..571.53 rows=92 width=8) (actual time=0.001..0.052 rows=88 loops=266)

  • Buffers: shared hit=7
430. 0.031 12.545 ↑ 1.0 88 1

Nested Loop Left Join (cost=5.64..571.07 rows=92 width=8) (actual time=0.220..12.545 rows=88 loops=1)

  • Buffers: shared hit=7
431. 0.049 12.426 ↑ 1.0 88 1

Hash Join (cost=4.07..18.12 rows=92 width=16) (actual time=0.212..12.426 rows=88 loops=1)

  • Hash Cond: (t_31.measure_unit_id = c_41.id)
  • Buffers: shared hit=7
432. 12.337 12.337 ↑ 1.0 88 1

Seq Scan on fdc_measure_unit_translation t_31 (cost=0.00..12.90 rows=92 width=8) (actual time=0.163..12.337 rows=88 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 348
  • Buffers: shared hit=5
433. 0.014 0.040 ↑ 1.0 92 1

Hash (cost=2.92..2.92 rows=92 width=16) (actual time=0.040..0.040 rows=92 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared hit=2
434. 0.026 0.026 ↑ 1.0 92 1

Seq Scan on fdc_measure_unit c_41 (cost=0.00..2.92 rows=92 width=16) (actual time=0.009..0.026 rows=92 loops=1)

  • Buffers: shared hit=2
435. 0.000 0.088 ↓ 0.0 0 88

Nested Loop Left Join (cost=1.57..5.94 rows=7 width=8) (actual time=0.001..0.001 rows=0 loops=88)

436. 0.088 0.088 ↓ 0.0 0 88

Nested Loop Left Join (cost=0.29..1.44 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=88)

437. 0.000 0.000 ↓ 0.0 0 88

Index Scan using fdc_user_pk on fdc_user usr_34 (cost=0.15..0.73 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=88)

  • Index Cond: (c_41.user_add = id)
438. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_68 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_34.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
439. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

440. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

441. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

442. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

443. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

444. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_34 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_68.id)
445. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_69 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_34.id)
  • Heap Fetches: 0
446. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_34 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_34.individual_id)
447. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_34 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_34.legal_person_id)
448. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_34 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_34.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
449. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_34 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_34.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
450. 1.335 14.364 ↑ 1.0 92 266

Materialize (cost=5.64..571.53 rows=92 width=8) (actual time=0.001..0.054 rows=92 loops=266)

  • Buffers: shared hit=8
451. 0.038 13.029 ↑ 1.0 92 1

Nested Loop Left Join (cost=5.64..571.07 rows=92 width=8) (actual time=0.178..13.029 rows=92 loops=1)

  • Buffers: shared hit=8
452. 0.050 12.899 ↑ 1.0 92 1

Hash Join (cost=4.07..18.12 rows=92 width=16) (actual time=0.169..12.899 rows=92 loops=1)

  • Hash Cond: (t_30.measure_unit_id = c_40.id)
  • Buffers: shared hit=8
453. 12.816 12.816 ↑ 1.0 92 1

Seq Scan on fdc_measure_unit_translation t_30 (cost=0.00..12.90 rows=92 width=8) (actual time=0.129..12.816 rows=92 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 368
  • Buffers: shared hit=6
454. 0.015 0.033 ↑ 1.0 92 1

Hash (cost=2.92..2.92 rows=92 width=16) (actual time=0.033..0.033 rows=92 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared hit=2
455. 0.018 0.018 ↑ 1.0 92 1

Seq Scan on fdc_measure_unit c_40 (cost=0.00..2.92 rows=92 width=16) (actual time=0.004..0.018 rows=92 loops=1)

  • Buffers: shared hit=2
456. 0.000 0.092 ↓ 0.0 0 92

Nested Loop Left Join (cost=1.57..5.94 rows=7 width=8) (actual time=0.001..0.001 rows=0 loops=92)

457. 0.092 0.092 ↓ 0.0 0 92

Nested Loop Left Join (cost=0.29..1.44 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=92)

458. 0.000 0.000 ↓ 0.0 0 92

Index Scan using fdc_user_pk on fdc_user usr_33 (cost=0.15..0.73 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=92)

  • Index Cond: (c_40.user_add = id)
459. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_66 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_33.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
460. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

461. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

462. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

463. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

464. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

465. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_33 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_66.id)
466. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_67 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_33.id)
  • Heap Fetches: 0
467. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_33 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_33.individual_id)
468. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_33 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_33.legal_person_id)
469. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_33 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_33.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
470. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_33 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_33.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
471. 0.416 3.724 ↑ 4.0 23 266

Materialize (cost=5.64..571.53 rows=92 width=8) (actual time=0.001..0.014 rows=23 loops=266)

  • Buffers: shared hit=4
472. 0.014 3.308 ↑ 4.0 23 1

Nested Loop Left Join (cost=5.64..571.07 rows=92 width=8) (actual time=0.173..3.308 rows=23 loops=1)

  • Buffers: shared hit=4
473. 0.017 3.271 ↑ 4.0 23 1

Hash Join (cost=4.07..18.12 rows=92 width=16) (actual time=0.164..3.271 rows=23 loops=1)

  • Hash Cond: (t_33.measure_unit_id = c_43.id)
  • Buffers: shared hit=4
474. 3.223 3.223 ↑ 4.0 23 1

Seq Scan on fdc_measure_unit_translation t_33 (cost=0.00..12.90 rows=92 width=8) (actual time=0.126..3.223 rows=23 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 92
  • Buffers: shared hit=2
475. 0.014 0.031 ↑ 1.0 92 1

Hash (cost=2.92..2.92 rows=92 width=16) (actual time=0.031..0.031 rows=92 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared hit=2
476. 0.017 0.017 ↑ 1.0 92 1

Seq Scan on fdc_measure_unit c_43 (cost=0.00..2.92 rows=92 width=16) (actual time=0.004..0.017 rows=92 loops=1)

  • Buffers: shared hit=2
477. 0.000 0.023 ↓ 0.0 0 23

Nested Loop Left Join (cost=1.57..5.94 rows=7 width=8) (actual time=0.001..0.001 rows=0 loops=23)

478. 0.023 0.023 ↓ 0.0 0 23

Nested Loop Left Join (cost=0.29..1.44 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=23)

479. 0.000 0.000 ↓ 0.0 0 23

Index Scan using fdc_user_pk on fdc_user usr_36 (cost=0.15..0.73 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=23)

  • Index Cond: (c_43.user_add = id)
480. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_72 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_36.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
481. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

482. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

483. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

484. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

485. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

486. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_36 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_72.id)
487. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_73 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_36.id)
  • Heap Fetches: 0
488. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_36 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_36.individual_id)
489. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_36 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_36.legal_person_id)
490. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_36 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_36.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
491. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_36 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_36.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
492. 0.546 5.852 ↑ 2.5 37 266

Materialize (cost=5.64..571.53 rows=92 width=8) (actual time=0.001..0.022 rows=37 loops=266)

  • Buffers: shared hit=5
493. 0.024 5.306 ↑ 2.5 37 1

Nested Loop Left Join (cost=5.64..571.07 rows=92 width=8) (actual time=0.180..5.306 rows=37 loops=1)

  • Buffers: shared hit=5
494. 0.019 5.245 ↑ 2.5 37 1

Hash Join (cost=4.07..18.12 rows=92 width=16) (actual time=0.171..5.245 rows=37 loops=1)

  • Hash Cond: (t_32.measure_unit_id = c_42.id)
  • Buffers: shared hit=5
495. 5.188 5.188 ↑ 2.5 37 1

Seq Scan on fdc_measure_unit_translation t_32 (cost=0.00..12.90 rows=92 width=8) (actual time=0.130..5.188 rows=37 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 148
  • Buffers: shared hit=3
496. 0.014 0.038 ↑ 1.0 92 1

Hash (cost=2.92..2.92 rows=92 width=16) (actual time=0.038..0.038 rows=92 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared hit=2
497. 0.024 0.024 ↑ 1.0 92 1

Seq Scan on fdc_measure_unit c_42 (cost=0.00..2.92 rows=92 width=16) (actual time=0.003..0.024 rows=92 loops=1)

  • Buffers: shared hit=2
498. 0.000 0.037 ↓ 0.0 0 37

Nested Loop Left Join (cost=1.57..5.94 rows=7 width=8) (actual time=0.001..0.001 rows=0 loops=37)

499. 0.037 0.037 ↓ 0.0 0 37

Nested Loop Left Join (cost=0.29..1.44 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=37)

500. 0.000 0.000 ↓ 0.0 0 37

Index Scan using fdc_user_pk on fdc_user usr_35 (cost=0.15..0.73 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=37)

  • Index Cond: (c_42.user_add = id)
501. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_70 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_35.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
502. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

503. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

504. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

505. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

506. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

507. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_35 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_70.id)
508. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_71 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_35.id)
  • Heap Fetches: 0
509. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_35 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_35.individual_id)
510. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_35 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_35.legal_person_id)
511. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_35 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_35.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
512. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_35 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_35.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
513. 1.076 12.768 ↑ 1.1 84 266

Materialize (cost=5.64..571.53 rows=92 width=8) (actual time=0.001..0.048 rows=84 loops=266)

  • Buffers: shared hit=7
514. 0.029 11.692 ↑ 1.1 84 1

Nested Loop Left Join (cost=5.64..571.07 rows=92 width=8) (actual time=0.166..11.692 rows=84 loops=1)

  • Buffers: shared hit=7
515. 0.042 11.579 ↑ 1.1 84 1

Hash Join (cost=4.07..18.12 rows=92 width=16) (actual time=0.159..11.579 rows=84 loops=1)

  • Hash Cond: (t_35.measure_unit_id = c_45.id)
  • Buffers: shared hit=7
516. 11.507 11.507 ↑ 1.1 84 1

Seq Scan on fdc_measure_unit_translation t_35 (cost=0.00..12.90 rows=92 width=8) (actual time=0.125..11.507 rows=84 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 332
  • Buffers: shared hit=5
517. 0.013 0.030 ↑ 1.0 92 1

Hash (cost=2.92..2.92 rows=92 width=16) (actual time=0.030..0.030 rows=92 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared hit=2
518. 0.017 0.017 ↑ 1.0 92 1

Seq Scan on fdc_measure_unit c_45 (cost=0.00..2.92 rows=92 width=16) (actual time=0.003..0.017 rows=92 loops=1)

  • Buffers: shared hit=2
519. 0.000 0.084 ↓ 0.0 0 84

Nested Loop Left Join (cost=1.57..5.94 rows=7 width=8) (actual time=0.001..0.001 rows=0 loops=84)

520. 0.084 0.084 ↓ 0.0 0 84

Nested Loop Left Join (cost=0.29..1.44 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=84)

521. 0.000 0.000 ↓ 0.0 0 84

Index Scan using fdc_user_pk on fdc_user usr_38 (cost=0.15..0.73 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=84)

  • Index Cond: (c_45.user_add = id)
522. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_76 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_38.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
523. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

524. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

525. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

526. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

527. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

528. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_38 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_76.id)
529. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_77 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_38.id)
  • Heap Fetches: 0
530. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_38 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_38.individual_id)
531. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_38 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_38.legal_person_id)
532. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_38 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_38.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
533. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_38 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_38.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
534. 1.254 13.034 ↑ 1.1 84 266

Materialize (cost=5.64..571.53 rows=92 width=8) (actual time=0.001..0.049 rows=84 loops=266)

  • Buffers: shared hit=7
535. 0.034 11.780 ↑ 1.1 84 1

Nested Loop Left Join (cost=5.64..571.07 rows=92 width=8) (actual time=0.181..11.780 rows=84 loops=1)

  • Buffers: shared hit=7
536. 0.041 11.662 ↑ 1.1 84 1

Hash Join (cost=4.07..18.12 rows=92 width=16) (actual time=0.174..11.662 rows=84 loops=1)

  • Hash Cond: (t_34.measure_unit_id = c_44.id)
  • Buffers: shared hit=7
537. 11.588 11.588 ↑ 1.1 84 1

Seq Scan on fdc_measure_unit_translation t_34 (cost=0.00..12.90 rows=92 width=8) (actual time=0.137..11.588 rows=84 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 332
  • Buffers: shared hit=5
538. 0.015 0.033 ↑ 1.0 92 1

Hash (cost=2.92..2.92 rows=92 width=16) (actual time=0.033..0.033 rows=92 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared hit=2
539. 0.018 0.018 ↑ 1.0 92 1

Seq Scan on fdc_measure_unit c_44 (cost=0.00..2.92 rows=92 width=16) (actual time=0.004..0.018 rows=92 loops=1)

  • Buffers: shared hit=2
540. 0.000 0.084 ↓ 0.0 0 84

Nested Loop Left Join (cost=1.57..5.94 rows=7 width=8) (actual time=0.001..0.001 rows=0 loops=84)

541. 0.084 0.084 ↓ 0.0 0 84

Nested Loop Left Join (cost=0.29..1.44 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=84)

542. 0.000 0.000 ↓ 0.0 0 84

Index Scan using fdc_user_pk on fdc_user usr_37 (cost=0.15..0.73 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=84)

  • Index Cond: (c_44.user_add = id)
543. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_74 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_37.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
544. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

545. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

546. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

547. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

548. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

549. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_37 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_74.id)
550. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_75 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_37.id)
  • Heap Fetches: 0
551. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_37 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_37.individual_id)
552. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_37 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_37.legal_person_id)
553. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_37 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_37.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
554. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_37 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_37.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
555. 0.018 0.262 ↑ 1.0 92 1

Hash (cost=570.54..570.54 rows=92 width=15) (actual time=0.262..0.262 rows=92 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 13kB
  • Buffers: shared hit=10
556. 0.071 0.244 ↑ 1.0 92 1

Nested Loop Left Join (cost=10.63..570.54 rows=92 width=15) (actual time=0.133..0.244 rows=92 loops=1)

  • Buffers: shared hit=10
557. 0.033 0.173 ↑ 1.0 92 1

Hash Join (cost=9.06..17.59 rows=92 width=23) (actual time=0.127..0.173 rows=92 loops=1)

  • Hash Cond: (t_15.measure_unit_id = c_20.id)
  • Buffers: shared hit=10
558. 0.034 0.101 ↑ 1.0 92 1

Bitmap Heap Scan on fdc_measure_unit_translation t_15 (cost=4.99..12.37 rows=92 width=15) (actual time=0.078..0.101 rows=92 loops=1)

  • Recheck Cond: (language_id = lang.get_current_lang_id())
  • Heap Blocks: exact=6
  • Buffers: shared hit=8
559. 0.067 0.067 ↑ 1.0 92 1

Bitmap Index Scan on fdc_measure_unit_translation_l_i (cost=0.00..4.97 rows=92 width=0) (actual time=0.067..0.067 rows=92 loops=1)

  • Index Cond: (language_id = lang.get_current_lang_id())
  • Buffers: shared hit=2
560. 0.014 0.039 ↑ 1.0 92 1

Hash (cost=2.92..2.92 rows=92 width=16) (actual time=0.039..0.039 rows=92 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 12kB
  • Buffers: shared hit=2
561. 0.025 0.025 ↑ 1.0 92 1

Seq Scan on fdc_measure_unit c_20 (cost=0.00..2.92 rows=92 width=16) (actual time=0.009..0.025 rows=92 loops=1)

  • Buffers: shared hit=2
562. 0.000 0.000 ↓ 0.0 0 92

Nested Loop Left Join (cost=1.57..5.94 rows=7 width=8) (actual time=0.000..0.000 rows=0 loops=92)

563. 0.000 0.000 ↓ 0.0 0 92

Nested Loop Left Join (cost=0.29..1.44 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=92)

564. 0.000 0.000 ↓ 0.0 0 92

Index Scan using fdc_user_pk on fdc_user usr_15 (cost=0.15..0.73 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=92)

  • Index Cond: (c_20.user_add = id)
565. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_30 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_15.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
566. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

567. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

568. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

569. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

570. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

571. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_15 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_30.id)
572. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_31 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_15.id)
  • Heap Fetches: 0
573. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_15 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_15.individual_id)
574. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_15 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_15.legal_person_id)
575. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_15 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_15.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
576. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_15 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_15.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
577. 0.003 2.430 ↑ 20.0 12 1

Hash (cost=115.60..115.60 rows=240 width=8) (actual time=2.430..2.430 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=391
578. 0.014 2.427 ↑ 20.0 12 1

Hash Join (cost=9.72..115.60 rows=240 width=8) (actual time=1.913..2.427 rows=12 loops=1)

  • Hash Cond: (c_19.id = t_14.type_id)
  • Buffers: shared hit=391
579. 0.005 0.648 ↑ 6.7 12 1

Nested Loop Left Join (cost=1.57..106.46 rows=80 width=8) (actual time=0.138..0.648 rows=12 loops=1)

  • Buffers: shared hit=386
580. 0.007 0.007 ↑ 1.0 12 1

Seq Scan on fdc_electromachine_type c_19 (cost=0.00..1.12 rows=12 width=16) (actual time=0.005..0.007 rows=12 loops=1)

  • Buffers: shared hit=1
581. 0.024 0.636 ↑ 7.0 1 12

Nested Loop Left Join (cost=1.57..8.71 rows=7 width=8) (actual time=0.036..0.053 rows=1 loops=12)

  • Buffers: shared hit=385
582. 0.012 0.192 ↑ 1.0 1 12

Nested Loop Left Join (cost=0.29..4.21 rows=1 width=16) (actual time=0.008..0.016 rows=1 loops=12)

  • Buffers: shared hit=84
583. 0.024 0.024 ↑ 1.0 1 12

Index Scan using fdc_user_pk on fdc_user usr_14 (cost=0.15..3.50 rows=1 width=16) (actual time=0.002..0.002 rows=1 loops=12)

  • Index Cond: (c_19.user_add = id)
  • Buffers: shared hit=24
584. 0.156 0.156 ↑ 1.0 1 12

Index Scan using fdc_person_root_date_uk on fdc_person per_28 (cost=0.14..0.70 rows=1 width=16) (actual time=0.006..0.013 rows=1 loops=12)

  • Index Cond: (person_root_id = usr_14.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Buffers: shared hit=60
585. 0.012 0.420 ↑ 48.0 1 12

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (actual time=0.026..0.035 rows=1 loops=12)

  • Buffers: shared hit=301
586. 0.012 0.288 ↑ 7.0 1 12

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (actual time=0.016..0.024 rows=1 loops=12)

  • Buffers: shared hit=181
587. 0.012 0.108 ↑ 1.0 1 12

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (actual time=0.008..0.009 rows=1 loops=12)

  • Buffers: shared hit=121
588. 0.024 0.084 ↑ 1.0 1 12

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (actual time=0.006..0.007 rows=1 loops=12)

  • Buffers: shared hit=85
589. 0.000 0.048 ↑ 1.0 1 12

Nested Loop (cost=0.43..0.68 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=12)

  • Buffers: shared hit=49
590. 0.024 0.024 ↑ 1.0 1 12

Index Scan using fdc_official_person_pk on fdc_official_person ofp_14 (cost=0.15..0.18 rows=1 width=24) (actual time=0.001..0.002 rows=1 loops=12)

  • Index Cond: (id = per_28.id)
  • Buffers: shared hit=24
591. 0.024 0.024 ↑ 1.0 1 12

Index Only Scan using fdc_person_pk on fdc_person per_29 (cost=0.28..0.50 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=12)

  • Index Cond: (id = ofp_14.id)
  • Heap Fetches: 0
  • Buffers: shared hit=25
592. 0.012 0.012 ↑ 1.0 1 12

Index Scan using fdc_person_pk on fdc_person ind_ver_14 (cost=0.28..0.65 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=12)

  • Index Cond: (id = ofp_14.individual_id)
  • Buffers: shared hit=36
593. 0.012 0.012 ↑ 1.0 1 12

Index Scan using fdc_person_pk on fdc_person leg_ver_14 (cost=0.28..0.65 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=12)

  • Index Cond: (id = ofp_14.legal_person_id)
  • Buffers: shared hit=36
594. 0.168 0.168 ↑ 1.0 1 12

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_14 (cost=0.14..0.24 rows=1 width=16) (actual time=0.006..0.014 rows=1 loops=12)

  • Index Cond: (person_root_id = ind_ver_14.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Buffers: shared hit=60
595. 0.120 0.120 ↑ 1.0 1 12

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_14 (cost=0.14..0.24 rows=1 width=8) (actual time=0.010..0.010 rows=1 loops=12)

  • Index Cond: (person_root_id = leg_ver_14.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
  • Rows Removed by Filter: 13
  • Buffers: shared hit=120
596. 0.005 1.765 ↑ 3.0 12 1

Hash (cost=7.70..7.70 rows=36 width=8) (actual time=1.765..1.765 rows=12 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=5
597. 1.760 1.760 ↑ 3.0 12 1

Seq Scan on fdc_electromachine_type_translation t_14 (cost=0.00..7.70 rows=36 width=8) (actual time=0.064..1.760 rows=12 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Rows Removed by Filter: 48
  • Buffers: shared hit=5
598. 33,396.993 39,290.580 ↑ 1.0 1 1,964,529

Aggregate (cost=9.55..9.56 rows=1 width=32) (actual time=0.020..0.020 rows=1 loops=1,964,529)

  • Buffers: shared hit=6393565
599. 1,716.364 5,893.587 ↓ 0.0 0 1,964,529

Nested Loop (cost=0.42..9.55 rows=1 width=9) (actual time=0.003..0.003 rows=0 loops=1,964,529)

  • Join Filter: (pn.equipment_type_id = c_46.id)
  • Buffers: shared hit=6393562
600. 3,929.058 3,929.058 ↓ 0.0 0 1,964,529

Index Scan using fdc_pts_part_number_psp_i on fdc_pts_part_number pn (cost=0.42..8.44 rows=1 width=17) (actual time=0.002..0.002 rows=0 loops=1,964,529)

  • Index Cond: (pasport_id = pv.id)
  • Buffers: shared hit=6145397
601. 248.165 248.165 ↑ 1.0 1 248,165

Seq Scan on fdc_equipment_type c_46 (cost=0.00..1.10 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=248,165)

  • Filter: ((code)::text = 'ENGINE_NUMBER'::text)
  • Rows Removed by Filter: 7
  • Buffers: shared hit=248165
602. 0.007 0.405 ↑ 1.0 5 1

Materialize (cost=2.96..39.38 rows=5 width=75) (actual time=0.144..0.405 rows=5 loops=1)

  • Buffers: shared hit=19
603. 0.249 0.398 ↑ 1.0 5 1

Nested Loop Left Join (cost=2.96..39.36 rows=5 width=75) (actual time=0.142..0.398 rows=5 loops=1)

  • Buffers: shared hit=19
604. 0.009 0.119 ↑ 1.0 5 1

Nested Loop Left Join (cost=2.68..35.73 rows=5 width=12) (actual time=0.057..0.119 rows=5 loops=1)

  • Buffers: shared hit=4
605. 0.042 0.100 ↑ 1.0 5 1

Hash Join (cost=1.11..7.41 rows=5 width=20) (actual time=0.045..0.100 rows=5 loops=1)

  • Hash Cond: (c_21.id = sl_1.country_id)
  • Buffers: shared hit=4
606. 0.046 0.046 ↑ 1.0 236 1

Seq Scan on fdc_country c_21 (cost=0.00..5.36 rows=236 width=20) (actual time=0.021..0.046 rows=236 loops=1)

  • Buffers: shared hit=3
607. 0.004 0.012 ↑ 1.0 5 1

Hash (cost=1.05..1.05 rows=5 width=8) (actual time=0.012..0.012 rows=5 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
  • Buffers: shared hit=1
608. 0.008 0.008 ↑ 1.0 5 1

Seq Scan on fdc_server_list sl_1 (cost=0.00..1.05 rows=5 width=8) (actual time=0.007..0.008 rows=5 loops=1)

  • Buffers: shared hit=1
609. 0.000 0.010 ↓ 0.0 0 5

Nested Loop Left Join (cost=1.57..5.60 rows=7 width=8) (actual time=0.002..0.002 rows=0 loops=5)

610. 0.005 0.010 ↓ 0.0 0 5

Nested Loop Left Join (cost=0.29..1.09 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=5)

611. 0.005 0.005 ↓ 0.0 0 5

Index Scan using fdc_user_pk on fdc_user usr_16 (cost=0.15..0.39 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=5)

  • Index Cond: (c_21.user_add = id)
612. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_32 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_16.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
613. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

614. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

615. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

616. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

617. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

618. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_16 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_32.id)
619. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_33 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_16.id)
  • Heap Fetches: 0
620. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_16 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_16.individual_id)
621. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_16 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_16.legal_person_id)
622. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_16 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_16.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
623. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_16 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_16.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
624. 0.030 0.030 ↑ 1.0 1 5

Index Scan using fdc_country_translation_vl_i on fdc_country_translation t_16 (cost=0.28..0.72 rows=1 width=71) (actual time=0.006..0.006 rows=1 loops=5)

  • Index Cond: ((c_21.id = country_id) AND (language_id = lang.get_current_lang_id()))
  • Buffers: shared hit=15
625. 0.032 0.116 ↑ 1.0 1 1

Aggregate (cost=20.15..20.16 rows=1 width=32) (actual time=0.116..0.116 rows=1 loops=1)

  • Buffers: shared hit=6
626. 0.049 0.084 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.99..20.14 rows=1 width=15) (actual time=0.083..0.084 rows=1 loops=1)

  • Buffers: shared hit=6
627. 0.003 0.028 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.84..18.56 rows=1 width=8) (actual time=0.027..0.028 rows=1 loops=1)

  • Buffers: shared hit=4
628. 0.004 0.021 ↑ 1.0 1 1

Nested Loop (cost=0.27..9.52 rows=1 width=16) (actual time=0.020..0.021 rows=1 loops=1)

  • Join Filter: (pc.color_id = c_47.id)
  • Buffers: shared hit=4
629. 0.011 0.011 ↑ 1.0 1 1

Index Scan using fdc_pts_colors_psp_i on fdc_pts_color pc (cost=0.27..8.29 rows=1 width=8) (actual time=0.011..0.011 rows=1 loops=1)

  • Index Cond: (pasport_id = pv.id)
  • Buffers: shared hit=3
630. 0.006 0.006 ↑ 10.0 1 1

Seq Scan on fdc_color c_47 (cost=0.00..1.10 rows=10 width=16) (actual time=0.006..0.006 rows=1 loops=1)

  • Buffers: shared hit=1
631. 0.002 0.004 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.57..8.98 rows=7 width=8) (actual time=0.004..0.004 rows=0 loops=1)

632. 0.001 0.002 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.29..4.47 rows=1 width=16) (actual time=0.002..0.002 rows=0 loops=1)

633. 0.001 0.001 ↓ 0.0 0 1

Index Scan using fdc_user_pk on fdc_user usr_39 (cost=0.15..3.76 rows=1 width=16) (actual time=0.001..0.001 rows=0 loops=1)

  • Index Cond: (c_47.user_add = id)
634. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_78 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_39.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
635. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

636. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

637. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

638. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

639. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

640. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_39 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_78.id)
641. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_79 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_39.id)
  • Heap Fetches: 0
642. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_39 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_39.individual_id)
643. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_39 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_39.legal_person_id)
644. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_39 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_39.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
645. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_39 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_39.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
646. 0.007 0.007 ↑ 1.0 1 1

Index Scan using fdc_color_translation_vl_i on fdc_color_translation t_36 (cost=0.14..1.36 rows=1 width=23) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: ((c_47.id = color_id) AND (language_id = lang.get_current_lang_id()))
  • Buffers: shared hit=2
647. 0.007 0.007 ↑ 1.0 1 1

Index Scan using fdc_legal_person_pk on fdc_legal_person reg_org (cost=0.28..0.30 rows=1 width=125) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (r.epts_org_id = id)
  • Buffers: shared hit=3
648. 0.013 0.013 ↑ 1.0 1 1

Index Only Scan using fdc_person_pk on fdc_person manufacturer_per (cost=0.28..0.30 rows=1 width=8) (actual time=0.013..0.013 rows=1 loops=1)

  • Index Cond: (id = pv.manufacturer_id)
  • Heap Fetches: 1
  • Buffers: shared hit=4
649. 0.004 0.004 ↑ 1.0 1 1

Index Scan using fdc_legal_person_pk on fdc_legal_person manufacturer (cost=0.28..0.44 rows=1 width=125) (actual time=0.004..0.004 rows=1 loops=1)

  • Index Cond: (id = manufacturer_per.id)
  • Buffers: shared hit=3
650. 0.007 0.007 ↑ 1.0 1 1

Index Scan using fdc_legal_person_pk on fdc_legal_person manufacturer_delegate (cost=0.28..0.30 rows=1 width=125) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (id = pv.manufacturer_representative_id)
  • Buffers: shared hit=3
651. 0.004 0.330 ↑ 1.0 1 1

Nested Loop Left Join (cost=7.94..46.15 rows=1 width=67) (actual time=0.325..0.330 rows=1 loops=1)

  • Buffers: shared hit=22
652. 0.003 0.248 ↑ 1.0 1 1

Nested Loop Left Join (cost=5.95..39.16 rows=1 width=75) (actual time=0.244..0.248 rows=1 loops=1)

  • Buffers: shared hit=17
653. 0.003 0.120 ↑ 1.0 1 1

Nested Loop Left Join (cost=3.69..26.16 rows=1 width=24) (actual time=0.118..0.120 rows=1 loops=1)

  • Buffers: shared hit=8
654. 0.002 0.104 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.99..14.31 rows=1 width=32) (actual time=0.103..0.104 rows=1 loops=1)

  • Buffers: shared hit=8
655. 0.003 0.069 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.85..14.10 rows=1 width=40) (actual time=0.068..0.069 rows=1 loops=1)

  • Buffers: shared hit=6
656. 0.048 0.048 ↑ 1.0 1 1

Index Scan using fdc_pts_ownership_date_uk on fdc_pts_owner own (cost=0.14..8.17 rows=1 width=48) (actual time=0.048..0.048 rows=1 loops=1)

  • Index Cond: (req.pasport_root_id = pasport_root_id)
  • Filter: (is_actual AND (statement_timestamp() >= ownership_date_from) AND (statement_timestamp() <= ownership_date_to))
  • Buffers: shared hit=4
657. 0.004 0.018 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.72..5.92 rows=1 width=8) (actual time=0.017..0.018 rows=1 loops=1)

  • Buffers: shared hit=2
658. 0.008 0.008 ↑ 1.0 1 1

Index Scan using fdc_country_pk on fdc_country c_23 (cost=0.14..0.26 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=1)

  • Index Cond: (id = own.country_id)
  • Buffers: shared hit=2
659. 0.001 0.006 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.57..5.60 rows=7 width=8) (actual time=0.006..0.006 rows=0 loops=1)

660. 0.001 0.005 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.29..1.09 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=1)

661. 0.004 0.004 ↓ 0.0 0 1

Index Scan using fdc_user_pk on fdc_user usr_18 (cost=0.15..0.39 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (c_23.user_add = id)
662. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_36 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_18.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
663. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

664. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

665. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

666. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

667. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

668. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_18 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_36.id)
669. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_37 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_18.id)
  • Heap Fetches: 0
670. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_18 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_18.individual_id)
671. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_18 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_18.legal_person_id)
672. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_18 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_18.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
673. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_18 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_18.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
674. 0.033 0.033 ↑ 1.0 1 1

Index Only Scan using fdc_server_list_country_i on fdc_server_list sl_2 (cost=0.13..0.20 rows=1 width=8) (actual time=0.032..0.033 rows=1 loops=1)

  • Index Cond: (country_id = c_23.id)
  • Heap Fetches: 1
  • Buffers: shared hit=2
675. 0.001 0.013 ↓ 0.0 0 1

Nested Loop (cost=1.70..11.84 rows=1 width=8) (actual time=0.013..0.013 rows=0 loops=1)

  • Join Filter: (c_25.id = t_19.currency_id)
676. 0.001 0.012 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.70..10.22 rows=1 width=8) (actual time=0.012..0.012 rows=0 loops=1)

677. 0.011 0.011 ↓ 0.0 0 1

Index Scan using fdc_currency_pk on fdc_currency c_25 (cost=0.13..0.21 rows=1 width=16) (actual time=0.011..0.011 rows=0 loops=1)

  • Index Cond: (id = own.currency_id)
678. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.57..9.95 rows=7 width=8) (never executed)

679. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.29..5.44 rows=1 width=16) (never executed)

680. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_user_pk on fdc_user usr_20 (cost=0.15..4.74 rows=1 width=16) (never executed)

  • Index Cond: (c_25.user_add = id)
681. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_40 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_20.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
682. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

683. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

684. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

685. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

686. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

687. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_20 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_40.id)
688. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_41 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_20.id)
  • Heap Fetches: 0
689. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_20 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_20.individual_id)
690. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_20 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_20.legal_person_id)
691. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_20 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_20.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
692. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_20 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_20.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
693. 0.000 0.000 ↓ 0.0 0

Seq Scan on fdc_currency_translation t_19 (cost=0.00..1.52 rows=7 width=8) (never executed)

  • Filter: (language_id = lang.get_current_lang_id())
694. 0.004 0.125 ↑ 1.0 1 1

Nested Loop Left Join (cost=2.26..12.99 rows=1 width=51) (actual time=0.123..0.125 rows=1 loops=1)

  • Buffers: shared hit=9
695. 0.003 0.023 ↑ 1.0 1 1

Nested Loop (cost=0.56..1.19 rows=1 width=16) (actual time=0.023..0.023 rows=1 loops=1)

  • Buffers: shared hit=6
696. 0.010 0.010 ↑ 1.0 1 1

Index Scan using fdc_person_pk on fdc_person p (cost=0.28..0.86 rows=1 width=16) (actual time=0.009..0.010 rows=1 loops=1)

  • Index Cond: (id = own.owner_id)
  • Buffers: shared hit=3
697. 0.010 0.010 ↑ 1.0 1 1

Index Scan using fdc_person_root_pk on fdc_person_root r_1 (cost=0.28..0.32 rows=1 width=16) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: (id = p.person_root_id)
  • Buffers: shared hit=3
698. 0.002 0.098 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.70..11.79 rows=1 width=51) (actual time=0.098..0.098 rows=1 loops=1)

  • Join Filter: (c_24.id = t_18.person_type_id)
  • Buffers: shared hit=3
699. 0.003 0.016 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.70..10.27 rows=1 width=11) (actual time=0.015..0.016 rows=1 loops=1)

  • Buffers: shared hit=2
700. 0.007 0.007 ↑ 1.0 1 1

Index Scan using fdc_person_type_pk on fdc_person_type c_24 (cost=0.13..0.16 rows=1 width=19) (actual time=0.007..0.007 rows=1 loops=1)

  • Index Cond: (id = r_1.person_type_id)
  • Buffers: shared hit=2
701. 0.001 0.006 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.57..10.04 rows=7 width=8) (actual time=0.006..0.006 rows=0 loops=1)

702. 0.001 0.005 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.29..5.54 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=1)

703. 0.004 0.004 ↓ 0.0 0 1

Index Scan using fdc_user_pk on fdc_user usr_19 (cost=0.15..4.83 rows=1 width=16) (actual time=0.004..0.004 rows=0 loops=1)

  • Index Cond: (c_24.user_add = id)
704. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_38 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_19.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
705. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

706. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

707. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

708. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

709. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

710. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_19 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_38.id)
711. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_39 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_19.id)
  • Heap Fetches: 0
712. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person ind_ver_19 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_19.individual_id)
713. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_pk on fdc_person leg_ver_19 (cost=0.28..0.65 rows=1 width=16) (never executed)

  • Index Cond: (id = ofp_19.legal_person_id)
714. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person ind_per_19 (cost=0.14..0.24 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = ind_ver_19.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
715. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person leg_per_19 (cost=0.14..0.24 rows=1 width=8) (never executed)

  • Index Cond: (person_root_id = leg_ver_19.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
716. 0.080 0.080 ↑ 6.0 1 1

Seq Scan on fdc_person_type_translation t_18 (cost=0.00..1.45 rows=6 width=48) (actual time=0.080..0.080 rows=1 loops=1)

  • Filter: (language_id = lang.get_current_lang_id())
  • Buffers: shared hit=1
717. 0.045 0.078 ↑ 1.0 1 1

Nested Loop (cost=1.99..6.99 rows=1 width=8) (actual time=0.078..0.078 rows=1 loops=1)

  • Buffers: shared hit=5
718. 0.003 0.017 ↑ 1.0 1 1

Nested Loop Left Join (cost=1.71..6.25 rows=1 width=8) (actual time=0.016..0.017 rows=1 loops=1)

  • Buffers: shared hit=2
719. 0.008 0.008 ↑ 1.0 1 1

Index Scan using fdc_measure_unit_pk on fdc_measure_unit c_26 (cost=0.14..0.24 rows=1 width=16) (actual time=0.007..0.008 rows=1 loops=1)

  • Index Cond: (id = own.odometer_value_unit_id)
  • Buffers: shared hit=2
720. 0.001 0.006 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.57..5.94 rows=7 width=8) (actual time=0.006..0.006 rows=0 loops=1)

721. 0.002 0.005 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.29..1.44 rows=1 width=16) (actual time=0.005..0.005 rows=0 loops=1)

722. 0.003 0.003 ↓ 0.0 0 1

Index Scan using fdc_user_pk on fdc_user usr_21 (cost=0.15..0.73 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=1)

  • Index Cond: (c_26.user_add = id)
723. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_person_root_date_uk on fdc_person per_42 (cost=0.14..0.70 rows=1 width=16) (never executed)

  • Index Cond: (person_root_id = usr_21.person_root_id)
  • Filter: ((statement_timestamp() >= date_from) AND (statement_timestamp() <= date_to))
724. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.28..4.02 rows=48 width=8) (never executed)

725. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=1.13..2.24 rows=7 width=16) (never executed)

726. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.99..1.99 rows=1 width=24) (never executed)

727. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.71..1.33 rows=1 width=24) (never executed)

728. 0.000 0.000 ↓ 0.0 0

Nested Loop (cost=0.43..0.68 rows=1 width=24) (never executed)

729. 0.000 0.000 ↓ 0.0 0

Index Scan using fdc_official_person_pk on fdc_official_person ofp_21 (cost=0.15..0.18 rows=1 width=24) (never executed)

  • Index Cond: (id = per_42.id)
730. 0.000 0.000 ↓ 0.0 0

Index Only Scan using fdc_person_pk on fdc_person per_43 (cost=0.28..0.50 rows=1 width=8) (never executed)

  • Index Cond: (id = ofp_21.id)
  • Heap Fetches: 0