explain.depesz.com

PostgreSQL's explain analyze made readable

Result: gli3

Settings
# exclusive inclusive rows x rows loops node
1. 2.623 717.605 ↓ 15,148.5 30,297 1

Append (cost=7,931.37..9,584.03 rows=2 width=302) (actual time=213.663..717.605 rows=30,297 loops=1)

2.          

CTE expanded_compounds

3. 3.554 23.833 ↓ 1.0 10,017 1

HashAggregate (cost=4,109.57..4,209.61 rows=10,004 width=8) (actual time=22.239..23.833 rows=10,017 loops=1)

  • Group Key: compounds_expanded_by_structure.id
4. 0.441 20.279 ↓ 1.0 10,017 1

Append (cost=1,503.12..4,084.56 rows=10,004 width=8) (actual time=2.931..20.279 rows=10,017 loops=1)

5. 0.000 4.393 ↓ 3.6 18 1

Nested Loop Anti Join (cost=1,503.12..1,696.23 rows=5 width=8) (actual time=2.931..4.393 rows=18 loops=1)

6. 0.005 4.376 ↓ 3.6 18 1

Nested Loop (cost=1,502.97..1,695.35 rows=5 width=8) (actual time=2.922..4.376 rows=18 loops=1)

7. 0.010 4.308 ↓ 1.8 9 1

Nested Loop Semi Join (cost=1,502.68..1,666.49 rows=5 width=8) (actual time=2.908..4.308 rows=9 loops=1)

  • Join Filter: (syn_compound_2.id = ld_entities_projects_2.entity_id)
8. 0.637 4.217 ↑ 1.9 9 1

Hash Join (cost=1,502.32..1,664.98 rows=17 width=24) (actual time=2.848..4.217 rows=9 loops=1)

  • Hash Cond: ("*VALUES*_6".column1 = ld_entity_2.entity_id)
9. 1.386 1.386 ↑ 1.0 9,999 1

Values Scan on "*VALUES*_6" (cost=0.00..124.99 rows=9,999 width=32) (actual time=0.002..1.386 rows=9,999 loops=1)

10. 0.025 2.194 ↑ 1.0 121 1

Hash (cost=1,500.81..1,500.81 rows=121 width=32) (actual time=2.194..2.194 rows=121 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 17kB
11. 0.053 2.169 ↑ 1.0 121 1

Nested Loop (cost=0.29..1,500.81 rows=121 width=32) (actual time=0.030..2.169 rows=121 loops=1)

12. 1.995 1.995 ↑ 1.0 121 1

Seq Scan on syn_compound syn_compound_2 (cost=0.00..651.30 rows=121 width=16) (actual time=0.007..1.995 rows=121 loops=1)

  • Filter: (data_source_id <> 3)
  • Rows Removed by Filter: 21103
13. 0.121 0.121 ↑ 1.0 1 121

Index Scan using pk_ld_entity on ld_entity ld_entity_2 (cost=0.29..7.02 rows=1 width=16) (actual time=0.001..0.001 rows=1 loops=121)

  • Index Cond: (id = syn_compound_2.id)
14. 0.027 0.081 ↑ 2.0 1 9

Hash Join (cost=0.36..0.45 rows=2 width=8) (actual time=0.009..0.009 rows=1 loops=9)

  • Hash Cond: ("*VALUES*_7".column1 = ld_entities_projects_2.project_id)
15. 0.009 0.009 ↑ 4.0 1 9

Values Scan on "*VALUES*_7" (cost=0.00..0.05 rows=4 width=4) (actual time=0.001..0.001 rows=1 loops=9)

16. 0.009 0.045 ↑ 2.0 1 9

Hash (cost=0.34..0.34 rows=2 width=16) (actual time=0.005..0.005 rows=1 loops=9)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
17. 0.036 0.036 ↑ 2.0 1 9

Index Only Scan using entities_projects_unq on ld_entities_projects ld_entities_projects_2 (cost=0.29..0.34 rows=2 width=16) (actual time=0.004..0.004 rows=1 loops=9)

  • Index Cond: (entity_id = ld_entity_2.id)
  • Heap Fetches: 0
18. 0.063 0.063 ↓ 2.0 2 9

Index Scan using canonical_structure_id_index on syn_compound compounds_expanded_by_structure (cost=0.29..5.76 rows=1 width=16) (actual time=0.006..0.007 rows=2 loops=9)

  • Index Cond: (canonical_structure_id = syn_compound_2.canonical_structure_id)
  • Filter: (data_source_id = 3)
  • Rows Removed by Filter: 1
19. 0.018 0.018 ↓ 0.0 0 18

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.001..0.001 rows=0 loops=18)

  • Index Cond: (virtual_compound_id = compounds_expanded_by_structure.id)
  • Heap Fetches: 0
