explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s1IC

Settings
# exclusive inclusive rows x rows loops node
1. 31.959 8,102.159 ↑ 1.5 11,276 1

Sort (cost=77,909.63..77,951.11 rows=16,595 width=961) (actual time=8,097.145..8,102.159 rows=11,276 loops=1)

  • Sort Key: date
  • Sort Method: external merge Disk: 10920kB
2. 7,810.812 8,070.200 ↑ 1.5 11,276 1

Bitmap Heap Scan on posts_temp (cost=9,412.20..69,711.45 rows=16,595 width=961) (actual time=260.688..8,070.200 rows=11,276 loops=1)

  • Recheck Cond: (((mentioned_topics && '{836,886,277,139,52,54,55,56,57,99,341}'::text[]) OR (mentioned_uids && '{2087947767926096,401328537106759,441940055873460,132560043518789,1196463420517229,u
  • Rows Removed by Index Recheck: 172681
  • Heap Blocks: exact=1376 lossy=22355
3. 18.440 259.388 ↓ 0.0 0 1

BitmapAnd (cost=9,412.20..9,412.20 rows=16,598 width=0) (actual time=259.388..259.388 rows=0 loops=1)

4. 0.002 146.393 ↓ 0.0 0 1

BitmapOr (cost=2,940.80..2,940.80 rows=313,667 width=0) (actual time=146.393..146.393 rows=0 loops=1)

5. 140.741 140.741 ↑ 1.3 233,043 1

Bitmap Index Scan on idx_mentioned_topics (cost=0.00..2,847.76 rows=312,502 width=0) (actual time=140.741..140.741 rows=233,043 loops=1)

  • Index Cond: (mentioned_topics && '{836,886,277,139,52,54,55,56,57,99,341}'::text[])
6. 5.650 5.650 ↑ 2.9 396 1

Bitmap Index Scan on idx_mentioned_uids (cost=0.00..84.74 rows=1,165 width=0) (actual time=5.650..5.650 rows=396 loops=1)

  • Index Cond: (mentioned_uids && '{2087947767926096,401328537106759,441940055873460,132560043518789,1196463420517229,urn:li:organizationBrand:9394172}'::text[])
7. 94.555 94.555 ↑ 1.1 280,706 1

Bitmap Index Scan on idx_posts_date (cost=0.00..6,467.00 rows=308,257 width=0) (actual time=94.555..94.555 rows=280,706 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))