explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Oqgi

Settings
# exclusive inclusive rows x rows loops node
1. 312.791 52,681.057 ↓ 7,266.4 87,197 1

Sort (cost=516,595.64..516,595.67 rows=12 width=1,110) (actual time=52,660.684..52,681.057 rows=87,197 loops=1)

  • Sort Key: (date_trunc('month'::text, rac.event_date)), (count(*)) DESC
  • Sort Method: quicksort Memory: 93053kB
  • Buffers: shared hit=14837549
2. 367.722 52,368.266 ↓ 7,266.4 87,197 1

GroupAggregate (cost=515,363.91..516,595.43 rows=12 width=1,110) (actual time=50,094.571..52,368.266 rows=87,197 loops=1)

  • Group Key: fdc_ts_cu_cat_translation.name, (COALESCE(fdc_ts_trademark_translation.name, '-'::character varying)), (COALESCE(v.commercial_name, '-'::character varying)), ((SubPlan 5)), (btrim(regexp_replace((manuf.name)::text, '[\n\r\u2028]+'::text, ' '::text, 'g'::text))), (COALESCE(((concat_ws(' '::text, CASE WHEN (c.pos_in_address_name = 1) THEN t_1.name ELSE NULL::character varying END, art.name, CASE WHEN (c.pos_in_address_name = 2) THEN t_1.name ELSE NULL::character varying END))::character varying(500)), '-'::character varying)), (COALESCE(eng_kind.name, '-'::character varying)), (COALESCE(v.manuf_ts_type_code, '-'::character varying)), (COALESCE(v.modif_name, '-'::character varying)), (COALESCE(fdc_ts_trademark_translation_1.name, '-'::character varying)), (COALESCE(v.base_ts_type, '-'::character varying)), (COALESCE(v.base_ts_model_name, '-'::character varying)), prop.wheel_arrangement_id, (COALESCE((SubPlan 7), '-'::text)), (COALESCE((prop.cnt_doors)::character varying, '-'::character varying)), (COALESCE((((SubPlan 12))::integer)::character varying, '-'::character varying)), (COALESCE((((SubPlan 13))::integer)::character varying, '-'::character varying)), (COALESCE(((eng.volume_cylinder)::integer)::character varying, '-'::character varying)), (COALESCE(((eng.maximum_power)::integer)::character varying, '-'::character varying)), (COALESCE((SubPlan 11), '-'::text)), v.manufacturer_id, v.assembly_plant_id, (COALESCE(prop.axle_wheel_quantity, '-'::character varying)), (COALESCE(btrim(regexp_replace(prop.wheel_arrangment, '[\n\r\u2028]+'::text, ' '::text, 'g'::text)), '-'::text)), (COALESCE(btrim(regexp_replace(prop.body_style, '[\n\r\u2028]+'::text, ' '::text, 'g'::text)), '-'::text)), (COALESCE((prop.cnt_seats)::character varying, '-'::character varying)), (COALESCE(fdc_ecolog_class_translation.name, '-'::character varying)), (COALESCE((COALESCE(tg.gearbox_type, gbt.name)), '-'::character varying)), fdc_pts_reg_reason_translation.name, (COALESCE((SubPlan 2), ''::text)), (COALESCE(((fdc_special_equipment_translation.name)::text || COALESCE((': '::text || (fdc_special_equipment_other_translation.name)::text), ''::text)), '-'::text)), (date_trunc('month'::text, rac.event_date))
  • Buffers: shared hit=14837549
3. 6,763.938 50,169.407 ↓ 17,619.9 211,439 1

