explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Loms

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 30,147.590 ↑ 20.0 1 1

Limit (cost=1.29..19,643.54 rows=20 width=1,367) (actual time=22,013.197..30,147.590 rows=1 loops=1)

2. 0.001 30,147.586 ↑ 595.0 1 1

Nested Loop (cost=1.29..584,358.28 rows=595 width=1,367) (actual time=22,013.195..30,147.586 rows=1 loops=1)

3. 0.007 30,147.559 ↑ 579.0 1 1

Nested Loop (cost=0.86..551,208.03 rows=579 width=965) (actual time=22,013.168..30,147.559 rows=1 loops=1)

4. 30,147.528 30,147.528 ↑ 789.0 1 1

Index Scan Backward using posts_date_index on posts (cost=0.43..544,871.06 rows=789 width=928) (actual time=22,013.139..30,147.528 rows=1 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 @@ '''microsoftineduc'' | ''microsofteduc'''::tsquery) OR (mentioned_uids && '{2087947767926096,401328537106759,441940055873460,132560043518789,11964634205
  • Rows Removed by Filter: 292085
5. 0.024 0.024 ↑ 1.0 1 1

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

  • Index Cond: ((id = posts.handle_id) AND (platform_id = 3))
6. 0.026 0.026 ↑ 18.0 1 1

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

  • Index Cond: (handle_id = handle.id)