explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 7cnk

Settings
# exclusive inclusive rows x rows loops node
1. 37,591.795 39,767.027 ↑ 1.0 1 1

Aggregate (cost=460,074.12..460,074.13 rows=1 width=8) (actual time=39,767.026..39,767.027 rows=1 loops=1)

2. 2,175.232 2,175.232 ↑ 1.3 6,545,063 1

Index Only Scan using all_reports_acrs_index on all_reports (cost=0.70..438,708.38 rows=8,546,297 width=20) (actual time=0.048..2,175.232 rows=6,545,063 loops=1)

  • Index Cond: ((account = '729650'::text) AND (checked_on >= '2019-07-23 00:00:00+00'::timestamp with time zone) AND (checked_on <= '2019-08-26 23:59:59+00'::timestamp with time zone))
  • Heap Fetches: 0
Planning time : 0.476 ms
Execution time : 39,767.057 ms