Sort (cost=515,363.91..515,363.94 rows=12 width=1,038) (actual time=50,094.449..50,169.407 rows=211,439 loops=1)

  • Sort Key: fdc_ts_cu_cat_translation.name, (COALESCE(fdc_ts_trademark_translation.name, '-'::character varying)), (COALESCE(v.commercial_name, '-'::character varying)), ((SubPlan 5)), (btrim(regexp_replace((manuf.name)::text, '[\n\r\u2028]+'::text, ' '::text, 'g'::text))), (COALESCE(((concat_ws(' '::text, CASE WHEN (c.pos_in_address_name = 1) THEN t_1.name ELSE NULL::character varying END, art.name, CASE WHEN (c.pos_in_address_name = 2) THEN t_1.name ELSE NULL::character varying END))::character varying(500)), '-'::character varying)), (COALESCE(eng_kind.name, '-'::character varying)), (COALESCE(v.manuf_ts_type_code, '-'::character varying)), (COALESCE(v.modif_name, '-'::character varying)), (COALESCE(fdc_ts_trademark_translation_1.name, '-'::character varying)), (COALESCE(v.base_ts_type, '-'::character varying)), (COALESCE(v.base_ts_model_name, '-'::character varying)), prop.wheel_arrangement_id, (COALESCE((SubPlan 7), '-'::text)), (COALESCE((prop.cnt_doors)::character varying, '-'::character varying)), (COALESCE((((SubPlan 12))::integer)::character varying, '-'::character varying)), (COALESCE((((SubPlan 13))::integer)::character varying, '-'::character varying)), (COALESCE(((eng.volume_cylinder)::integer)::character varying, '-'::character varying)), (COALESCE(((eng.maximum_power)::integer)::character varying, '-'::character varying)), (COALESCE((SubPlan 11), '-'::text)), v.manufacturer_id, v.assembly_plant_id, (COALESCE(prop.axle_wheel_quantity, '-'::character varying)), (COALESCE(btrim(regexp_replace(prop.wheel_arrangment, '[\n\r\u2028]+'::text, ' '::text, 'g'::text)), '-'::text)), (COALESCE(btrim(regexp_replace(prop.body_style, '[\n\r\u2028]+'::text, ' '::text, 'g'::text)), '-'::text)), (COALESCE((prop.cnt_seats)::character varying, '-'::character varying)), (COALESCE(fdc_ecolog_class_translation.name, '-'::character varying)), (COALESCE((COALESCE(tg.gearbox_type, gbt.name)), '-'::character varying)), fdc_pts_reg_reason_translation.name, (COALESCE((SubPlan 2), ''::text)), (COALESCE(((fdc_special_equipment_translation.name)::text || COALESCE((': '::text || (fdc_special_equipment_other_translation.name)::text), ''::text)), '-'::text)), (date_trunc('month'::text, rac.event_date))
  • Sort Method: quicksort Memory: 220893kB
  • Buffers: shared hit=13763959
4. 1,215.736 43,405.469 ↓ 17,619.9 211,439 1

Hash Join (cost=440,183.45..515,363.7 rows=12 width=1,038) (actual time=12,856.697..43,405.469 rows=211,439 loops=1)

  • Buffers: shared hit=13763959
5. 78.703 29,926.257 ↓ 17,619.9 211,439 1

Nested Loop (cost=440,182..514,331.09 rows=12 width=1,769) (actual time=12,856.362..29,926.257 rows=211,439 loops=1)

  • Buffers: shared hit=7606704
6. 10,108.829 27,680.934 ↓ 2,519.3 216,662 1

Nested Loop (cost=440,181.57..513,786.28 rows=86 width=1,793) (actual time=12,856.313..27,680.934 rows=216,662 loops=1)

  • Filter: (btrim(((xpath('/ns3:VehicleRegistrationRequest/g:EventName/text()'::text, (md.content_data)::xml, '{{ns3,urn://x-artefacts-epts-ru/ELPTSAddRegistration/1.0.2},{g,urn://x-artefacts-epts-ru/ELPTSAddRegistration_EEC_M_TR_SimpleDataObjects/1.0.4}}'::text[]))[1])::text, '""'::text) = ANY ('{"Изготовленное за пределами Российской Федерации","Новое, изготовленное в Российской Федерации","Предмет лизинга","Регистрация нового, изготовленного в Российской Федерации"}'::text[]))
  • Buffers: shared hit=5855240
7. 599.529 16,210.705 ↓ 52.6 226,900 1

Hash Join (cost=440,181.14..490,485.91 rows=4,310 width=1,801) (actual time=12,856.12..16,210.705 rows=226,900 loops=1)

  • Buffers: shared hit=4962480
8. 132.015 11,883.158 ↓ 10.5 534,150 1

Hash Join (cost=294,129.44..342,681.61 rows=50,652 width=1,245) (actual time=9,127.272..11,883.158 rows=534,150 loops=1)

  • Buffers: shared hit=4872126
9. 134.870 11,750.791 ↓ 10.5 534,150 1

Hash Join (cost=294,064.52..341,977.22 rows=50,652 width=1,185) (actual time=9,126.904..11,750.791 rows=534,150 loops=1)

  • Buffers: shared hit=4872087
10. 151.340 11,615.904 ↓ 10.5 534,150 1

Hash Join (cost=294,062.85..341,336.55 rows=50,652 width=1,169) (actual time=9,126.874..11,615.904 rows=534,150 loops=1)

  • Buffers: shared hit=4872086
