Changes between Version 88 and Version 89 of QueryOptimization
- Timestamp:
- 06/30/26 23:20:53 (5 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
QueryOptimization
v88 v89 47 47 }}} 48 48 49 ||= QUERY PLAN = ||49 ||= QUERY PLAN = = =|| 50 50 ||Nested Loop (cost\=1.01..9625.30 rows\=2264 width\=54) (actual time\=0.868..2.190 rows\=775.00 loops\=1)|| 51 ||Buffers :shared hit\=21 read\=13 dirtied\=1||51 ||Buffers shared hit\=21 read\=13 dirtied\=1|| 52 52 ||-> Nested Loop (cost\=0.57..25.51 rows\=6 width\=38) (actual time\=0.622..0.627 rows\=5.00 loops\=1)|| 53 ||Buffers :shared read\=6||53 ||Buffers shared read\=6|| 54 54 || -> Index Scan using ""Venue_pkey"" on ""Venue"" v (cost\=0.29..8.30 rows\=1 width\=28) (actual time\=0.071..0.072 rows\=1.00 loops\=1)|| 55 ||Index Cond :(venue_id \= 1)||56 ||Index Searches :1||57 ||Buffers :shared read\=3||55 ||Index Cond (venue_id \= 1)|| 56 ||Index Searches 1|| 57 ||Buffers shared read\=3|| 58 58 || -> Index Scan using uq_section_venue_name on ""Section"" s (cost\=0.29..17.14 rows\=6 width\=18) (actual time\=0.548..0.550 rows\=5.00 loops\=1)|| 59 ||Index Cond :(venue_id \= 1)||60 ||Index Searches :1||61 ||Buffers :shared read\=3||59 ||Index Cond (venue_id \= 1)|| 60 ||Index Searches 1|| 61 ||Buffers shared read\=3|| 62 62 || -> Index Scan using uq_seat_section_number on ""Seat"" st (cost\=0.44..1590.95 rows\=901 width\=24) (actual time\=0.056..0.282 rows\=155.00 loops\=5)|| 63 ||Index Cond :(section_id \= s.section_id)||64 ||Index Searches :5||65 ||Buffers :shared hit\=21 read\=7 dirtied\=1||63 ||Index Cond (section_id \= s.section_id)|| 64 ||Index Searches 5|| 65 ||Buffers shared hit\=21 read\=7 dirtied\=1|| 66 66 ||Planning|| 67 ||Buffers :shared hit\=14 read\=22||68 ||Planning Time :5.752 ms||69 ||Execution Time :2.271 ms||67 ||Buffers shared hit\=14 read\=22|| 68 ||Planning Time 5.752 ms|| 69 ||Execution Time 2.271 ms|| 70 70 71 71 * '''INSERT''' … … 79 79 }}} 80 80 81 ||= QUERY PLAN = ||81 ||= QUERY PLAN = = =|| 82 82 ||Insert on ""Seat"" (cost\=0.00..0.01 rows\=0 width\=0) (actual time\=4.492..4.493 rows\=0.00 loops\=1)|| 83 ||Buffers :shared hit\=5 read\=6 dirtied\=3||83 ||Buffers shared hit\=5 read\=6 dirtied\=3|| 84 84 ||-> Result (cost\=0.00..0.01 rows\=1 width\=24) (actual time\=0.001..0.001 rows\=1.00 loops\=1)|| 85 ||Planning Time :0.033 ms||86 ||Trigger for constraint fk_seat_section :time\=0.243 calls\=1||87 ||Execution Time :4.752 ms||85 ||Planning Time 0.033 ms|| 86 ||Trigger for constraint fk_seat_section time\=0.243 calls\=1|| 87 ||Execution Time 4.752 ms|| 88 88 89 89 * '''UPDATE''' … … 96 96 }}} 97 97 98 ||= QUERY PLAN = ||98 ||= QUERY PLAN = = =|| 99 99 ||Update on ""Seat"" (cost\=0.44..8.46 rows\=0 width\=0) (actual time\=0.101..0.102 rows\=0.00 loops\=1)|| 100 ||Buffers :shared hit\=12||100 ||Buffers shared hit\=12|| 101 101 || -> Index Scan using ""Seat_pkey"" on ""Seat"" (cost\=0.44..8.46 rows\=1 width\=10) (actual time\=0.031..0.032 rows\=1.00 loops\=1)|| 102 ||Index Cond :(seat_id \= 99999999)||103 ||Index Searches :1||104 ||Buffers :shared hit\=4||105 ||Planning Time :0.125 ms||106 ||Execution Time :0.133 ms||102 ||Index Cond (seat_id \= 99999999)|| 103 ||Index Searches 1|| 104 ||Buffers shared hit\=4|| 105 ||Planning Time 0.125 ms|| 106 ||Execution Time 0.133 ms|| 107 107 108 108 ==== 5. Оптимизација и индексирање:
