[postgres@sofa ~]$ sql_tdwtf likes_per_day WITH p1000 AS ( SELECT date_trunc('day',pa.created_at), COUNT(*) FROM posts p JOIN post_actions pa on p.id=pa.post_id WHERE pa.post_action_type_id=2 AND p.topic_id = 1000 GROUP BY date_trunc('day',pa.created_at) ), xp1000 AS ( SELECT date_trunc('day',pa.created_at), COUNT(*) FROM posts p JOIN post_actions pa on p.id=pa.post_id WHERE pa.post_action_type_id=2 AND p.topic_id != 1000 GROUP BY date_trunc('day',pa.created_at) ) SELECT xp1000.date_trunc, p1000.count p1000, xp1000.count xp1000 FROM p1000 FULL JOIN xp1000 on xp1000.date_trunc = p1000.date_trunc date_trunc | p1000 | xp1000 ---------------------+-------+-------- 2014-05-01 00:00:00 | | 1 2014-05-20 00:00:00 | | 96 2014-05-21 00:00:00 | | 246 2014-05-22 00:00:00 | | 238 2014-05-23 00:00:00 | | 467 2014-05-24 00:00:00 | | 118 2014-05-25 00:00:00 | | 96 2014-05-26 00:00:00 | | 121 2014-05-27 00:00:00 | | 180 2014-05-28 00:00:00 | | 157 2014-05-29 00:00:00 | | 184 2014-05-30 00:00:00 | | 261 2014-05-31 00:00:00 | | 293 2014-06-01 00:00:00 | | 200 2014-06-02 00:00:00 | | 739 2014-06-03 00:00:00 | | 1049 2014-06-04 00:00:00 | | 544 2014-06-05 00:00:00 | | 259 2014-06-06 00:00:00 | | 453 2014-06-07 00:00:00 | | 255 2014-06-08 00:00:00 | | 254 2014-06-09 00:00:00 | | 348 2014-06-10 00:00:00 | | 500 2014-06-11 00:00:00 | | 445 2014-06-12 00:00:00 | | 326 2014-06-13 00:00:00 | | 461 2014-06-14 00:00:00 | | 200 2014-06-15 00:00:00 | | 197 2014-06-16 00:00:00 | | 385 2014-06-17 00:00:00 | | 436 2014-06-18 00:00:00 | | 768 2014-06-19 00:00:00 | 3962 | 788 2014-06-20 00:00:00 | 8865 | 929 2014-06-21 00:00:00 | 1500 | 244 2014-06-22 00:00:00 | 121 | 123 2014-06-23 00:00:00 | 1527 | 473 2014-06-24 00:00:00 | 1976 | 619 2014-06-25 00:00:00 | 2210 | 1115 2014-06-26 00:00:00 | 1812 | 563 2014-06-27 00:00:00 | 2727 | 715 2014-06-28 00:00:00 | 57 | 197 2014-06-29 00:00:00 | 102 | 117 2014-06-30 00:00:00 | 3023 | 691 2014-07-01 00:00:00 | 3787 | 599 2014-07-02 00:00:00 | 2244 | 875 2014-07-03 00:00:00 | 2158 | 721 2014-07-04 00:00:00 | 401 | 474 2014-07-05 00:00:00 | 740 | 162 2014-07-06 00:00:00 | 57 | 81 2014-07-07 00:00:00 | 1619 | 440 2014-07-08 00:00:00 | 568 | 536 2014-07-09 00:00:00 | 974 | 500 2014-07-10 00:00:00 | 1711 | 526 2014-07-11 00:00:00 | 817 | 436 2014-07-12 00:00:00 | 65 | 129 2014-07-13 00:00:00 | 1117 | 198 2014-07-14 00:00:00 | 1843 | 787 2014-07-15 00:00:00 | 5366 | 465 2014-07-16 00:00:00 | 4753 | 621 2014-07-17 00:00:00 | 2970 | 422 2014-07-18 00:00:00 | 4613 | 714 2014-07-19 00:00:00 | 3221 | 200 2014-07-20 00:00:00 | 1885 | 87 2014-07-21 00:00:00 | 5819 | 354 2014-07-22 00:00:00 | 6043 | 426 2014-07-23 00:00:00 | 5536 | 340 2014-07-24 00:00:00 | 6272 | 330 2014-07-25 00:00:00 | 24039 | 368 2014-07-26 00:00:00 | 13192 | 1000 2014-07-27 00:00:00 | 6497 | 119 2014-07-28 00:00:00 | 13908 | 545 2014-07-29 00:00:00 | 6372 | 597 2014-07-30 00:00:00 | 1983 | 459 2014-07-31 00:00:00 | 2159 | 378 2014-08-01 00:00:00 | 2580 | 516 2014-08-02 00:00:00 | 394 | 241 2014-08-03 00:00:00 | 417 | 210 2014-08-04 00:00:00 | 2494 | 652 2014-08-05 00:00:00 | 1620 | 686 2014-08-06 00:00:00 | 3607 | 454 2014-08-07 00:00:00 | 5219 | 651 2014-08-08 00:00:00 | 7656 | 828 2014-08-09 00:00:00 | 2049 | 244 2014-08-10 00:00:00 | 1812 | 262 2014-08-11 00:00:00 | 3308 | 702 2014-08-12 00:00:00 | 1513 | 685 2014-08-13 00:00:00 | 2082 | 581 2014-08-14 00:00:00 | 3293 | 667 2014-08-15 00:00:00 | 2692 | 1262 2014-08-16 00:00:00 | 1119 | 300 2014-08-17 00:00:00 | 941 | 163 2014-08-18 00:00:00 | 2976 | 1005 2014-08-19 00:00:00 | 3407 | 823 2014-08-20 00:00:00 | 5244 | 1077 2014-08-21 00:00:00 | 7768 | 1285 2014-08-22 00:00:00 | 5545 | 874 2014-08-23 00:00:00 | 1711 | 339 2014-08-24 00:00:00 | 2236 | 228 2014-08-25 00:00:00 | 4957 | 676 2014-08-26 00:00:00 | 6142 | 516 2014-08-27 00:00:00 | 8713 | 592 2014-08-28 00:00:00 | 4550 | 511 2014-08-29 00:00:00 | 4744 | 710 2014-08-30 00:00:00 | 1740 | 284 2014-08-31 00:00:00 | 685 | 273 2014-09-01 00:00:00 | 1936 | 576 2014-09-02 00:00:00 | 2076 | 781 2014-09-03 00:00:00 | 3167 | 754 2014-09-04 00:00:00 | 3610 | 820 2014-09-05 00:00:00 | 3755 | 1175 2014-09-06 00:00:00 | 899 | 499 2014-09-07 00:00:00 | 701 | 427 2014-09-08 00:00:00 | 2036 | 990 2014-09-09 00:00:00 | 2301 | 998 2014-09-10 00:00:00 | 4332 | 1004 2014-09-11 00:00:00 | 4008 | 684 2014-09-12 00:00:00 | 3044 | 805 2014-09-13 00:00:00 | 2442 | 283 2014-09-14 00:00:00 | 2514 | 287 2014-09-15 00:00:00 | 3613 | 844 2014-09-16 00:00:00 | 5904 | 954 2014-09-17 00:00:00 | 5501 | 1057 2014-09-18 00:00:00 | 2997 | 1256 2014-09-19 00:00:00 | 4102 | 1502 2014-09-20 00:00:00 | 3051 | 326 2014-09-21 00:00:00 | 1695 | 303 2014-09-22 00:00:00 | 6828 | 980 2014-09-23 00:00:00 | 4625 | 1026 2014-09-24 00:00:00 | 6753 | 933 2014-09-25 00:00:00 | 9683 | 843 2014-09-26 00:00:00 | 6566 | 1036 2014-09-27 00:00:00 | 1549 | 367 2014-09-28 00:00:00 | 1468 | 249 2014-09-29 00:00:00 | 4171 | 1064 2014-09-30 00:00:00 | 2952 | 783 2014-10-01 00:00:00 | 2689 | 1183 2014-10-02 00:00:00 | 3262 | 1321 2014-10-03 00:00:00 | 3853 | 1011 2014-10-04 00:00:00 | 1404 | 371 2014-10-05 00:00:00 | 850 | 250 2014-10-06 00:00:00 | 3448 | 1065 2014-10-07 00:00:00 | 2692 | 1205 2014-10-08 00:00:00 | 4833 | 1269 2014-10-09 00:00:00 | 6519 | 1661 2014-10-10 00:00:00 | 6052 | 1361 2014-10-11 00:00:00 | 3391 | 333 2014-10-12 00:00:00 | 3311 | 377 2014-10-13 00:00:00 | 2805 | 821 2014-10-14 00:00:00 | 1516 | 805 2014-10-15 00:00:00 | 4087 | 1139 2014-10-16 00:00:00 | 6504 | 1604 2014-10-17 00:00:00 | 5311 | 1246 2014-10-18 00:00:00 | 2055 | 340 2014-10-19 00:00:00 | 6261 | 340 2014-10-20 00:00:00 | 6973 | 1171 2014-10-21 00:00:00 | 6204 | 1266 2014-10-22 00:00:00 | 8052 | 1474 2014-10-23 00:00:00 | 6401 | 1198 2014-10-24 00:00:00 | 5195 | 1040 2014-10-25 00:00:00 | 3932 | 390 2014-10-26 00:00:00 | 3648 | 293 2014-10-27 00:00:00 | 5042 | 955 2014-10-28 00:00:00 | 4378 | 1246 2014-10-29 00:00:00 | 4927 | 1369 2014-10-30 00:00:00 | 4962 | 1136 2014-10-31 00:00:00 | 5849 | 1286 2014-11-01 00:00:00 | 76 | 132 (167 rows) Elapsed: 4.681s Backup taken: 2014-11-01 12:39:59.508719