explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DP1Y

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 53,094.717 ↑ 20.0 1 1

Limit (cost=0.43..12,045.58 rows=20 width=930) (actual time=37,853.560..53,094.717 rows=1 loops=1)

2. 53,094.710 53,094.710 ↑ 787.0 1 1

Index Scan using posts_date_index on posts (cost=0.43..473,977.05 rows=787 width=930) (actual time=37,853.556..53,094.710 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: 280722