20. 2.292 15.445 ↑ 1.0 9,999 1

Hash Join (cost=2,137.06..2,288.29 rows=9,999 width=8) (actual time=11.318..15.445 rows=9,999 loops=1)

  • Hash Cond: ("*VALUES*_8".column1 = ld_entity_3.entity_id)
21. 2.241 2.241 ↑ 1.0 9,999 1

Values Scan on "*VALUES*_8" (cost=0.00..124.99 rows=9,999 width=32) (actual time=0.003..2.241 rows=9,999 loops=1)

22. 5.044 10.912 ↑ 3.3 21,236 1

Hash (cost=1,260.36..1,260.36 rows=70,136 width=16) (actual time=10.912..10.912 rows=21,236 loops=1)

  • Buckets: 131072 Batches: 1 Memory Usage: 2023kB
23. 5.868 5.868 ↑ 1.0 70,136 1

Seq Scan on ld_entity ld_entity_3 (cost=0.00..1,260.36 rows=70,136 width=16) (actual time=0.008..5.868 rows=70,136 loops=1)

24.          

CTE expanded_entities

25. 14.882 60.884 ↓ 1.0 34,374 1

HashAggregate (cost=3,350.58..3,688.60 rows=33,802 width=16) (actual time=53.521..60.884 rows=34,374 loops=1)

  • Group Key: syn_sample_2.id, syn_sample_2.compound_id
26. 1.590 46.002 ↓ 1.0 34,374 1

Append (cost=1,855.27..3,181.57 rows=33,802 width=16) (actual time=36.069..46.002 rows=34,374 loops=1)

27. 4.393 43.473 ↓ 1.0 24,357 1

Hash Join (cost=1,855.27..2,643.47 rows=23,798 width=16) (actual time=36.068..43.473 rows=24,357 loops=1)

  • Hash Cond: (expanded_compounds.numeric_entity_id = syn_sample_2.compound_id)
28. 25.464 25.464 ↓ 1.0 10,017 1

CTE Scan on expanded_compounds (cost=0.00..200.08 rows=10,004 width=8) (actual time=22.241..25.464 rows=10,017 loops=1)

29. 6.020 13.616 ↑ 1.0 48,901 1

Hash (cost=1,244.01..1,244.01 rows=48,901 width=16) (actual time=13.616..13.616 rows=48,901 loops=1)

  • Buckets: 65536 Batches: 1 Memory Usage: 2805kB
30. 7.596 7.596 ↑ 1.0 48,901 1

Seq Scan on syn_sample syn_sample_2 (cost=0.00..1,244.01 rows=48,901 width=16) (actual time=0.010..7.596 rows=48,901 loops=1)

31. 0.939 0.939 ↓ 1.0 10,017 1

CTE Scan on expanded_compounds expanded_compounds_1 (cost=0.00..200.08 rows=10,004 width=16) (actual time=0.001..0.939 rows=10,017 loops=1)

32. 0.001 61.811 ↓ 0.0 0 1

Nested Loop Semi Join (cost=33.15..836.55 rows=1 width=302) (actual time=61.811..61.811 rows=0 loops=1)

33. 0.000 61.810 ↓ 0.0 0 1

Nested Loop Left Join (cost=32.79..836.09 rows=1 width=286) (actual time=61.810..61.810 rows=0 loops=1)

34. 0.001 61.810 ↓ 0.0 0 1

Nested Loop (cost=32.50..835.76 rows=1 width=270) (actual time=61.810..61.810 rows=0 loops=1)

35. 0.000 61.809 ↓ 0.0 0 1

Nested Loop (cost=32.21..835.36 rows=1 width=247) (actual time=61.809..61.809 rows=0 loops=1)

36. 0.000 61.809 ↓ 0.0 0 1

Nested Loop (cost=32.07..835.20 rows=1 width=249) (actual time=61.809..61.809 rows=0 loops=1)

37. 0.000 61.809 ↓ 0.0 0 1

Nested Loop Left Join (cost=31.79..834.89 rows=1 width=231) (actual time=61.809..61.809 rows=0 loops=1)

