Likes per day

[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