Changes between Version 86 and Version 87 of QueryOptimization
- Timestamp:
- 06/30/26 22:43:11 (5 days ago)
Legend:
- Unmodified
- Added
- Removed
- Modified
-
QueryOptimization
v86 v87 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 =|| = =||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||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||81 ||= QUERY PLAN =|| 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|| 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|| 88 88 89 89 * '''UPDATE''' … … 96 96 }}} 97 97 98 ||= QUERY PLAN =|| = =||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||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||98 ||= QUERY PLAN =|| 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|| 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|| 107 107 108 108 ==== 5. Оптимизација и индексирање:
