explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 88Q

Settings
# exclusive inclusive rows x rows loops node
1. 6.393 22.113 ↓ 2.2 1,951 1

Sort (cost=4,033.55..4,035.74 rows=878 width=766) (actual time=21.665..22.113 rows=1,951 loops=1)

  • Sort Key: date
  • Sort Method: quicksort Memory: 3340kB
2. 8.717 15.720 ↓ 2.2 1,951 1

Bitmap Heap Scan on posts (cost=1,235.36..3,990.62 rows=878 width=766) (actual time=7.087..15.720 rows=1,951 loops=1)

  • Recheck Cond: (((mentioned_topics && '{50,168,49,48}'::text[]) 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=575
3. 0.067 7.003 ↓ 0.0 0 1

BitmapAnd (cost=1,235.36..1,235.36 rows=879 width=0) (actual time=7.003..7.003 rows=0 loops=1)

4. 0.002 1.827 ↓ 0.0 0 1

BitmapOr (cost=477.78..477.78 rows=4,445 width=0) (actual time=1.827..1.827 rows=0 loops=1)

5. 1.539 1.539 ↓ 1.5 6,601 1

Bitmap Index Scan on mentioned_topics_index (cost=0.00..392.70 rows=4,360 width=0) (actual time=1.539..1.539 rows=6,601 loops=1)

  • Index Cond: (mentioned_topics && '{50,168,49,48}'::text[])
6. 0.286 0.286 ↓ 0.0 0 1

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

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

Bitmap Index Scan on posts_date_index (cost=0.00..757.11 rows=33,669 width=0) (actual time=5.109..5.109 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 : 0.413 ms
Execution time : 22.320 ms