explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2SYK

Settings
# exclusive inclusive rows x rows loops node
1. 24.907 10,448.957 ↑ 1.0 1 1

Aggregate (cost=1,932,214.55..1,932,214.56 rows=1 width=8) (actual time=10,448.957..10,448.957 rows=1 loops=1)

2. 863.074 10,424.050 ↑ 28.3 268,177 1

Unique (cost=1,773,212.65..1,837,309.87 rows=7,592,374 width=20) (actual time=8,287.142..10,424.050 rows=268,177 loops=1)

3. 7,144.214 9,560.976 ↑ 1.3 6,545,063 1

Sort (cost=1,773,212.65..1,794,578.39 rows=8,546,297 width=20) (actual time=8,287.141..9,560.976 rows=6,545,063 loops=1)

  • Sort Key: all_reports.system_uuid, all_reports.rule_id
  • Sort Method: external merge Disk: 192168kB
4. 2,416.762 2,416.762 ↑ 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.141..2,416.762 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.254 ms
Execution time : 10,483.462 ms