explain.depesz.com

PostgreSQL's explain analyze made readable

Result: M8Od

Settings
# exclusive inclusive rows x rows loops node
1. 200,996.231 200,996.231 ↑ 1.1 1,645,517 1

Index Scan using metadata_prod_mr3_last_modified_idx on metadata_prod_mr3 (cost=0.58..892,757.65 rows=1,825,191 width=23) (actual time=8.249..200,996.231 rows=1,645,517 loops=1)

  • Index Cond: ((last_modified >= '2020-03-08 04:36:28.8+00'::timestamp with time zone) AND (last_modified < '2020-03-08 06:56:26.88+00'::timestamp with time zone))
  • Filter: (bucket IS NOT NULL)
  • Buffers: shared hit=750,566 read=346,432 written=3
Planning time : 14.646 ms
Execution time : 201,214.905 ms