explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 64NT

Settings
# exclusive inclusive rows x rows loops node
1. 0.046 0.081 ↓ 0.0 0 1

Sort (cost=32.24..32.24 rows=1 width=87) (actual time=0.081..0.081 rows=0 loops=1)

  • Sort Key: (count(handle.id)) DESC
  • Sort Method: quicksort Memory: 25kB
2. 0.001 0.035 ↓ 0.0 0 1

GroupAggregate (cost=32.20..32.23 rows=1 width=87) (actual time=0.035..0.035 rows=0 loops=1)

  • Group Key: handle.id, handle_history.platform_uri, handle_history.username, handle_history.name
3. 0.024 0.034 ↓ 0.0 0 1

Sort (cost=32.20..32.20 rows=1 width=79) (actual time=0.034..0.034 rows=0 loops=1)

  • Sort Key: handle.id, handle_history.platform_uri, handle_history.username, handle_history.name
  • Sort Method: quicksort Memory: 25kB
4. 0.003 0.010 ↓ 0.0 0 1

Nested Loop (cost=4.11..32.19 rows=1 width=79) (actual time=0.010..0.010 rows=0 loops=1)

5. 0.001 0.007 ↓ 0.0 0 1

Nested Loop (cost=0.83..24.89 rows=1 width=25) (actual time=0.007..0.007 rows=0 loops=1)

6. 0.006 0.006 ↓ 0.0 0 1

Index Scan using posts_date_index on posts (cost=0.41..16.43 rows=1 width=4) (actual time=0.006..0.006 rows=0 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))
  • Filter: ((text_search_words @@ '''rockendrockstar'' | ''proptech'' | ''propertymanag'' | ''arpm18'' | ''pmc18'' | ''rockend'' | ''propertytre'''::tsquery) OR (mentioned_uids && '{urn:li:organization:648378,1295432328,168302926554064,1116570978400699,870775225,2193239737,4509659575}'::text[]))
7. 0.000 0.000 ↓ 0.0 0

Index Scan using handles_id_platform_id_index on handles handle (cost=0.42..8.45 rows=1 width=21) (never executed)

  • Index Cond: (id = posts.handle_id)
  • Filter: (platform_id = ANY ('{1,3,4}'::integer[]))
8. 0.000 0.000 ↓ 0.0 0

Bitmap Heap Scan on handle_histories handle_history (cost=3.27..7.29 rows=1 width=62) (never executed)

  • Recheck Cond: ((handle_id = handle.id) AND (end_timestamp = '3030-01-01 00:00:00'::timestamp without time zone))
9. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on handle_histories_handle_id_end_timestamp_desc_index (cost=0.00..3.27 rows=1 width=0) (never executed)

  • Index Cond: ((handle_id = handle.id) AND (end_timestamp = '3030-01-01 00:00:00'::timestamp without time zone))