11. 149.086 11,464.548 ↓ 10.5 534,150 1

Hash Join (cost=294,061.32..340,708.18 rows=50,652 width=1,164) (actual time=9,126.845..11,464.548 rows=534,150 loops=1)

  • Buffers: shared hit=4872085
12. 963.690 11,315.416 ↓ 10.5 534,150 1

Hash Join (cost=294,054.65..340,064.17 rows=50,652 width=1,169) (actual time=9,126.773..11,315.416 rows=534,150 loops=1)

  • Buffers: shared hit=4872082
13. 1,064.954 1,613.622 ↓ 1.0 569,787 1

Hash Join (cost=37,887.75..81,649.67 rows=562,866 width=524) (actual time=388.458..1,613.622 rows=569,787 loops=1)

  • Buffers: shared hit=38837
14. 165.275 165.275 ↓ 1.0 1,279,922 1

Seq Scan on fdc_pts_transmission_node t (cost=0..33,394.82 rows=1,263,582 width=16) (actual time=0.022..165.275 rows=1,279,922 loops=1)

  • Buffers: shared hit=20759
15. 189.087 383.393 ↓ 1.0 569,787 1

Hash (cost=30,851.93..30,851.93 rows=562,866 width=524) (actual time=383.393..383.393 rows=569,787 loops=1)

  • Buffers: shared hit=18078
16. 123.241 194.306 ↓ 1.0 569,787 1

Hash Join (cost=665.66..30,851.93 rows=562,866 width=524) (actual time=0.953..194.306 rows=569,787 loops=1)

  • Buffers: shared hit=18078
17. 70.138 70.138 ↓ 1.0 571,190 1

Seq Scan on fdc_pts_transmission_node_gearbox tg (cost=0..23,078.51 rows=564,251 width=66) (actual time=0.012..70.138 rows=571,190 loops=1)

  • Buffers: shared hit=17436
18. 0.051 0.927 ↑ 1.0 314 1

Hash (cost=661.74..661.74 rows=314 width=58) (actual time=0.927..0.927 rows=314 loops=1)

  • Buffers: shared hit=642
19. 0.876 0.876 ↑ 1.0 314 1

Seq Scan on fdc_gearbox_type_translation gbt (cost=0..661.74 rows=314 width=58) (actual time=0.013..0.876 rows=314 loops=1)

  • Filter: (gbt.language_id = 94)
  • Buffers: shared hit=642
20. 533.804 8,738.104 ↓ 10.5 534,150 1

Hash (cost=255,533.74..255,533.74 rows=50,652 width=653) (actual time=8,738.104..8,738.104 rows=534,150 loops=1)

  • Buffers: shared hit=4833245
21. 1,516.469 8,204.300 ↓ 10.5 534,150 1

Hash Join (cost=149,212.8..255,533.74 rows=50,652 width=653) (actual time=5,778.376..8,204.3 rows=534,150 loops=1)

  • Buffers: shared hit=4833245
22. 909.796 909.796 ↑ 1.0 2,467,000 1

Seq Scan on fdc_pts_ts_property prop (cost=0..96,568.99 rows=2,487,399 width=236) (actual time=0.021..909.796 rows=2,467,000 loops=1)

  • Buffers: shared hit=71695
23. 459.480 5,778.035 ↓ 12.6 534,150 1

Hash (cost=148,682.53..148,682.53 rows=42,421 width=425) (actual time=5,778.035..5,778.035 rows=534,150 loops=1)

  • Buffers: shared hit=4761550
24. 107.184 5,318.555 ↓ 12.6 534,150 1

Hash Join (cost=66,967.01..148,682.53 rows=42,421 width=425) (actual time=648.967..5,318.555 rows=534,150 loops=1)

  • Buffers: shared hit=4761550
25. 134.786 5,209.711 ↓ 12.6 534,150 1

Hash Join (cost=65,943.82..147,123.78 rows=42,421 width=425) (actual time=647.292..5,209.711 rows=534,150 loops=1)

  • Buffers: shared hit=4760596
26. 1,030.349 5,074.909 ↓ 12.6 534,150 1

Hash Join (cost=65,942.68..146,775.31 rows=42,421 width=383) (actual time=647.251..5,074.909 rows=534,150 loops=1)

  • Buffers: shared hit=4760595
27. 151.402 1,587.472 ↓ 12.6 534,150 1

Hash Join (cost=29,238.68..91,490.92 rows=42,421 width=365) (actual time=302.007..1,587.472 rows=534,150 loops=1)

  • Buffers: shared hit=507797
