explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2Fdo

Settings
# exclusive inclusive rows x rows loops node
1. 2,354.841 2,354.841 ↑ 3.6 364 1

Index Scan using index_yt_video_view_counts_on_yt_video_id_and_created_at on yt_video_view_counts (cost=0.71..4,891.05 rows=1,310 width=24) (actual time=1.565..2,354.841 rows=364 loops=1)

  • Index Cond: ((yt_video_id = 8295) AND (created_at > '2018-07-09 16:15:20'::timestamp without time zone))
Planning time : 0.072 ms
Execution time : 2,355.086 ms