uc_moodle_prod=> explain analyze SELECT instance,cmid,l.course,COUNT(l.id) as count FROM mdl_log l JOIN mdl_course_modules cm ON cm.id = cmid WHERE ((l.course = 3134 AND l.time > 1255504372) OR (l.course = 3135 AND l.time > 1255506480) OR (l.course = 261 AND l.time > 1233288356) OR (l.course = 203 AND l.time > 1255058248) OR (l.course = 2822 AND l.time > 0) OR (l.course = 2705 AND l.time > 1244523663) OR (l.course = 2128 AND l.time > 1248066856) OR (l.course = 1534 AND l.time > 1244685987) OR (l.course = 2126 AND l.time > 1251774115) OR (l.course = 1536 AND l.time > 1244175056) OR (l.course = 1535 AND l.time > 1248669883) OR (l.course = 2125 AND l.time > 1248841483) OR (l.course = 1557 AND l.time > 1244524146) OR (l.course = 232 AND l.time > 1233283336) OR (l.course = 231 AND l.time > 1233280820) OR (l.course = 219 AND l.time > 1233634554) OR (l.course = 202 AND l.time > 1247561737) OR (l.course = 1831 AND l.time > 1243580252) OR (l.course = 566 AND l.time > 1234135456) OR (l.course = 458 AND l.time > 0) OR (l.course = 2483 AND l.time > 1236383301) OR (l.course = 2326 AND l.time > 0) OR (l.course = 2328 AND l.time > 1234918764) OR (l.course = 1826 AND l.time > 1250841825) OR (l.course = 1832 AND l.time > 1238055380) OR (l.course = 2469 AND l.time > 1255329748) OR (l.course = 1614 AND l.time > 1242796355) OR (l.course = 2776 AND l.time > 1251173397) OR (l.course = 1827 AND l.time > 1250841724) OR (l.course = 924 AND l.time > 1250841771) OR (l.course = 2456 AND l.time > 1250841789) OR (l.course = 492 AND l.time > 0) OR (l.course = 1638 AND l.time > 0) ) AND l.module = 'forum' AND action ILIKE 'add post%' AND userid != 101 GROUP BY cmid,l.course,instance; HashAggregate (cost=121951.96..121952.67 rows=57 width=32) (actual time=11301.139..11301.148 rows=6 loops=1) -> Nested Loop (cost=3058.63..121951.39 rows=57 width=32) (actual time=6752.747..11301.023 rows=25 loops=1) -> Bitmap Heap Scan on mdl_log l (cost=3058.63..121486.15 rows=57 width=24) (actual time=6752.697..11300.441 rows=25 loops=1) Recheck Cond: (((course = 3134) AND ((module)::text = 'forum'::text) AND ("time" > 1255504372)) OR (("time" > 1255506480) AND (course = 3135) AND ((module)::text = 'forum'::text)) OR ((course = 261) AND ((module)::text = 'forum'::text)) OR (("time" > 1255058248) AND (course = 203) AND ((module)::text = 'forum'::text)) OR ((course = 2822) AND ((module)::text = 'forum'::text)) OR ((course = 2705) AND ((module)::text = 'forum'::text)) OR ((course = 2128) AND ((module)::text = 'forum'::text)) OR ((course = 1534) AND ((module)::text = 'forum'::text)) OR ((course = 2126) AND ((module)::text = 'forum'::text)) OR ((course = 1536) AND ((module)::text = 'forum'::text)) OR ((course = 1535) AND ((module)::text = 'forum'::text)) OR ((course = 2125) AND ((module)::text = 'forum'::text)) OR ((course = 1557) AND ((module)::text = 'forum'::text)) OR ((course = 232) AND ((module)::text = 'forum'::text)) OR ((course = 231) AND ((module)::text = 'forum'::text)) OR ((course = 219) AND ((module)::text = 'forum'::text)) OR ((course = 202) AND ((module)::text = 'forum'::text)) OR ((course = 1831) AND ((module)::text = 'forum'::text)) OR ((course = 566) AND ((module)::text = 'forum'::text)) OR ((course = 458) AND ((module)::text = 'forum'::text)) OR ((course = 2483) AND ((module)::text = 'forum'::text)) OR ((course = 2326) AND ((module)::text = 'forum'::text)) OR ((course = 2328) AND ((module)::text = 'forum'::text)) OR ((course = 1826) AND ((module)::text = 'forum'::text)) OR ((course = 1832) AND ((module)::text = 'forum'::text)) OR ((course = 2469) AND ((module)::text = 'forum'::text) AND ("time" > 1255329748)) OR ((course = 1614) AND ((module)::text = 'forum'::text)) OR ((course = 2776) AND ((module)::text = 'forum'::text)) OR ((course = 1827) AND ((module)::text = 'forum'::text)) OR ((course = 924) AND ((module)::text = 'forum'::text)) OR ((course = 2456) AND ((module)::text = 'forum'::text)) OR ((course = 492) AND ((module)::text = 'forum'::text)) OR ((course = 1638) AND ((module)::text = 'forum'::text))) Filter: (((action)::text ~~* 'add post%'::text) AND (userid <> 101) AND (((course = 3134) AND ("time" > 1255504372)) OR ((course = 3135) AND ("time" > 1255506480)) OR ((course = 261) AND ("time" > 1233288356)) OR ((course = 203) AND ("time" > 1255058248)) OR ((course = 2822) AND ("time" > 0)) OR ((course = 2705) AND ("time" > 1244523663)) OR ((course = 2128) AND ("time" > 1248066856)) OR ((course = 1534) AND ("time" > 1244685987)) OR ((course = 2126) AND ("time" > 1251774115)) OR ((course = 1536) AND ("time" > 1244175056)) OR ((course = 1535) AND ("time" > 1248669883)) OR ((course = 2125) AND ("time" > 1248841483)) OR ((course = 1557) AND ("time" > 1244524146)) OR ((course = 232) AND ("time" > 1233283336)) OR ((course = 231) AND ("time" > 1233280820)) OR ((course = 219) AND ("time" > 1233634554)) OR ((course = 202) AND ("time" > 1247561737)) OR ((course = 1831) AND ("time" > 1243580252)) OR ((course = 566) AND ("time" > 1234135456)) OR ((course = 458) AND ("time" > 0)) OR ((course = 2483) AND ("time" > 1236383301)) OR ((course = 2326) AND ("time" > 0)) OR ((course = 2328) AND ("time" > 1234918764)) OR ((course = 1826) AND ("time" > 1250841825)) OR ((course = 1832) AND ("time" > 1238055380)) OR ((course = 2469) AND ("time" > 1255329748)) OR ((course = 1614) AND ("time" > 1242796355)) OR ((course = 2776) AND ("time" > 1251173397)) OR ((course = 1827) AND ("time" > 1250841724)) OR ((course = 924) AND ("time" > 1250841771)) OR ((course = 2456) AND ("time" > 1250841789)) OR ((course = 492) AND ("time" > 0)) OR ((course = 1638) AND ("time" > 0)))) -> BitmapOr (cost=3058.63..3058.63 rows=40592 width=0) (actual time=2975.861..2975.861 rows=0 loops=1) -> BitmapAnd (cost=62.96..62.96 rows=1 width=0) (actual time=21.421..21.421 rows=0 loops=1) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=9.555..9.555 rows=4178 loops=1) Index Cond: ((course = 3134) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_tim_ix (cost=0.00..35.79 rows=1806 width=0) (actual time=11.464..11.464 rows=87675 loops=1) Index Cond: ("time" > 1255504372) -> BitmapAnd (cost=168.44..168.44 rows=1 width=0) (actual time=14.182..14.182 rows=0 loops=1) -> Bitmap Index Scan on mdl_log_tim_ix (cost=0.00..35.79 rows=1806 width=0) (actual time=8.768..8.768 rows=85138 loops=1) Index Cond: ("time" > 1255506480) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..132.37 rows=3548 width=0) (actual time=5.179..5.179 rows=13295 loops=1) Index Cond: ((course = 3135) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=0.171..0.171 rows=376 loops=1) Index Cond: ((course = 261) AND ((module)::text = 'forum'::text)) -> BitmapAnd (cost=1159.24..1159.24 rows=3 width=0) (actual time=76.169..76.169 rows=0 loops=1) -> Bitmap Index Scan on mdl_log_tim_ix (cost=0.00..35.79 rows=1806 width=0) (actual time=62.635..62.635 rows=508978 loops=1) Index Cond: ("time" > 1255058248) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..1123.17 rows=31428 width=0) (actual time=12.075..12.075 rows=61010 loops=1) Index Cond: ((course = 203) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=0.608..0.608 rows=2353 loops=1) Index Cond: ((course = 2822) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=43.129..43.129 rows=172 loops=1) Index Cond: ((course = 2705) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=398.573..398.573 rows=1982 loops=1) Index Cond: ((course = 2128) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=471.741..471.741 rows=2609 loops=1) Index Cond: ((course = 1534) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=499.085..499.085 rows=4949 loops=1) Index Cond: ((course = 2126) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=12.073..12.073 rows=25 loops=1) Index Cond: ((course = 1536) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=895.255..895.255 rows=5617 loops=1) Index Cond: ((course = 1535) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=245.431..245.431 rows=2523 loops=1) Index Cond: ((course = 2125) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=116.076..116.076 rows=145 loops=1) Index Cond: ((course = 1557) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=4.925..4.925 rows=0 loops=1) Index Cond: ((course = 232) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=12.011..12.011 rows=22 loops=1) Index Cond: ((course = 231) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=0.258..0.258 rows=631 loops=1) Index Cond: ((course = 219) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..850.89 rows=23800 width=0) (actual time=5.041..5.041 rows=5437 loops=1) Index Cond: ((course = 202) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=5.660..5.660 rows=24 loops=1) Index Cond: ((course = 1831) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=12.212..12.212 rows=9 loops=1) Index Cond: ((course = 566) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=5.176..5.176 rows=24 loops=1) Index Cond: ((course = 458) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=12.404..12.404 rows=59 loops=1) Index Cond: ((course = 2483) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=1.558..1.558 rows=18 loops=1) Index Cond: ((course = 2326) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=0.018..0.018 rows=37 loops=1) Index Cond: ((course = 2328) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=8.394..8.394 rows=25 loops=1) Index Cond: ((course = 1826) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=0.021..0.021 rows=21 loops=1) Index Cond: ((course = 1832) AND ((module)::text = 'forum'::text)) -> BitmapAnd (cost=62.96..62.96 rows=1 width=0) (actual time=48.768..48.768 rows=0 loops=1) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=13.347..13.347 rows=150 loops=1) Index Cond: ((course = 2469) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_tim_ix (cost=0.00..35.79 rows=1806 width=0) (actual time=35.405..35.405 rows=330382 loops=1) Index Cond: ("time" > 1255329748) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=5.062..5.062 rows=42 loops=1) Index Cond: ((course = 1614) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=16.589..16.589 rows=37 loops=1) Index Cond: ((course = 2776) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=7.665..7.665 rows=17 loops=1) Index Cond: ((course = 1827) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=12.626..12.626 rows=12 loops=1) Index Cond: ((course = 924) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=7.446..7.446 rows=42 loops=1) Index Cond: ((course = 2456) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=7.115..7.115 rows=12 loops=1) Index Cond: ((course = 492) AND ((module)::text = 'forum'::text)) -> Bitmap Index Scan on mdl_log_coumodact_ix (cost=0.00..26.89 rows=600 width=0) (actual time=8.824..8.824 rows=24 loops=1) Index Cond: ((course = 1638) AND ((module)::text = 'forum'::text)) -> Index Scan using mdl_courmodu_id_pk on mdl_course_modules cm (cost=0.00..8.15 rows=1 width=16) (actual time=0.013..0.014 rows=1 loops=25) Index Cond: (cm.id = l.cmid) Total runtime: 11301.455 ms (87 rows)