explain.depesz.com

PostgreSQL's explain analyze made readable

Result: WyR6

Settings
# exclusive inclusive rows x rows loops node
1. 0.394 11,616.173 ↑ 11.8 995 1

Sort (cost=771,690.80..771,720.26 rows=11,785 width=85) (actual time=11,616.078..11,616.173 rows=995 loops=1)

  • Sort Key: (count(handle.id)) DESC
  • Sort Method: quicksort Memory: 168kB
2. 2.448 11,615.779 ↑ 11.8 995 1

GroupAggregate (cost=770,599.23..770,893.86 rows=11,785 width=85) (actual time=11,612.494..11,615.779 rows=995 loops=1)

  • Group Key: handle.id, handle_history.platform_uri, handle_history.username, handle_history.name
3. 10.002 11,613.331 ↑ 1.2 10,050 1

Sort (cost=770,599.23..770,628.70 rows=11,785 width=77) (actual time=11,612.483..11,613.331 rows=10,050 loops=1)

  • Sort Key: handle.id, handle_history.platform_uri, handle_history.username, handle_history.name
  • Sort Method: quicksort Memory: 1800kB
4. 483.202 11,603.329 ↑ 1.2 10,050 1

Nested Loop (cost=65,180.26..769,802.29 rows=11,785 width=77) (actual time=1,770.595..11,603.329 rows=10,050 loops=1)

  • -> Index Scan using handle_histories_handle_end_timestamp_unique_index on handle_histories handle_history (cost=0.43..57.06 rows=18 width=60) (actual time=0.034..0.047 rows=1 loops=
5. 175.603 11,120.127 ↑ 1.1 10,050 1

Hash Join (cost=65,179.84..113,494.34 rows=11,465 width=25) (actual time=1,769.604..11,120.127 rows=10,050 loops=1)

  • Hash Cond: (posts.handle_id = handle.id)
  • Index Cond: (handle_id = handle.id)
6. 9,205.256 10,036.280 ↑ 1.1 10,051 1

Bitmap Heap Scan on posts (cost=16,362.12..57,310.99 rows=11,465 width=4) (actual time=850.611..10,036.280 rows=10,051 loops=1)

  • Recheck Cond: (((text_search_words @@ '''rockendrockstar'' | ''proptech'' | ''propertymanag'' | ''arpm18'' | ''pmc18'' | ''rockend'' | ''propertytre'''::tsquery) OR (menti
  • Rows Removed by Index Recheck: 75823
  • Heap Blocks: exact=7769 lossy=8393
7. 20.238 831.024 ↓ 0.0 0 1

BitmapAnd (cost=16,362.12..16,362.12 rows=11,468 width=0) (actual time=831.024..831.024 rows=0 loops=1)

8. 0.002 348.729 ↓ 0.0 0 1

BitmapOr (cost=5,635.58..5,635.58 rows=241,847 width=0) (actual time=348.729..348.729 rows=0 loops=1)

9. 226.625 226.625 ↑ 1.1 222,096 1

Bitmap Index Scan on tsw_idx (cost=0.00..3,835.69 rows=240,491 width=0) (actual time=226.625..226.625 rows=222,096 loops=1)

  • Index Cond: (text_search_words @@ '''rockendrockstar'' | ''proptech'' | ''propertymanag'' | ''arpm18'' | ''pmc18'' | ''rockend'' | ''propertytre'''::tsqu
10. 122.102 122.102 ↑ 1.9 721 1

Bitmap Index Scan on mentioned_uids_index (cost=0.00..1,794.17 rows=1,356 width=0) (actual time=122.102..122.102 rows=721 loops=1)

  • Index Cond: (mentioned_uids && '{urn:li:organization:648378,1295432328,168302926554064,1116570978400699,870775225,2193239737,4509659575}'::text[])
11. 462.057 462.057 ↓ 1.1 316,815 1

Bitmap Index Scan on posts_date_index (cost=0.00..10,723.42 rows=275,499 width=0) (actual time=462.057..462.057 rows=316,815 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))
12. 349.472 908.244 ↓ 1.0 1,247,423 1

Hash (cost=26,515.09..26,515.09 rows=1,214,770 width=21) (actual time=908.244..908.244 rows=1,247,423 loops=1)

  • Buckets: 65536 Batches: 32 Memory Usage: 2641kB
13. 558.772 558.772 ↓ 1.0 1,247,423 1

Seq Scan on handles handle (cost=0.00..26,515.09 rows=1,214,770 width=21) (actual time=0.013..558.772 rows=1,247,423 loops=1)

  • Filter: (platform_id = ANY ('{1,3,4}'::integer[]))
  • Rows Removed by Filter: 38
Planning time : 94.896 ms
Execution time : 11,617.025 ms