28. 129.672 1,140.698 ↓ 12.6 534,150 1

Hash Join (cost=1,025.91..62,742.59 rows=42,421 width=280) (actual time=1.714..1,140.698 rows=534,150 loops=1)

  • Buffers: shared hit=491650
29. 127.645 1,009.391 ↓ 12.6 534,150 1

Hash Join (cost=2.73..61,183.93 rows=42,421 width=280) (actual time=0.069..1,009.391 rows=534,150 loops=1)

  • Buffers: shared hit=490696
30. 881.725 881.725 ↓ 12.6 534,150 1

Index Scan using fdc_pts_ver_ts_kind_i on fdc_pts_ver v (cost=0.43..60,678.89 rows=42,421 width=117) (actual time=0.038..881.725 rows=534,150 loops=1)

  • Index Cond: (v.type_id = 1)
  • Filter: ((v.reason_reg_id = ANY ('{1,2}'::bigint[])) AND (v.date_to > now()) AND (v.status_id = ANY ('{1,2,3,4,5}'::bigint[])))
  • Buffers: shared hit=490694
31. 0.003 0.021 ↑ 1.0 4 1

Hash (cost=2.25..2.25 rows=4 width=179) (actual time=0.021..0.021 rows=4 loops=1)

  • Buffers: shared hit=2
32. 0.018 0.018 ↑ 1.0 4 1

Seq Scan on fdc_pts_reg_reason_translation fdc_pts_reg_reason_translation (cost=0..2.25 rows=4 width=179) (actual time=0.011..0.018 rows=4 loops=1)

  • Filter: (fdc_pts_reg_reason_translation.language_id = 94)
  • Buffers: shared hit=2
33. 0.121 1.635 ↑ 1.0 920 1

Hash (cost=1,011.69..1,011.69 rows=920 width=16) (actual time=1.635..1.635 rows=920 loops=1)

  • Buffers: shared hit=954
34. 1.514 1.514 ↑ 1.0 920 1

Seq Scan on fdc_ts_trademark_translation fdc_ts_trademark_translation (cost=0..1,011.69 rows=920 width=16) (actual time=0.054..1.514 rows=920 loops=1)

  • Filter: (fdc_ts_trademark_translation.language_id = 94)
  • Buffers: shared hit=954
35. 204.290 295.372 ↑ 1.0 526,973 1

Hash (cost=21,509.56..21,509.56 rows=536,256 width=93) (actual time=295.372..295.372 rows=526,973 loops=1)

  • Buffers: shared hit=16147
36. 91.082 91.082 ↑ 1.0 526,973 1

Seq Scan on fdc_legal_person manuf (cost=0..21,509.56 rows=536,256 width=93) (actual time=0.012..91.082 rows=526,973 loops=1)

  • Buffers: shared hit=16147
37. 195.909 340.002 ↓ 1.0 570,340 1

Hash (cost=28,253..28,253 rows=563,400 width=34) (actual time=340.002..340.002 rows=570,340 loops=1)

  • Buffers: shared hit=22619
38. 144.093 144.093 ↓ 1.0 570,340 1

Seq Scan on fdc_pts_engine eng (cost=0..28,253 rows=563,400 width=34) (actual time=0.012..144.093 rows=570,340 loops=1)

  • Buffers: shared hit=22619
39.          

SubPlan (for Hash Join)

40. 0.000 2,117.086 ↑ 1.0 1 1,058,543

Aggregate (cost=8.45..8.46 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1,058,543)

  • Buffers: shared hit=4230179
41. 2,117.086 2,117.086 ↑ 1.0 1 1,058,543

Index Scan using fdc_pts_engine_psp_i on fdc_pts_engine fdc_pts_engine (cost=0.42..8.44 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=1,058,543)

  • Index Cond: (fdc_pts_engine.pasport_id = v.id)
  • Buffers: shared hit=4230179
42. 0.005 0.016 ↑ 1.0 2 1

Hash (cost=1.12..1.12 rows=2 width=58) (actual time=0.016..0.016 rows=2 loops=1)

  • Buffers: shared hit=1
43. 0.011 0.011 ↑ 1.0 2 1

Seq Scan on fdc_engine_kind_translation eng_kind (cost=0..1.12 rows=2 width=58) (actual time=0.009..0.011 rows=2 loops=1)

  • Filter: (eng_kind.language_id = 94)
  • Buffers: shared hit=1
44. 0.161 1.660 ↑ 1.0 920 1

