explain.depesz.com

PostgreSQL's explain analyze made readable

Result: mAVIv

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 83,566.990 ↑ 20.0 1 1

Limit (cost=0.43..12,217.42 rows=20 width=928) (actual time=39,071.754..83,566.990 rows=1 loops=1)

2. 83,566.985 83,566.985 ↑ 789.0 1 1

Index Scan Backward using posts_date_index on posts (cost=0.43..481,960.76 rows=789 width=928) (actual time=39,071.753..83,566.985 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: 292085
Planning time : 3.082 ms
Execution time : 83,567.024 ms