explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 5AYx

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 111.752 ↑ 1.0 20 1

Limit (cost=0.43..1,263.83 rows=20 width=961) (actual time=1.496..111.752 rows=20 loops=1)

2. 111.741 111.741 ↑ 829.8 20 1

Index Scan using idx_posts_date on posts_temp (cost=0.43..1,048,307.52 rows=16,595 width=961) (actual time=1.496..111.741 rows=20 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: ((mentioned_topics && '{836,886,277,139,52,54,55,56,57,99,341}'::text[]) OR (mentioned_uids && '{2087947767926096,401328537106759,441940055873460,132560043518789,1196463420517229,urn:li:o
  • Rows Removed by Filter: 391