explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bRgl

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 30,266.110 ↑ 1.0 20 1

Limit (cost=523,855.66..523,855.71 rows=20 width=961) (actual time=30,266.100..30,266.110 rows=20 loops=1)

2. 2.837 30,266.104 ↑ 534.4 20 1

Sort (cost=523,855.66..523,882.38 rows=10,688 width=961) (actual time=30,266.098..30,266.104 rows=20 loops=1)

  • Sort Key: date
  • Sort Method: top-N heapsort Memory: 42kB
3. 30,207.931 30,263.267 ↑ 1.5 7,321 1

Bitmap Heap Scan on posts_temp (cost=1,920.48..523,571.25 rows=10,688 width=961) (actual time=60.384..30,263.267 rows=7,321 loops=1)

  • Recheck Cond: ((mentioned_topics && '{52,54,55,56,57,99,341}'::text[]) OR (mentioned_uids && '{2087947767926096,401328537106759,441940055873460,132560043518789,1196463420517229,urn:li:organ
  • Rows Removed by Index Recheck: 965361
  • 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))
  • Rows Removed by Filter: 144529
  • Heap Blocks: exact=23945 lossy=109073
4. 0.002 55.336 ↓ 0.0 0 1

BitmapOr (cost=1,920.48..1,920.48 rows=202,018 width=0) (actual time=55.336..55.336 rows=0 loops=1)

5. 55.196 55.196 ↑ 1.3 151,461 1

Bitmap Index Scan on idx_mentioned_topics (cost=0.00..1,830.40 rows=200,853 width=0) (actual time=55.196..55.196 rows=151,461 loops=1)

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

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

  • Index Cond: (mentioned_uids && '{2087947767926096,401328537106759,441940055873460,132560043518789,1196463420517229,urn:li:organizationBrand:9394172}'::text[])
Planning time : 0.243 ms
Execution time : 30,266.162 ms