explain.depesz.com

PostgreSQL's explain analyze made readable

Result: cQTM

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 37,659.345 ↑ 610.0 1 1

Sort (cost=702,041.74..702,043.27 rows=610 width=1,417) (actual time=37,659.345..37,659.345 rows=1 loops=1)

  • Sort Key: posts_temp.date DESC
  • Sort Method: quicksort Memory: 26kB
2. 0.006 37,659.332 ↑ 610.0 1 1

Nested Loop (cost=5,899.43..702,013.52 rows=610 width=1,417) (actual time=11,043.892..37,659.332 rows=1 loops=1)

3. 0.007 37,657.103 ↑ 592.0 1 1

Nested Loop (cost=5,899.00..667,605.49 rows=592 width=1,015) (actual time=11,041.664..37,657.103 rows=1 loops=1)

4. 37,583.617 37,656.123 ↑ 806.0 1 1

Bitmap Heap Scan on posts_temp (cost=5,898.57..661,104.74 rows=806 width=978) (actual time=11,040.685..37,656.123 rows=1 loops=1)

  • Recheck 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))
  • Rows Removed by Index Recheck: 350615
  • Filter: ((text_search_words @@ '''microsoftineduc'' | ''microsofteduc'''::tsquery) OR (mentioned_uids && '{2087947767926096,401328537106759,441940055873460,132560043518789,11964634205
  • Rows Removed by Filter: 280705
  • Heap Blocks: exact=25067 lossy=81611
5. 72.506 72.506 ↑ 1.0 280,706 1

Bitmap Index Scan on idx_posts_date (cost=0.00..5,898.37 rows=281,394 width=0) (actual time=72.506..72.506 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))
6. 0.973 0.973 ↑ 1.0 1 1

Index Scan using handles_id_platform_id_index on handles handle (cost=0.43..8.06 rows=1 width=37) (actual time=0.973..0.973 rows=1 loops=1)

  • Index Cond: ((id = posts_temp.handle_id) AND (platform_id = 3))
7. 2.223 2.223 ↑ 18.0 1 1

Index Scan using handle_histories_handle_end_timestamp_unique_index on handle_histories handle_history (cost=0.43..57.94 rows=18 width=402) (actual time=2.223..2.223 rows=1 loops=1)

  • Index Cond: (handle_id = handle.id)
Planning time : 3.713 ms
Execution time : 37,659.424 ms