Hash (cost=1,011.69..1,011.69 rows=920 width=16) (actual time=1.66..1.66 rows=920 loops=1)

  • Buffers: shared hit=954
45. 1.499 1.499 ↑ 1.0 920 1

Seq Scan on fdc_ts_trademark_translation fdc_ts_trademark_translation_1 (cost=0..1,011.69 rows=920 width=16) (actual time=0.05..1.499 rows=920 loops=1)

  • Filter: (fdc_ts_trademark_translation_1.language_id = 94)
  • Buffers: shared hit=954
46. 0.012 0.046 ↑ 1.0 49 1

Hash (cost=6.06..6.06 rows=49 width=11) (actual time=0.046..0.046 rows=49 loops=1)

  • Buffers: shared hit=3
47. 0.034 0.034 ↑ 1.0 49 1

Seq Scan on fdc_ts_cu_cat_translation fdc_ts_cu_cat_translation (cost=0..6.06 rows=49 width=11) (actual time=0.01..0.034 rows=49 loops=1)

  • Filter: (fdc_ts_cu_cat_translation.language_id = 94)
  • Buffers: shared hit=3
48. 0.007 0.016 ↑ 1.0 7 1

Hash (cost=1.44..1.44 rows=7 width=21) (actual time=0.016..0.016 rows=7 loops=1)

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

Seq Scan on fdc_ecolog_class_translation fdc_ecolog_class_translation (cost=0..1.44 rows=7 width=21) (actual time=0.007..0.009 rows=7 loops=1)

  • Filter: (fdc_ecolog_class_translation.language_id = 94)
  • Buffers: shared hit=1
50. 0.007 0.017 ↑ 1.0 9 1

Hash (cost=1.56..1.56 rows=9 width=32) (actual time=0.017..0.017 rows=9 loops=1)

  • Buffers: shared hit=1
51. 0.010 0.010 ↑ 1.0 9 1

Seq Scan on fdc_special_equipment_translation fdc_special_equipment_translation (cost=0..1.56 rows=9 width=32) (actual time=0.006..0.01 rows=9 loops=1)

  • Filter: (fdc_special_equipment_translation.language_id = 94)
  • Buffers: shared hit=1
52. 0.130 0.352 ↑ 1.0 508 1

Hash (cost=58.57..58.57 rows=508 width=76) (actual time=0.352..0.352 rows=508 loops=1)

  • Buffers: shared hit=39
53. 0.183 0.222 ↑ 1.0 508 1

Bitmap Heap Scan on fdc_special_equipment_other_translation fdc_special_equipment_other_translation (cost=16.22..58.57 rows=508 width=76) (actual time=0.048..0.222 rows=508 loops=1)

  • Heap Blocks: exact=36
  • Buffers: shared hit=39
54. 0.039 0.039 ↑ 1.0 508 1

Bitmap Index Scan on fdc_special_equipment_other_translation_l_i (cost=0..16.09 rows=508 width=0) (actual time=0.039..0.039 rows=508 loops=1)

  • Index Cond: (fdc_special_equipment_other_translation.language_id = 94)
  • Buffers: shared hit=3
55. 101.479 3,728.018 ↓ 2.0 226,936 1

Hash (cost=144,605.17..144,605.17 rows=115,722 width=556) (actual time=3,728.018..3,728.018 rows=226,936 loops=1)

  • Buffers: shared hit=90354
56. 1,740.967 3,626.539 ↓ 2.0 226,936 1

Nested Loop (cost=30,566.85..144,605.17 rows=115,722 width=556) (actual time=238.499..3,626.539 rows=226,936 loops=1)

  • Buffers: shared hit=90354
57. 263.054 750.892 ↓ 2.0 226,936 1

Hash Join (cost=30,564.89..142,505.52 rows=115,722 width=48) (actual time=237.754..750.892 rows=226,936 loops=1)

  • Buffers: shared hit=88853
58. 278.791 310.961 ↓ 1.1 343,202 1

Bitmap Heap Scan on fdc_request req (cost=12,937.86..123,599.23 rows=323,995 width=16) (actual time=44.767..310.961 rows=343,202 loops=1)

  • Filter: (req.message_id IS NOT NULL)
  • Heap Blocks: exact=75593
  • Buffers: shared hit=77880
59. 32.170 32.170 ↓ 1.0 343,233 1

Bitmap Index Scan on fdc_request_rtype_i (cost=0..12,856.86 rows=342,990 width=0) (actual time=32.17..32.17 rows=343,233 loops=1)

  • Index Cond: (req.request_type_id = 14)
  • Buffers: shared hit=2287
