Sort:  
  • Trending
    • [-]
     7 years ago 

    @emrebeyler I added an index for it (took about 15 minutes) with

    CREATE INDEX ON hive_posts_cache((json::json->>'app'));

    and then I could query like this

    SELECT json::json->>'app' as app, author, permlink, body, created_at from hive_posts_cache where json::json->>'app' like 'busy%' order by post_id desc limit 100

    image.png

    $1.35
    • Past Payouts $1.35
    • - Author $1.09
    • - Curators $0.26
    2 votes
    Reply
    [-]
     7 years ago (edited)

    This is great @jrawsthorne!

    How long does this example query take to complete after the index?

    $0.00
      Reply
      [-]
       7 years ago 

      145ms
      image.png

      $0.00
        Reply
        [-]
         7 years ago 

        Fantastic. Thanks for the tip. I will try adding an additional index after the hive update/migration.

        $0.00
          Reply

          Coin Marketplace

          STEEM 0.09
          TRX 0.30
          JST 0.037
          BTC 104966.95
          ETH 3556.65
          USDT 1.00
          SBD 0.57