explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lSbC

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 4,063.646 ↑ 20.0 1 1

Limit (cost=0.43..12,217.42 rows=20 width=928) (actual time=3,087.366..4,063.646 rows=1 loops=1)

2. 4,063.642 4,063.642 ↑ 789.0 1 1

Index Scan using posts_date_index on posts (cost=0.43..481,960.76 rows=789 width=928) (actual time=3,087.364..4,063.642 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: 292332
Planning time : 0.445 ms
Execution time : 4,063.684 ms