explain.depesz.com

PostgreSQL's explain analyze made readable

Result: j3qo

Settings
# exclusive inclusive rows x rows loops node
1. 47.218 2,866.482 ↑ 1.6 16,023 1

Sort (cost=112,747.72..112,810.81 rows=25,236 width=961) (actual time=2,857.784..2,866.482 rows=16,023 loops=1)

  • Sort Key: date
  • Sort Method: external merge Disk: 15592kB
2. 2,478.577 2,819.264 ↑ 1.6 16,023 1

Bitmap Heap Scan on posts_temp (cost=10,927.66..100,206.57 rows=25,236 width=961) (actual time=341.829..2,819.264 rows=16,023 loops=1)

  • Recheck Cond: (((mentioned_topics && '{836,886,277,39,152,354,455,56,757,199,341,836,886,277,139,52,54,55,56,57,99,341}'::text[]) OR (mentioned_uids && '{2087947767926096,401328537106759,44194005
  • Rows Removed by Index Recheck: 233215
  • Heap Blocks: exact=1789 lossy=30519
3. 28.199 340.687 ↓ 0.0 0 1

BitmapAnd (cost=10,927.66..10,927.66 rows=25,241 width=0) (actual time=340.687..340.687 rows=0 loops=1)

4. 0.002 249.784 ↓ 0.0 0 1

BitmapOr (cost=4,454.10..4,454.10 rows=476,998 width=0) (actual time=249.784..249.784 rows=0 loops=1)

5. 243.928 243.928 ↑ 1.4 332,068 1

Bitmap Index Scan on idx_mentioned_topics (cost=0.00..4,356.75 rows=475,833 width=0) (actual time=243.928..243.928 rows=332,068 loops=1)

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

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

  • Index Cond: (mentioned_uids && '{2087947767926096,401328537106759,441940055873460,132560043518789,1196463420517229,urn:li:organizationBrand:9394172}'::text[])
7. 62.704 62.704 ↑ 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=62.704..62.704 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))