explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AAB4

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

Limit (cost=0.43..12,217.47 rows=20 width=928) (actual time=536.069..1,103.721 rows=1 loops=1)

  • Planning time: 0.356 ms
  • Execution time: 1103.747 ms
2. 1,103.718 1,103.718 ↑ 789.0 1 1

Index Scan using posts_date_index on posts (cost=0.43..481,962.73 rows=789 width=928) (actual time=536.067..1,103.718 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: 297181