explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Wf2d

Settings
# exclusive inclusive rows x rows loops node
1. 2.996 24.711 ↓ 4.6 2,425 1

Sort (cost=2,875.47..2,876.79 rows=529 width=766) (actual time=24.225..24.711 rows=2,425 loops=1)

  • Sort Key: date
  • Sort Method: quicksort Memory: 3622kB
2. 11.837 21.715 ↓ 4.6 2,425 1

Bitmap Heap Scan on posts (cost=1,077.86..2,851.54 rows=529 width=766) (actual time=10.010..21.715 rows=2,425 loops=1)

  • Recheck Cond: (((text_search_words @@ '''propertymanag'''::tsquery) OR (mentioned_uids && '{2087947767926096,401328537106759,441940055873460,132560043518789,1196463420517229,urn:li:organizationBrand:9394172}'::text[])) AND (date >= '2019-05-05 14:00:00'::timestamp without time zone) AND (date <= '2019-05-17 13:59:59.999999'::timestamp without time zone))
  • Heap Blocks: exact=1072
3. 0.127 9.878 ↓ 0.0 0 1

BitmapAnd (cost=1,077.86..1,077.86 rows=530 width=0) (actual time=9.878..9.878 rows=0 loops=1)

4. 0.003 3.284 ↓ 0.0 0 1

BitmapOr (cost=320.36..320.36 rows=2,680 width=0) (actual time=3.284..3.284 rows=0 loops=1)

5. 3.014 3.014 ↓ 3.1 7,998 1

Bitmap Index Scan on tsw_idx (cost=0.00..235.46 rows=2,595 width=0) (actual time=3.014..3.014 rows=7,998 loops=1)

  • Index Cond: (text_search_words @@ '''propertymanag'''::tsquery)
6. 0.267 0.267 ↓ 0.0 0 1

Bitmap Index Scan on mentioned_uids_index (cost=0.00..84.64 rows=85 width=0) (actual time=0.267..0.267 rows=0 loops=1)

  • Index Cond: (mentioned_uids && '{2087947767926096,401328537106759,441940055873460,132560043518789,1196463420517229,urn:li:organizationBrand:9394172}'::text[])
7. 6.467 6.467 ↓ 1.1 38,529 1

Bitmap Index Scan on posts_date_index (cost=0.00..757.11 rows=33,669 width=0) (actual time=6.467..6.467 rows=38,529 loops=1)

  • Index Cond: ((date >= '2019-05-05 14:00:00'::timestamp without time zone) AND (date <= '2019-05-17 13:59:59.999999'::timestamp without time zone))
Planning time : 2.242 ms
Execution time : 24.954 ms