explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 1rPG

Settings
# exclusive inclusive rows x rows loops node
1. 154.886 150,313.716 ↓ 738.3 64,971 1

Append (cost=233,429.87..298,836.00 rows=88 width=313) (actual time=105,709.808..150,313.716 rows=64,971 loops=1)

2.          

CTE expanded_compounds

3. 31.895 548.621 ↓ 1.6 10,299 1

HashAggregate (cost=43,399.07..43,462.03 rows=6,296 width=8) (actual time=534.765..548.621 rows=10,299 loops=1)

  • Group Key: compounds_expanded_by_structure.id
4. 27.535 516.726 ↓ 1.9 11,770 1

Append (cost=1.95..43,383.33 rows=6,296 width=8) (actual time=0.344..516.726 rows=11,770 loops=1)

5. 22.481 421.267 ↓ 5.2 6,783 1

Nested Loop Anti Join (cost=1.95..22,513.88 rows=1,309 width=8) (actual time=0.342..421.267 rows=6,783 loops=1)

6. 31.997 385.220 ↓ 5.2 6,783 1

Nested Loop (cost=1.80..22,291.13 rows=1,310 width=8) (actual time=0.326..385.220 rows=6,783 loops=1)

7. 20.314 270.739 ↓ 18.0 4,852 1

Nested Loop (cost=1.37..22,097.09 rows=270 width=8) (actual time=0.281..270.739 rows=4,852 loops=1)

8. 20.662 210.529 ↓ 3.0 4,987 1

Nested Loop Semi Join (cost=0.94..21,276.54 rows=1,679 width=16) (actual time=0.231..210.529 rows=4,987 loops=1)

9. 17.486 75.166 ↑ 1.0 4,987 1

Nested Loop (cost=0.43..20,806.49 rows=4,987 width=8) (actual time=0.098..75.166 rows=4,987 loops=1)

10. 7.810 7.810 ↑ 1.0 4,987 1

Values Scan on "*VALUES*_4" (cost=0.00..62.34 rows=4,987 width=32) (actual time=0.004..7.810 rows=4,987 loops=1)

11. 49.870 49.870 ↑ 1.0 1 4,987

Index Only Scan using jamesf1 on ld_entity ld_entity_2 (cost=0.43..4.16 rows=1 width=18) (actual time=0.010..0.010 rows=1 loops=4,987)

  • Index Cond: (entity_id = "*VALUES*_4".column1)
  • Heap Fetches: 0
12. 29.922 114.701 ↑ 1.0 1 4,987

Hash Join (cost=0.51..0.60 rows=1 width=8) (actual time=0.023..0.023 rows=1 loops=4,987)

  • Hash Cond: ("*VALUES*_5".column1 = ld_entities_projects_2.project_id)
13. 4.987 4.987 ↑ 5.0 1 4,987

Values Scan on "*VALUES*_5" (cost=0.00..0.06 rows=5 width=4) (actual time=0.001..0.001 rows=1 loops=4,987)

14. 24.935 79.792 ↑ 1.0 2 4,987

Hash (cost=0.48..0.48 rows=2 width=16) (actual time=0.016..0.016 rows=2 loops=4,987)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
15. 54.857 54.857 ↑ 1.0 2 4,987

Index Only Scan using entities_projects_unq on ld_entities_projects ld_entities_projects_2 (cost=0.43..0.48 rows=2 width=16) (actual time=0.008..0.011 rows=2 loops=4,987)

  • Index Cond: (entity_id = ld_entity_2.id)
  • Heap Fetches: 0
16. 39.896 39.896 ↑ 1.0 1 4,987

Index Scan using syn_compound_pkey on syn_compound syn_compound_2 (cost=0.43..0.49 rows=1 width=16) (actual time=0.008..0.008 rows=1 loops=4,987)

  • Index Cond: (id = ld_entity_2.id)
  • Filter: (data_source_id <> '1'::bigint)
  • Rows Removed by Filter: 0
17. 82.484 82.484 ↑ 1.0 1 4,852

Index Scan using canonical_structure_id_index on syn_compound compounds_expanded_by_structure (cost=0.43..0.71 rows=1 width=16) (actual time=0.008..0.017 rows=1 loops=4,852)

  • Index Cond: (canonical_structure_id = syn_compound_2.canonical_structure_id)
  • Filter: (data_source_id = '1'::bigint)
  • Rows Removed by Filter: 9
18. 13.566 13.566 ↓ 0.0 0 6,783

Index Only Scan using ld_compound_unlink_virtual_compound_id_key on ld_compound_unlink (cost=0.15..0.17 rows=1 width=8) (actual time=0.002..0.002 rows=0 loops=6,783)

  • Index Cond: (virtual_compound_id = compounds_expanded_by_structure.id)
  • Heap Fetches: 0
19. 20.206 67.924 ↑ 1.0 4,987 1

Nested Loop (cost=0.43..20,806.49 rows=4,987 width=8) (actual time=0.033..67.924 rows=4,987 loops=1)

20. 7.822 7.822 ↑ 1.0 4,987 1

Values Scan on "*VALUES*_6" (cost=0.00..62.34 rows=4,987 width=32) (actual time=0.008..7.822 rows=4,987 loops=1)

21. 39.896 39.896 ↑ 1.0 1 4,987

Index Only Scan using jamesf1 on ld_entity ld_entity_3 (cost=0.43..4.16 rows=1 width=18) (actual time=0.008..0.008 rows=1 loops=4,987)

  • Index Cond: (entity_id = "*VALUES*_6".column1)
  • Heap Fetches: 0
22.          

CTE expanded_entities

23. 106.654 983.440 ↓ 1.2 36,213 1

HashAggregate (cost=95,836.97..96,128.23 rows=29,126 width=16) (actual time=930.404..983.440 rows=36,213 loops=1)

  • Group Key: syn_sample_2.id, syn_sample_2.compound_id
24. 83.936 876.786 ↓ 1.2 36,213 1

Append (cost=0.43..95,691.34 rows=29,126 width=16) (actual time=534.811..876.786 rows=36,213 loops=1)

25. 92.987 780.176 ↓ 1.1 25,914 1

Nested Loop (cost=0.43..95,274.16 rows=22,830 width=16) (actual time=534.808..780.176 rows=25,914 loops=1)

26. 573.900 573.900 ↓ 1.6 10,299 1

CTE Scan on expanded_compounds (cost=0.00..125.92 rows=6,296 width=8) (actual time=534.769..573.900 rows=10,299 loops=1)

27. 113.289 113.289 ↑ 1.3 3 10,299

Index Scan using syn_sample_compound_id_lot_id_idx on syn_sample syn_sample_2 (cost=0.43..15.07 rows=4 width=16) (actual time=0.006..0.011 rows=3 loops=10,299)

  • Index Cond: (compound_id = expanded_compounds.numeric_entity_id)
28. 12.674 12.674 ↓ 1.6 10,299 1

CTE Scan on expanded_compounds expanded_compounds_1 (cost=0.00..125.92 rows=6,296 width=16) (actual time=0.002..12.674 rows=10,299 loops=1)

29. 289.441 111,659.685 ↓ 746.8 64,971 1

Nested Loop Semi Join (cost=93,839.61..98,453.01 rows=87 width=313) (actual time=105,709.804..111,659.685 rows=64,971 loops=1)

30. 247.187 110,003.333 ↓ 251.3 65,091 1

Nested Loop (cost=93,839.10..98,428.11 rows=259 width=329) (actual time=105,709.734..110,003.333 rows=65,091 loops=1)

31. 180.764 109,560.873 ↓ 251.3 65,091 1

