explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ItwI

Settings
# exclusive inclusive rows x rows loops node
1. 234,359.884 247,930.601 ↑ 1.0 1 1

Aggregate (cost=1,895,295.90..1,895,295.91 rows=1 width=8) (actual time=247,930.601..247,930.601 rows=1 loops=1)

2. 13,570.717 13,570.717 ↓ 1.0 36,336,392 1

Index Only Scan using api_report_a_c_r_s_index on api_report (cost=0.70..1,807,175.98 rows=35,247,968 width=20) (actual time=0.055..13,570.717 rows=36,336,392 loops=1)

  • Index Cond: ((account = '729650'::text) AND (checked_on >= '2019-01-01 00:00:00+00'::timestamp with time zone) AND (checked_on <= '2019-08-01 23:59:59+00'::timestamp with time zone))
  • Heap Fetches: 0
Planning time : 0.151 ms
Execution time : 247,930.634 ms