60. 62.784 176.877 ↓ 2.0 226,936 1

Hash (cost=16,180.51..16,180.51 rows=115,722 width=56) (actual time=176.877..176.877 rows=226,936 loops=1)

  • Buffers: shared hit=10973
61. 114.093 114.093 ↓ 2.0 226,936 1

Seq Scan on fdc_pts_reg_action rac (cost=0..16,180.51 rows=115,722 width=56) (actual time=0.31..114.093 rows=226,936 loops=1)

  • Filter: (date(rac.event_date) >= '2020-01-01'::date)
  • Buffers: shared hit=10973
62. 1,132.470 1,134.680 ↓ 120.0 120 226,936

Materialize (cost=1.97..363.82 rows=1 width=524) (actual time=0..0.005 rows=120 loops=226,936)

  • Buffers: shared hit=1501
63. 0.426 2.210 ↓ 120.0 120 1

Nested Loop (cost=1.97..363.82 rows=1 width=524) (actual time=0.142..2.21 rows=120 loops=1)

  • Buffers: shared hit=1501
64. 0.234 1.544 ↓ 120.0 120 1

Nested Loop (cost=1.69..363.01 rows=1 width=40) (actual time=0.075..1.544 rows=120 loops=1)

  • Buffers: shared hit=1141
65. 0.011 1.070 ↓ 120.0 120 1

Nested Loop (cost=1.69..359.61 rows=1 width=36) (actual time=0.059..1.07 rows=120 loops=1)

  • Buffers: shared hit=1021
66. 0.092 0.579 ↓ 120.0 120 1

Nested Loop (cost=1.26..351.24 rows=1 width=16) (actual time=0.045..0.579 rows=120 loops=1)

  • Buffers: shared hit=541
67. 0.025 0.118 ↓ 41.0 123 1

Nested Loop (cost=0.84..349.62 rows=3 width=8) (actual time=0.033..0.118 rows=123 loops=1)

  • Buffers: shared hit=49
68. 0.023 0.023 ↓ 1.7 5 1

Index Scan using fdc_address_l_i on fdc_address ac (cost=0.42..14.93 rows=3 width=8) (actual time=0.019..0.023 rows=5 loops=1)

  • Index Cond: (ac.address_level_id = '1'::bigint)
  • Filter: ((statement_timestamp() >= ac.date_from) AND (statement_timestamp() <= ac.date_to))
  • Buffers: shared hit=6
69. 0.070 0.070 ↑ 1.4 25 5

Index Scan using fdc_address_hierarch_all_ua_i on fdc_address_hierarch_all h (cost=0.42..111.2 rows=36 width=16) (actual time=0.005..0.014 rows=25 loops=5)

  • Index Cond: (h.upper_address_id = ac.id)
  • Buffers: shared hit=43
70. 0.369 0.369 ↑ 1.0 1 123

Index Scan using fdc_address_pk on fdc_address ar (cost=0.42..0.54 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=123)

  • Index Cond: (ar.id = h.lower_address_id)
  • Filter: ((ar.address_level_id = '2'::bigint) AND (statement_timestamp() >= ar.date_from) AND (statement_timestamp() <= ar.date_to))
  • Buffers: shared hit=492
71. 0.480 0.480 ↑ 1.0 1 120

Index Scan using fdc_address_translation_vl_i on fdc_address_translation art (cost=0.43..8.36 rows=1 width=28) (actual time=0.004..0.004 rows=1 loops=120)

  • Index Cond: ((ar.id = art.address_id) AND (art.language_id = '94'::bigint))
  • Buffers: shared hit=480
72. 0.240 0.240 ↑ 5.9 18 120

Seq Scan on fdc_address_writing_type c (cost=0..2.07 rows=107 width=12) (actual time=0.001..0.002 rows=18 loops=120)

  • Buffers: shared hit=120
73. 0.240 0.240 ↑ 1.0 1 120

Index Scan using fdc_address_writing_type_translation_vl_i on fdc_address_writing_type_translation t_1 (cost=0.28..0.78 rows=1 width=34) (actual time=0.002..0.002 rows=1 loops=120)

  • Index Cond: ((c.id = t_1.address_writing_type_id) AND (t_1.language_id = lang.get_current_lang_id()))
  • Buffers: shared hit=360
74. 1,361.400 1,361.400 ↑ 1.0 1 226,900

Index Scan using fdc_message_data_message_i on fdc_message_data md (cost=0.44..5.38 rows=1 width=320) (actual time=0.006..0.006 rows=1 loops=226,900)

  • Index Cond: (md.message_id = req.message_id)
  • Buffers: shared hit=892760