Hash Left Join (cost=93,838.82..98,350.40 rows=259 width=324) (actual time=105,709.712..109,560.873 rows=65,091 loops=1)

  • Hash Cond: (syn_observation.quantity_conc_unit = synconcunit.id)
32. 242.357 109,375.406 ↓ 251.3 65,091 1

Nested Loop (cost=93,773.54..98,284.44 rows=259 width=322) (actual time=105,704.990..109,375.406 rows=65,091 loops=1)

33. 272.372 108,937.776 ↓ 251.3 65,091 1

Nested Loop (cost=93,773.26..98,205.01 rows=259 width=305) (actual time=105,704.972..108,937.776 rows=65,091 loops=1)

34. 241.188 108,470.131 ↓ 251.3 65,091 1

Nested Loop Left Join (cost=93,772.84..98,091.45 rows=259 width=300) (actual time=105,704.946..108,470.131 rows=65,091 loops=1)

35. 253.331 107,968.579 ↓ 251.3 65,091 1

Nested Loop (cost=93,772.41..97,965.40 rows=259 width=284) (actual time=105,704.925..107,968.579 rows=65,091 loops=1)

36. 169.142 107,454.340 ↓ 249.0 65,227 1

Hash Left Join (cost=93,771.97..96,236.17 rows=262 width=259) (actual time=105,704.898..107,454.340 rows=65,227 loops=1)

  • Hash Cond: (syn_observation.id = syn_observation_attachment.observation_id)
37. 352.425 107,285.187 ↓ 249.0 65,227 1

Nested Loop Left Join (cost=93,737.90..96,166.38 rows=262 width=227) (actual time=105,704.862..107,285.187 rows=65,227 loops=1)

38. 170.505 106,019.584 ↓ 249.0 65,227 1

Hash Join (cost=93,737.04..94,431.41 rows=262 width=200) (actual time=105,704.795..106,019.584 rows=65,227 loops=1)

  • Hash Cond: (expanded_entities.numeric_entity_id = ld_entity.id)
39. 1,075.306 1,075.306 ↓ 1.2 36,213 1

CTE Scan on expanded_entities (cost=0.00..582.52 rows=29,126 width=16) (actual time=930.408..1,075.306 rows=36,213 loops=1)

40. 7,020.653 104,773.773 ↓ 59.1 4,059,322 1

Hash (cost=92,879.06..92,879.06 rows=68,639 width=200) (actual time=104,773.772..104,773.773 rows=4,059,322 loops=1)

  • Buckets: 4194304 (originally 131072) Batches: 1 (originally 1) Memory Usage: 619467kB
41. 10,701.187 97,753.120 ↓ 59.1 4,059,322 1

Hash Join (cost=73.48..92,879.06 rows=68,639 width=200) (actual time=5.396..97,753.120 rows=4,059,322 loops=1)

  • Hash Cond: (syn_observation.unit_id = syn_observation_unit.id)
42. 15,420.718 87,047.130 ↓ 59.1 4,059,322 1

Nested Loop (cost=8.20..92,633.19 rows=68,639 width=198) (actual time=0.572..87,047.130 rows=4,059,322 loops=1)

43. 10,296.291 55,389.124 ↓ 58.4 4,059,322 1

Hash Left Join (cost=7.77..59,471.52 rows=69,463 width=190) (actual time=0.538..55,389.124 rows=4,059,322 loops=1)

  • Hash Cond: (syn_observation.document_id = syn_document.id)
44. 14,310.403 45,092.466 ↓ 58.4 4,059,322 1

Nested Loop (cost=1.00..59,278.53 rows=69,463 width=162) (actual time=0.150..45,092.466 rows=4,059,322 loops=1)

45. 9,366.917 14,544.775 ↓ 41.8 4,059,322 1

Nested Loop (cost=0.56..4,697.49 rows=97,214 width=16) (actual time=0.120..14,544.775 rows=4,059,322 loops=1)

46. 0.056 0.056 ↑ 1.0 14 1

