explain.depesz.com

PostgreSQL's explain analyze made readable

Result: IyuP

Settings
# exclusive inclusive rows x rows loops node
1. 36.902 7,824.950 ↑ 1.0 1 1

Aggregate (cost=1,953,634.48..1,953,634.49 rows=1 width=8) (actual time=7,824.950..7,824.950 rows=1 loops=1)

2. 908.093 7,788.048 ↑ 30.1 272,345 1

Unique (cost=0.70..1,851,152.55 rows=8,198,555 width=20) (actual time=0.246..7,788.048 rows=272,345 loops=1)

3. 6,879.955 6,879.955 ↑ 1.4 6,833,502 1

Index Only Scan using all_reports_asrc_index on all_reports (cost=0.70..1,804,700.17 rows=9,290,476 width=20) (actual time=0.244..6,879.955 rows=6,833,502 loops=1)

  • Index Cond: ((account = '729650'::text) AND (checked_on > '2019-08-06 00:00:00+00'::timestamp with time zone))
  • Heap Fetches: 0
Planning time : 0.124 ms
Execution time : 7,824.976 ms