75. 1,083.310 2,166.620 ↑ 1.0 1 216,662

Index Scan using fdc_pts_root_pk on fdc_pts_root r (cost=0.43..6.32 rows=1 width=8) (actual time=0.01..0.01 rows=1 loops=216,662)

  • Index Cond: (r.id = rac.pasport_root_id)
  • Filter: ((r.epts_num IS NOT NULL) AND (SubPlan 15))
  • Buffers: shared hit=1751464
76.          

SubPlan (for Index Scan)

77. 216.662 1,083.310 ↑ 1.0 1 216,662

GroupAggregate (cost=0.42..8.45 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=216,662)

  • Group Key: fdc_pts_reg_action.pasport_root_id
  • Buffers: shared hit=884404
78. 866.648 866.648 ↑ 1.0 1 216,662

Index Scan using fdc_pts_reg_action_root_i on fdc_pts_reg_action fdc_pts_reg_action (cost=0.42..8.44 rows=1 width=16) (actual time=0.004..0.004 rows=1 loops=216,662)

  • Index Cond: (fdc_pts_reg_action.pasport_root_id = r.id)
  • Buffers: shared hit=884404
79. 0.002 0.014 ↑ 1.0 6 1

Hash (cost=1.38..1.38 rows=6 width=8) (actual time=0.014..0.014 rows=6 loops=1)

  • Buffers: shared hit=1
80. 0.012 0.012 ↑ 1.0 6 1

Seq Scan on fdc_person_type_translation ptt (cost=0..1.38 rows=6 width=8) (actual time=0.007..0.012 rows=6 loops=1)

  • Filter: (ptt.language_id = 94)
  • Buffers: shared hit=1
81.          

SubPlan (for Hash Join)

82. 634.317 2,114.390 ↑ 1.0 1 211,439

Result (cost=10.19..10.21 rows=1 width=32) (actual time=0.01..0.01 rows=1 loops=211,439)

  • Buffers: shared hit=1061995
83.          

Initplan (for Result)

84. 419.260 1,480.073 ↑ 1.0 1 211,439

Nested Loop (cost=0.42..10.19 rows=1 width=14) (actual time=0.007..0.007 rows=1 loops=211,439)

  • Buffers: shared hit=1061995
85. 845.756 845.756 ↑ 1.0 1 211,439

Index Scan using fdc_pts_colors_psp_i on fdc_pts_color pcol (cost=0.42..8.44 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=211,439)

  • Index Cond: (pcol.pasport_id = v.id)
  • Buffers: shared hit=846938
86. 215.057 215.057 ↑ 2.0 5 215,057

Seq Scan on fdc_color_translation col (cost=0..1.62 rows=10 width=22) (actual time=0.001..0.001 rows=5 loops=215,057)

  • Filter: (col.language_id = 94)
  • Buffers: shared hit=215057
87. 211.439 1,480.073 ↑ 1.0 1 211,439

Result (cost=10.99..11.01 rows=1 width=32) (actual time=0.007..0.007 rows=1 loops=211,439)

  • Buffers: shared hit=1054809
88.          

Initplan (for Result)

89. 423.841 1,268.634 ↑ 1.0 1 211,439

Nested Loop (cost=0.42..10.99 rows=1 width=37) (actual time=0.005..0.006 rows=1 loops=211,439)

  • Buffers: shared hit=1054809
90. 634.317 634.317 ↑ 1.0 1 211,439

Index Scan using fdc_pts_fuel_psp_i on fdc_pts_fuel pfuel (cost=0.42..8.44 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=211,439)

  • Index Cond: (pfuel.pasport_id = v.id)
  • Buffers: shared hit=844333
91. 210.476 210.476 ↑ 4.0 2 210,476

Seq Scan on fdc_fuel_type_translation ftr (cost=0..2.45 rows=8 width=45) (actual time=0.001..0.001 rows=2 loops=210,476)

  • Filter: (ftr.language_id = 94)
  • Buffers: shared hit=210476
92. 422.878 4,863.097 ↑ 1.0 1 211,439

Result (cost=13.44..13.45 rows=1 width=32) (actual time=0.023..0.023 rows=1 loops=211,439)

  • Buffers: shared hit=1471033
93.          

Initplan (for Result)

94. 634.317 4,440.219 ↑ 1.0 1 211,439

Sort (cost=13.43..13.44 rows=1 width=14) (actual time=0.021..0.021 rows=1 loops=211,439)

  • Sort Key: dw.name
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=1471033
95. 871.376 3,805.902 ↑ 1.0 1 211,439