Values Scan on "*VALUES*" (cost=0.00..0.18 rows=14 width=4) (actual time=0.003..0.056 rows=14 loops=1)

47. 5,177.802 5,177.802 ↓ 41.8 289,952 14

Index Only Scan using ld_addable_columns_observatio_addable_column_id_observation_key on ld_addable_columns_observations (cost=0.56..266.08 rows=6,944 width=16) (actual time=0.025..369.843 rows=289,952 loops=14)

  • Index Cond: (addable_column_id = "*VALUES*".column1)
  • Heap Fetches: 0
48. 16,237.288 16,237.288 ↑ 1.0 1 4,059,322

Index Scan using syn_observation_pk on syn_observation (cost=0.44..0.56 rows=1 width=154) (actual time=0.004..0.004 rows=1 loops=4,059,322)

  • Index Cond: (id = ld_addable_columns_observations.observation_id)
  • Filter: ((is_published)::text = 'Y'::text)
49. 0.194 0.367 ↑ 1.0 123 1

Hash (cost=5.23..5.23 rows=123 width=44) (actual time=0.365..0.367 rows=123 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 18kB
50. 0.173 0.173 ↑ 1.0 123 1

Seq Scan on syn_document (cost=0.00..5.23 rows=123 width=44) (actual time=0.008..0.173 rows=123 loops=1)

51. 16,237.288 16,237.288 ↑ 1.0 1 4,059,322

Index Scan using pk_ld_entity on ld_entity (cost=0.43..0.48 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=4,059,322)

  • Index Cond: (id = syn_observation.observed_item_id)
  • Filter: (archived = 0)
52. 2.448 4.803 ↑ 1.0 1,879 1

Hash (cost=41.79..41.79 rows=1,879 width=18) (actual time=4.802..4.803 rows=1,879 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 115kB
53. 2.355 2.355 ↑ 1.0 1,879 1

Seq Scan on syn_observation_unit (cost=0.00..41.79 rows=1,879 width=18) (actual time=0.006..2.355 rows=1,879 loops=1)

54. 391.362 913.178 ↑ 1.0 1 65,227

Nested Loop Left Join (cost=0.85..6.61 rows=1 width=35) (actual time=0.011..0.014 rows=1 loops=65,227)

55. 326.135 326.135 ↑ 1.0 1 65,227

Index Scan using syn_sample_id_pk on syn_sample (cost=0.43..6.14 rows=1 width=27) (actual time=0.004..0.005 rows=1 loops=65,227)

  • Index Cond: (id = expanded_entities.numeric_entity_id)
56. 195.681 195.681 ↓ 0.0 0 65,227

Index Scan using ld_complex_sample_id_unq_idx on ld_complex (cost=0.42..0.47 rows=1 width=16) (actual time=0.003..0.003 rows=0 loops=65,227)

  • Index Cond: (sample_id = syn_sample.id)
  • Filter: (archived = 0)
57. 0.003 0.011 ↓ 0.0 0 1

Hash (cost=20.70..20.70 rows=1,070 width=40) (actual time=0.010..0.011 rows=0 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 16kB
58. 0.008 0.008 ↓ 0.0 0 1

Seq Scan on syn_observation_attachment (cost=0.00..20.70 rows=1,070 width=40) (actual time=0.007..0.008 rows=0 loops=1)

59. 260.908 260.908 ↑ 1.0 1 65,227

Index Scan using pk_ld_entity on ld_entity root_entity (cost=0.43..6.60 rows=1 width=25) (actual time=0.004..0.004 rows=1 loops=65,227)

  • Index Cond: (id = expanded_entities.root_entity_id)
  • Filter: (archived = 0)
  • Rows Removed by Filter: 0
60. 260.364 260.364 ↑ 1.0 1 65,091

Index Scan using syn_compound_pkey on syn_compound (cost=0.43..0.49 rows=1 width=24) (actual time=0.004..0.004 rows=1 loops=65,091)

  • Index Cond: (id = root_entity.id)
61. 195.273 195.273 ↑ 1.0 1 65,091

Index Scan using syn_observation_protocol_id_pk on syn_observation_protocol (cost=0.42..0.44 rows=1 width=21) (actual time=0.003..0.003 rows=1 loops=65,091)

  • Index Cond: (id = syn_observation.protocol_id)
62. 195.273 195.273 ↑ 1.0 1 65,091

Index Scan using syn_phenomenon_type_id_pk on syn_phenomenon_type (cost=0.29..0.31 rows=1 width=33) (actual time=0.003..0.003 rows=1 loops=65,091)

  • Index Cond: (id = syn_observation_protocol.phenomenon_type_id)
63. 2.410 4.703 ↑ 1.0 1,879 1

Hash (cost=41.79..41.79 rows=1,879 width=18) (actual time=4.702..4.703 rows=1,879 loops=1)

  • Buckets: 2048 Batches: 1 Memory Usage: 115kB
64. 2.293 2.293 ↑ 1.0 1,879 1

Seq Scan on syn_observation_unit synconcunit (cost=0.00..41.79 rows=1,879 width=18) (actual time=0.007..2.293 rows=1,879 loops=1)

65. 195.273 195.273 ↑ 1.0 1 65,091

Index Scan using syn_observation_type_pk on syn_observation_type (cost=0.28..0.30 rows=1 width=21) (actual time=0.003..0.003 rows=1 loops=65,091)

  • Index Cond: (id = syn_observation.type_id)
66. 325.455 1,366.911 ↑ 1.0 1 65,091

Hash Join (cost=0.51..0.60 rows=1 width=8) (actual time=0.021..0.021 rows=1 loops=65,091)

  • Hash Cond: ("*VALUES*_1".column1 = ld_entities_projects.project_id)
67. 130.182 130.182 ↑ 5.0 1 65,091

Values Scan on "*VALUES*_1" (cost=0.00..0.06 rows=5 width=4) (actual time=0.001..0.002 rows=1 loops=65,091)

68. 455.637 911.274 ↓ 1.5 3 65,091

Hash (cost=0.48..0.48 rows=2 width=16) (actual time=0.014..0.014 rows=3 loops=65,091)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
69. 455.637 455.637 ↓ 1.5 3 65,091

Index Only Scan using entities_projects_unq on ld_entities_projects (cost=0.43..0.48 rows=2 width=16) (actual time=0.004..0.007 rows=3 loops=65,091)

  • Index Cond: (entity_id = root_entity.id)
  • Heap Fetches: 0
70. 0.003 38,499.145 ↓ 0.0 0 1

Nested Loop Semi Join (cost=951.94..60,791.86 rows=1 width=313) (actual time=38,499.144..38,499.145 rows=0 loops=1)

71. 0.002 38,499.142 ↓ 0.0 0 1

Nested Loop Left Join (cost=951.43..60,791.25 rows=1 width=329) (actual time=38,499.141..38,499.142 rows=0 loops=1)

  • Join Filter: (syn_observation_1.id = syn_observation_attachment_1.observation_id)
72. 0.003 38,499.140 ↓ 0.0 0 1

Nested Loop (cost=951.43..60,757.17 rows=1 width=297) (actual time=38,499.139..38,499.140 rows=0 loops=1)

73. 0.002 38,499.137 ↓ 0.0 0 1

Nested Loop (cost=951.14..60,756.87 rows=1 width=280) (actual time=38,499.136..38,499.137 rows=0 loops=1)

74. 0.003 38,499.135 ↓ 0.0 0 1

Nested Loop (cost=950.73..60,753.50 rows=1 width=275) (actual time=38,499.133..38,499.135 rows=0 loops=1)

75. 0.003 38,499.132 ↓ 0.0 0 1

Nested Loop Left Join (cost=950.45..60,753.18 rows=1 width=273) (actual time=38,499.130..38,499.132 rows=0 loops=1)

76. 0.003 38,499.129 ↓ 0.0 0 1

Nested Loop Left Join (cost=950.30..60,753.01 rows=1 width=245) (actual time=38,499.128..38,499.129 rows=0 loops=1)

77. 0.003 38,499.126 ↓ 0.0 0 1

Nested Loop (cost=949.88..60,752.53 rows=1 width=229) (actual time=38,499.125..38,499.126 rows=0 loops=1)

78. 0.002 38,499.123 ↓ 0.0 0 1

Nested Loop Left Join (cost=949.44..60,745.93 rows=1 width=204) (actual time=38,499.122..38,499.123 rows=0 loops=1)

79. 0.003 38,499.121 ↓ 0.0 0 1

Hash Join (cost=948.59..60,739.31 rows=1 width=177) (actual time=38,499.119..38,499.121 rows=0 loops=1)

  • Hash Cond: (ld_entity_1.id = expanded_entities_1.numeric_entity_id)
80. 0.003 38,499.118 ↓ 0.0 0 1

Nested Loop (cost=1.99..59,712.54 rows=22 width=177) (actual time=38,499.117..38,499.118 rows=0 loops=1)

81. 0.003 38,499.115 ↓ 0.0 0 1

Nested Loop (cost=1.71..59,704.21 rows=22 width=172) (actual time=38,499.114..38,499.115 rows=0 loops=1)

82. 0.003 38,499.112 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.28..59,528.60 rows=22 width=164) (actual time=38,499.111..38,499.112 rows=0 loops=1)

83. 11,853.018 38,499.109 ↓ 0.0 0 1

Nested Loop (cost=1.00..59,521.56 rows=22 width=162) (actual time=38,499.108..38,499.109 rows=0 loops=1)

84. 9,349.527 14,468.125 ↓ 41.8 4,059,322 1

Nested Loop (cost=0.56..4,697.49 rows=97,214 width=16) (actual time=0.035..14,468.125 rows=4,059,322 loops=1)

85. 0.058 0.058 ↑ 1.0 14 1

Values Scan on "*VALUES*_2" (cost=0.00..0.18 rows=14 width=4) (actual time=0.002..0.058 rows=14 loops=1)

86. 5,118.540 5,118.540 ↓ 41.8 289,952 14

Index Only Scan using ld_addable_columns_observatio_addable_column_id_observation_key on ld_addable_columns_observations ld_addable_columns_observations_1 (cost=0.56..266.08 rows=6,944 width=16) (actual time=0.014..365.610 rows=289,952 loops=14)

  • Index Cond: (addable_column_id = "*VALUES*_2".column1)
  • Heap Fetches: 0
87. 12,177.966 12,177.966 ↓ 0.0 0 4,059,322

Index Scan using syn_observation_pk on syn_observation syn_observation_1 (cost=0.44..0.56 rows=1 width=154) (actual time=0.003..0.003 rows=0 loops=4,059,322)

  • Index Cond: (id = ld_addable_columns_observations_1.observation_id)
  • Filter: (((is_published)::text = 'N'::text) AND (source_live_report_id = '15865'::bigint))
  • Rows Removed by Filter: 1
88. 0.000 0.000 ↓ 0.0 0

Index Scan using syn_unit_id_pk on syn_observation_unit synconcunit_1 (cost=0.28..0.32 rows=1 width=18) (never executed)

  • Index Cond: (syn_observation_1.quantity_conc_unit = id)
89. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ld_entity on ld_entity ld_entity_1 (cost=0.43..7.98 rows=1 width=8) (never executed)

  • Index Cond: (id = syn_observation_1.observed_item_id)
  • Filter: (archived = 0)
90. 0.000 0.000 ↓ 0.0 0

Index Scan using syn_observation_type_pk on syn_observation_type syn_observation_type_1 (cost=0.28..0.38 rows=1 width=21) (never executed)

  • Index Cond: (id = syn_observation_1.type_id)
91. 0.000 0.000 ↓ 0.0 0

Hash (cost=582.52..582.52 rows=29,126 width=16) (never executed)

92. 0.000 0.000 ↓ 0.0 0

CTE Scan on expanded_entities expanded_entities_1 (cost=0.00..582.52 rows=29,126 width=16) (never executed)

93. 0.000 0.000 ↓ 0.0 0

Nested Loop Left Join (cost=0.85..6.61 rows=1 width=35) (never executed)

94. 0.000 0.000 ↓ 0.0 0

Index Scan using syn_sample_id_pk on syn_sample syn_sample_1 (cost=0.43..6.14 rows=1 width=27) (never executed)

  • Index Cond: (id = expanded_entities_1.numeric_entity_id)
95. 0.000 0.000 ↓ 0.0 0

Index Scan using ld_complex_sample_id_unq_idx on ld_complex ld_complex_1 (cost=0.42..0.47 rows=1 width=16) (never executed)

  • Index Cond: (sample_id = syn_sample_1.id)
  • Filter: (archived = 0)
96. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ld_entity on ld_entity root_entity_1 (cost=0.43..6.60 rows=1 width=25) (never executed)

  • Index Cond: (id = expanded_entities_1.root_entity_id)
  • Filter: (archived = 0)
97. 0.000 0.000 ↓ 0.0 0

Index Scan using syn_compound_pkey on syn_compound syn_compound_1 (cost=0.43..0.49 rows=1 width=24) (never executed)

  • Index Cond: (id = root_entity_1.id)
98. 0.000 0.000 ↓ 0.0 0

Index Scan using syn_document_id_pk on syn_document syn_document_1 (cost=0.14..0.16 rows=1 width=44) (never executed)

  • Index Cond: (syn_observation_1.document_id = id)
99. 0.000 0.000 ↓ 0.0 0

Index Scan using syn_unit_id_pk on syn_observation_unit syn_observation_unit_1 (cost=0.28..0.32 rows=1 width=18) (never executed)

  • Index Cond: (id = syn_observation_1.unit_id)
100. 0.000 0.000 ↓ 0.0 0

Index Scan using syn_observation_protocol_id_pk on syn_observation_protocol syn_observation_protocol_1 (cost=0.42..3.37 rows=1 width=21) (never executed)

  • Index Cond: (id = syn_observation_1.protocol_id)
101. 0.000 0.000 ↓ 0.0 0

Index Scan using syn_phenomenon_type_id_pk on syn_phenomenon_type syn_phenomenon_type_1 (cost=0.29..0.31 rows=1 width=33) (never executed)

  • Index Cond: (id = syn_observation_protocol_1.phenomenon_type_id)
102. 0.000 0.000 ↓ 0.0 0

Seq Scan on syn_observation_attachment syn_observation_attachment_1 (cost=0.00..20.70 rows=1,070 width=40) (never executed)

103. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.51..0.60 rows=1 width=8) (never executed)

  • Hash Cond: ("*VALUES*_3".column1 = ld_entities_projects_1.project_id)
104. 0.000 0.000 ↓ 0.0 0

Values Scan on "*VALUES*_3" (cost=0.00..0.06 rows=5 width=4) (never executed)

105. 0.000 0.000 ↓ 0.0 0

Hash (cost=0.48..0.48 rows=2 width=16) (never executed)

106. 0.000 0.000 ↓ 0.0 0

Index Only Scan using entities_projects_unq on ld_entities_projects ld_entities_projects_1 (cost=0.43..0.48 rows=2 width=16) (never executed)

  • Index Cond: (entity_id = root_entity_1.id)
  • Heap Fetches: 0
Planning time : 254.023 ms
Execution time : 150,396.460 ms