explain.depesz.com

PostgreSQL's explain analyze made readable

Result: xo7f

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 133.407 ↑ 1.0 20 1

Limit (cost=26,467.07..26,467.12 rows=20 width=797) (actual time=133.389..133.407 rows=20 loops=1)

2. 0.849 133.405 ↑ 38.0 20 1

Sort (cost=26,467.07..26,468.97 rows=761 width=797) (actual time=133.388..133.405 rows=20 loops=1)

  • Sort Key: date
  • Sort Method: top-N heapsort Memory: 40kB
3. 132.556 132.556 ↑ 1.1 721 1

Seq Scan on posts_temp (cost=0.00..26,446.82 rows=761 width=797) (actual time=15.123..132.556 rows=721 loops=1)

  • Filter: ((date >= '2019-05-05 14:00:00'::timestamp without time zone) AND (date <= '2019-05-13 13:59:59.999999'::timestamp without time zone) AND ((mentioned_topics && '{52,54,55,56,57,99,341}'::text[]) OR (mentioned_uids && '{2087947767926096,401328537106759,441940055873460,132560043518789,1196463420517229,urn:li:organizationBrand:9394172}'::text[])))
  • Rows Removed by Filter: 159170
Planning time : 5.189 ms
Execution time : 134.050 ms