38. 0.001 61.809 ↓ 0.0 0 1

Nested Loop Left Join (cost=31.64..834.73 rows=1 width=223) (actual time=61.809..61.809 rows=0 loops=1)

39. 0.000 61.808 ↓ 0.0 0 1

Nested Loop (cost=31.35..834.31 rows=1 width=204) (actual time=61.808..61.808 rows=0 loops=1)

40. 0.000 61.808 ↓ 0.0 0 1

Nested Loop Left Join (cost=31.06..833.91 rows=1 width=212) (actual time=61.808..61.808 rows=0 loops=1)

41. 0.033 61.808 ↓ 0.0 0 1

Hash Join (cost=30.92..833.75 rows=1 width=214) (actual time=61.808..61.808 rows=0 loops=1)

  • Hash Cond: (syn_observation_type.name = "*VALUES*_1".column1)
42. 0.008 61.767 ↓ 0.0 0 1

Hash Join (cost=30.82..833.64 rows=2 width=214) (actual time=61.767..61.767 rows=0 loops=1)

  • Hash Cond: (expanded_entities.numeric_entity_id = syn_observation.observed_item_id)
43. 53.522 53.522 ↑ 33,802.0 1 1

CTE Scan on expanded_entities (cost=0.00..676.04 rows=33,802 width=16) (actual time=53.522..53.522 rows=1 loops=1)

44. 0.001 8.237 ↓ 0.0 0 1

Hash (cost=30.81..30.81 rows=1 width=198) (actual time=8.237..8.237 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
45. 0.000 8.236 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.00..30.81 rows=1 width=198) (actual time=8.236..8.236 rows=0 loops=1)

  • Join Filter: (syn_observation.id = syn_observation_attachment.observation_id)
46. 0.001 8.236 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.00..29.51 rows=1 width=196) (actual time=8.236..8.236 rows=0 loops=1)

47. 0.000 8.235 ↓ 0.0 0 1

Nested Loop (cost=0.86..29.35 rows=1 width=172) (actual time=8.235..8.235 rows=0 loops=1)

48. 0.004 8.235 ↓ 0.0 0 1

Nested Loop (cost=0.71..29.19 rows=1 width=171) (actual time=8.235..8.235 rows=0 loops=1)

  • Join Filter: ("*VALUES*".column1 = syn_observation.protocol_id)
49. 0.005 0.047 ↑ 1.0 3 1

Nested Loop (cost=0.29..24.97 rows=3 width=25) (actual time=0.037..0.047 rows=3 loops=1)

50. 0.003 0.003 ↑ 1.0 3 1

Values Scan on "*VALUES*" (cost=0.00..0.04 rows=3 width=4) (actual time=0.001..0.003 rows=3 loops=1)

51. 0.039 0.039 ↑ 1.0 1 3

Index Scan using syn_observation_protocol_id_pk on syn_observation_protocol (cost=0.29..8.31 rows=1 width=21) (actual time=0.013..0.013 rows=1 loops=3)

  • Index Cond: (id = "*VALUES*".column1)
52. 8.184 8.184 ↓ 0.0 0 3

Index Scan using live_report_id on syn_observation (cost=0.42..1.31 rows=8 width=166) (actual time=2.728..2.728 rows=0 loops=3)

  • Index Cond: ((source_live_report_id = 893) AND (protocol_id = syn_observation_protocol.id))
  • Filter: ((is_published)::text = 'N'::text)
  • Rows Removed by Filter: 9903
53. 0.000 0.000 ↓ 0.0 0

Index Scan using syn_observation_type_pk on syn_observation_type (cost=0.14..0.16 rows=1 width=17) (never executed)

  • Index Cond: (id = syn_observation.type_id)
54. 0.000 0.000 ↓ 0.0 0

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

  • Index Cond: (syn_observation.document_id = id)
55. 0.000 0.000 ↓ 0.0 0

Seq Scan on syn_observation_attachment (cost=0.00..1.13 rows=13 width=10) (never executed)

56. 0.004 0.008 ↑ 1.0 4 1

