explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Z4On

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 70,448.900 ↑ 20.0 1 1

Limit (cost=0.43..12,217.42 rows=20 width=928) (actual time=23,740.915..70,448.900 rows=1 loops=1)

2. 70,448.897 70,448.897 ↑ 789.0 1 1

Index Scan using posts_date_index on posts (cost=0.43..481,960.76 rows=789 width=928) (actual time=23,740.914..70,448.897 rows=1 loops=1)

  • Index Cond: ((date >= '2019-05-05 14:00:00'::timestamp without time zone) AND (date <= '2019-05-13 13:59:59.999999'::timestamp without time zone))
  • Filter: ((text_search_words @@ '''microsoftineduc'' | ''microsofteduc'''::tsquery) OR (mentioned_uids && '{2087947767926096,401328537106759,441940055873460,132560043518789,1196463420517229,urn:li
  • Rows Removed by Filter: 294444