Hash Join (cost=8.46..13.42 rows=1 width=14) (actual time=0.008..0.018 rows=1 loops=211,439)

  • Buffers: shared hit=1471033
96. 2,088.770 2,088.770 ↑ 1.0 25 208,877

Seq Scan on fdc_drive_wheels_translation dw (cost=0..4.86 rows=25 width=22) (actual time=0.001..0.01 rows=25 loops=208,877)

  • Filter: (dw.language_id = 94)
  • Buffers: shared hit=626631
97. 0.000 845.756 ↑ 1.0 1 211,439

Hash (cost=8.44..8.44 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=211,439)

  • Buffers: shared hit=844402
98. 845.756 845.756 ↑ 1.0 1 211,439

Index Scan using fdc_pts_driving_wheel_psp_i on fdc_pts_driving_wheel pdw (cost=0.42..8.44 rows=1 width=8) (actual time=0.003..0.004 rows=1 loops=211,439)

  • Index Cond: (pdw.pasport_id = v.id)
  • Buffers: shared hit=844402
99. 422.878 2,325.829 ↑ 1.0 1 211,439

Result (cost=17..17.01 rows=1 width=32) (actual time=0.011..0.011 rows=1 loops=211,439)

  • Buffers: shared hit=857173
100.          

Initplan (for Result)

101. 845.756 1,902.951 ↑ 1.2 4 211,439

Sort (cost=16.99..17 rows=5 width=11) (actual time=0.008..0.009 rows=4 loops=211,439)

  • Sort Key: ptr.tire_code
  • Sort Method: quicksort Memory: 25kB
  • Buffers: shared hit=857173
102. 1,057.195 1,057.195 ↑ 1.2 4 211,439

Index Scan using fdc_pts_tire_psp_i on fdc_pts_tire ptr (cost=0.43..16.93 rows=5 width=11) (actual time=0.004..0.005 rows=4 loops=211,439)

  • Index Cond: (ptr.pasport_id = v.id)
  • Buffers: shared hit=857173
103. 1,057.195 1,057.195 ↑ 1.0 1 211,439

Index Scan using fdc_pts_weight_psp_i on fdc_pts_weight fdc_pts_weight (cost=0.43..17.09 rows=1 width=5) (actual time=0.004..0.005 rows=1 loops=211,439)

  • Index Cond: (fdc_pts_weight.pasport_id = v.id)
  • Filter: (fdc_pts_weight.weight_type_id = 1)
  • Buffers: shared hit=856122
104. 422.878 422.878 ↑ 1.0 1 211,439

Index Scan using fdc_pts_weight_psp_i on fdc_pts_weight fdc_pts_weight_1 (cost=0.43..17.09 rows=1 width=5) (actual time=0.002..0.002 rows=1 loops=211,439)

  • Index Cond: (fdc_pts_weight_1.pasport_id = v.id)
  • Filter: (fdc_pts_weight_1.weight_type_id = 3)
  • Buffers: shared hit=856122
105.          

SubPlan (for GroupAggregate)

106. 0.000 1,569.546 ↑ 1.0 1 87,197

Limit (cost=0.28..8.3 rows=1 width=32) (actual time=0.018..0.018 rows=1 loops=87,197)

  • Buffers: shared hit=815980
107. 1,569.546 1,569.546 ↑ 1.0 1 87,197

Index Scan using fdc_person_address_date_uk on fdc_person_address adr (cost=0.28..8.3 rows=1 width=32) (actual time=0.018..0.018 rows=1 loops=87,197)

  • Index Cond: (adr.person_id = v.assembly_plant_id)
  • Buffers: shared hit=815980
108. 87.197 261.591 ↑ 1.0 1 87,197

Result (cost=8.3..8.31 rows=1 width=32) (actual time=0.003..0.003 rows=1 loops=87,197)

  • Buffers: shared hit=257610
109.          

Initplan (for Result)

110. 174.394 174.394 ↑ 1.0 1 87,197

Index Scan using fdc_wheel_arrangement_translation_wal_i on fdc_wheel_arrangement_translation fdc_wheel_arrangement_translation (cost=0.28..8.3 rows=1 width=6) (actual time=0.002..0.002 rows=1 loops=87,197)

  • Index Cond: ((prop.wheel_arrangement_id = fdc_wheel_arrangement_translation.wheel_arrangement_id) AND (fdc_wheel_arrangement_translation.language_id = 94))
  • Buffers: shared hit=257610