explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fhL5

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 24,738.030 ↑ 20.0 1 1

Limit (cost=1.29..14,708.41 rows=20 width=1,367) (actual time=15,562.597..24,738.030 rows=1 loops=1)

2. 0.005 24,738.028 ↑ 811.0 1 1

Nested Loop (cost=1.29..596,374.91 rows=811 width=1,367) (actual time=15,562.596..24,738.028 rows=1 loops=1)

3. 0.005 24,738.000 ↑ 789.0 1 1

Nested Loop (cost=0.86..551,209.01 rows=789 width=965) (actual time=15,562.570..24,738.000 rows=1 loops=1)

4. 24,737.968 24,737.968 ↑ 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=15,562.538..24,737.968 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.027 0.027 ↑ 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.027..0.027 rows=1 loops=1)

  • Index Cond: (id = posts.handle_id)
  • Filter: (platform_id = ANY ('{1,3,4}'::integer[]))
6. 0.023 0.023 ↑ 18.0 1 1

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

  • Index Cond: (handle_id = handle.id)