Hash (cost=0.05..0.05 rows=4 width=32) (actual time=0.008..0.008 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
57. 0.004 0.004 ↑ 1.0 4 1

Values Scan on "*VALUES*_1" (cost=0.00..0.05 rows=4 width=32) (actual time=0.002..0.004 rows=4 loops=1)

58. 0.000 0.000 ↓ 0.0 0

Index Scan using syn_unit_id_pk on syn_observation_unit synconcunit (cost=0.14..0.16 rows=1 width=14) (never executed)

  • Index Cond: (syn_observation.quantity_conc_unit = id)
59. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ld_entity on ld_entity (cost=0.29..0.40 rows=1 width=8) (never executed)

  • Index Cond: (id = expanded_entities.numeric_entity_id)
  • Filter: (archived = 0)
60. 0.000 0.000 ↓ 0.0 0

Index Scan using syn_sample_id_pk on syn_sample (cost=0.29..0.41 rows=1 width=27) (never executed)

  • Index Cond: (id = expanded_entities.numeric_entity_id)
61. 0.000 0.000 ↓ 0.0 0

Index Scan using ld_complex_sample_id_unq_idx on ld_complex (cost=0.14..0.17 rows=1 width=16) (never executed)

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

Index Scan using syn_phenomenon_type_id_pk on syn_phenomenon_type (cost=0.28..0.30 rows=1 width=34) (never executed)

  • Index Cond: (id = syn_observation_protocol.phenomenon_type_id)
63. 0.000 0.000 ↓ 0.0 0

Index Scan using syn_unit_id_pk on syn_observation_unit (cost=0.14..0.16 rows=1 width=14) (never executed)

  • Index Cond: (id = syn_observation.unit_id)
64. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_ld_entity on ld_entity root_entity (cost=0.29..0.40 rows=1 width=23) (never executed)

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

Index Scan using syn_compound_pkey on syn_compound (cost=0.29..0.33 rows=1 width=24) (never executed)

  • Index Cond: (id = root_entity.id)
66. 0.000 0.000 ↓ 0.0 0

Hash Join (cost=0.36..0.45 rows=2 width=8) (never executed)

  • Hash Cond: ("*VALUES*_2".column1 = ld_entities_projects.project_id)
67. 0.000 0.000 ↓ 0.0 0

Values Scan on "*VALUES*_2" (cost=0.00..0.05 rows=4 width=4) (never executed)

68. 0.000 0.000 ↓ 0.0 0

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

69. 0.000 0.000 ↓ 0.0 0

Index Only Scan using entities_projects_unq on ld_entities_projects (cost=0.29..0.34 rows=2 width=16) (never executed)

  • Index Cond: (entity_id = root_entity.id)
  • Heap Fetches: 0
70. 3.621 653.171 ↓ 30,297.0 30,297 1

Nested Loop Semi Join (cost=45.82..849.24 rows=1 width=302) (actual time=151.851..653.171 rows=30,297 loops=1)

71. 19.673 528.362 ↓ 30,297.0 30,297 1

Nested Loop Left Join (cost=45.46..848.77 rows=1 width=286) (actual time=151.815..528.362 rows=30,297 loops=1)

72. 19.505 478.392 ↓ 30,297.0 30,297 1

Nested Loop (cost=45.17..848.44 rows=1 width=270) (actual time=151.801..478.392 rows=30,297 loops=1)

73. 0.000 428.590 ↓ 30,297.0 30,297 1

Nested Loop (cost=44.88..848.04 rows=1 width=247) (actual time=151.794..428.590 rows=30,297 loops=1)

74. 11.901 398.575 ↓ 30,297.0 30,297 1

Nested Loop (cost=44.74..847.88 rows=1 width=249) (actual time=151.788..398.575 rows=30,297 loops=1)

75. 26.243 356.377 ↓ 30,297.0 30,297 1

Nested Loop Left Join (cost=44.46..847.58 rows=1 width=231) (actual time=151.779..356.377 rows=30,297 loops=1)

76. 19.478 330.134 ↓ 30,297.0 30,297 1

Nested Loop Left Join (cost=44.31..847.42 rows=1 width=223) (actual time=151.769..330.134 rows=30,297 loops=1)

77. 19.670 280.359 ↓ 30,297.0 30,297 1

Nested Loop (cost=44.02..847.00 rows=1 width=204) (actual time=151.759..280.359 rows=30,297 loops=1)

  • Join Filter: (expanded_entities_1.numeric_entity_id = ld_entity_1.id)
78. 3.366 230.392 ↓ 30,297.0 30,297 1

Nested Loop Left Join (cost=43.73..846.65 rows=1 width=212) (actual time=151.745..230.392 rows=30,297 loops=1)

79. 9.327 196.729 ↓ 30,297.0 30,297 1

Hash Join (cost=43.59..846.49 rows=1 width=214) (actual time=151.729..196.729 rows=30,297 loops=1)

  • Hash Cond: (syn_observation_type_1.name = "*VALUES*_4".column1)
80. 21.178 187.395 ↓ 4,328.1 30,297 1

Hash Join (cost=43.49..846.36 rows=7 width=214) (actual time=151.712..187.395 rows=30,297 loops=1)

  • Hash Cond: (expanded_entities_1.numeric_entity_id = syn_observation_1.observed_item_id)
81. 14.517 14.517 ↓ 1.0 34,374 1

CTE Scan on expanded_entities expanded_entities_1 (cost=0.00..676.04 rows=33,802 width=16) (actual time=0.001..14.517 rows=34,374 loops=1)

82. 14.355 151.700 ↓ 16,033.0 48,099 1

Hash (cost=43.45..43.45 rows=3 width=198) (actual time=151.700..151.700 rows=48,099 loops=1)

  • Buckets: 65536 (originally 1024) Batches: 1 (originally 1) Memory Usage: 8091kB
83. 13.708 137.345 ↓ 16,033.0 48,099 1

Hash Right Join (cost=42.26..43.45 rows=3 width=198) (actual time=123.650..137.345 rows=48,099 loops=1)

  • Hash Cond: (syn_observation_attachment_1.observation_id = syn_observation_1.id)
84. 0.008 0.008 ↑ 1.0 13 1

Seq Scan on syn_observation_attachment syn_observation_attachment_1 (cost=0.00..1.13 rows=13 width=10) (actual time=0.007..0.008 rows=13 loops=1)

85. 15.787 123.629 ↓ 16,033.0 48,099 1

Hash (cost=42.23..42.23 rows=3 width=196) (actual time=123.629..123.629 rows=48,099 loops=1)

  • Buckets: 65536 (originally 1024) Batches: 1 (originally 1) Memory Usage: 8091kB
86. 0.000 107.842 ↓ 16,033.0 48,099 1

Nested Loop Left Join (cost=1.00..42.23 rows=3 width=196) (actual time=0.043..107.842 rows=48,099 loops=1)

87. 0.000 66.893 ↓ 16,033.0 48,099 1

Nested Loop (cost=0.86..41.75 rows=3 width=172) (actual time=0.033..66.893 rows=48,099 loops=1)

88. 6.606 25.400 ↓ 16,033.0 48,099 1

Nested Loop (cost=0.71..41.26 rows=3 width=171) (actual time=0.025..25.400 rows=48,099 loops=1)

  • Join Filter: ("*VALUES*_3".column1 = syn_observation_1.protocol_id)
89. 0.006 0.029 ↑ 1.0 3 1

Nested Loop (cost=0.29..24.97 rows=3 width=25) (actual time=0.010..0.029 rows=3 loops=1)

90. 0.005 0.005 ↑ 1.0 3 1

Values Scan on "*VALUES*_3" (cost=0.00..0.04 rows=3 width=4) (actual time=0.002..0.005 rows=3 loops=1)

91. 0.018 0.018 ↑ 1.0 1 3

Index Scan using syn_observation_protocol_id_pk on syn_observation_protocol syn_observation_protocol_1 (cost=0.29..8.31 rows=1 width=21) (actual time=0.006..0.006 rows=1 loops=3)

  • Index Cond: (id = "*VALUES*_3".column1)
92. 18.765 18.765 ↓ 130.3 16,033 3

Index Scan using syn_observation_protocol_type_quantity_idx on syn_observation syn_observation_1 (cost=0.42..3.89 rows=123 width=166) (actual time=0.010..6.255 rows=16,033 loops=3)

  • Index Cond: (protocol_id = syn_observation_protocol_1.id)
  • Filter: ((is_published)::text = 'Y'::text)
93. 48.099 48.099 ↑ 1.0 1 48,099

Index Scan using syn_observation_type_pk on syn_observation_type syn_observation_type_1 (cost=0.14..0.16 rows=1 width=17) (actual time=0.001..0.001 rows=1 loops=48,099)

  • Index Cond: (id = syn_observation_1.type_id)
94. 48.099 48.099 ↑ 1.0 1 48,099

Index Scan using syn_document_id_pk on syn_document syn_document_1 (cost=0.14..0.16 rows=1 width=40) (actual time=0.001..0.001 rows=1 loops=48,099)

  • Index Cond: (syn_observation_1.document_id = id)
95. 0.005 0.007 ↑ 1.0 4 1

Hash (cost=0.05..0.05 rows=4 width=32) (actual time=0.007..0.007 rows=4 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
96. 0.002 0.002 ↑ 1.0 4 1

Values Scan on "*VALUES*_4" (cost=0.00..0.05 rows=4 width=32) (actual time=0.001..0.002 rows=4 loops=1)

97. 30.297 30.297 ↑ 1.0 1 30,297

Index Scan using syn_unit_id_pk on syn_observation_unit synconcunit_1 (cost=0.14..0.16 rows=1 width=14) (actual time=0.001..0.001 rows=1 loops=30,297)

  • Index Cond: (syn_observation_1.quantity_conc_unit = id)
98. 30.297 30.297 ↑ 1.0 1 30,297

Index Scan using pk_ld_entity on ld_entity ld_entity_1 (cost=0.29..0.34 rows=1 width=8) (actual time=0.001..0.001 rows=1 loops=30,297)

  • Index Cond: (id = syn_observation_1.observed_item_id)
  • Filter: (archived = 0)
99. 30.297 30.297 ↑ 1.0 1 30,297

Index Scan using syn_sample_id_pk on syn_sample syn_sample_1 (cost=0.29..0.41 rows=1 width=27) (actual time=0.001..0.001 rows=1 loops=30,297)

  • Index Cond: (id = expanded_entities_1.numeric_entity_id)
100. 0.000 0.000 ↓ 0.0 0 30,297

Index Scan using ld_complex_sample_id_unq_idx on ld_complex ld_complex_1 (cost=0.14..0.17 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=30,297)

  • Index Cond: (sample_id = syn_sample_1.id)
  • Filter: (archived = 0)
101. 30.297 30.297 ↑ 1.0 1 30,297

Index Scan using syn_phenomenon_type_id_pk on syn_phenomenon_type syn_phenomenon_type_1 (cost=0.28..0.30 rows=1 width=34) (actual time=0.001..0.001 rows=1 loops=30,297)

  • Index Cond: (id = syn_observation_protocol_1.phenomenon_type_id)
102. 30.297 30.297 ↑ 1.0 1 30,297

Index Scan using syn_unit_id_pk on syn_observation_unit syn_observation_unit_1 (cost=0.14..0.16 rows=1 width=14) (actual time=0.001..0.001 rows=1 loops=30,297)

  • Index Cond: (id = syn_observation_1.unit_id)
103. 30.297 30.297 ↑ 1.0 1 30,297

Index Scan using pk_ld_entity on ld_entity root_entity_1 (cost=0.29..0.40 rows=1 width=23) (actual time=0.001..0.001 rows=1 loops=30,297)

  • Index Cond: (id = expanded_entities_1.root_entity_id)
  • Filter: (archived = 0)
104. 30.297 30.297 ↑ 1.0 1 30,297

Index Scan using syn_compound_pkey on syn_compound syn_compound_1 (cost=0.29..0.33 rows=1 width=24) (actual time=0.001..0.001 rows=1 loops=30,297)

  • Index Cond: (id = root_entity_1.id)
105. 60.594 121.188 ↑ 2.0 1 30,297

Hash Join (cost=0.36..0.45 rows=2 width=8) (actual time=0.004..0.004 rows=1 loops=30,297)

  • Hash Cond: ("*VALUES*_5".column1 = ld_entities_projects_1.project_id)
106. 0.000 0.000 ↑ 4.0 1 30,297

Values Scan on "*VALUES*_5" (cost=0.00..0.05 rows=4 width=4) (actual time=0.000..0.000 rows=1 loops=30,297)

107. 30.297 60.594 ↑ 1.0 2 30,297

Hash (cost=0.34..0.34 rows=2 width=16) (actual time=0.002..0.002 rows=2 loops=30,297)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
108. 30.297 30.297 ↑ 1.0 2 30,297

Index Only Scan using entities_projects_unq on ld_entities_projects ld_entities_projects_1 (cost=0.29..0.34 rows=2 width=16) (actual time=0.001..0.001 rows=2 loops=30,297)

  • Index Cond: (entity_id = root_entity_1.id)
  • Heap Fetches: 0
Planning time : 168.789 ms
Execution time : 721.586 ms