explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RHm

Settings
# exclusive inclusive rows x rows loops node
1. 24.206 12,198.092 ↑ 1.0 1 1

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

2. 813.866 12,173.886 ↑ 28.3 268,177 1

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

3. 8,980.675 11,360.020 ↑ 1.3 6,545,063 1

Sort (cost=1,773,212.65..1,794,578.39 rows=8,546,297 width=20) (actual time=10,043.143..11,360.020 rows=6,545,063 loops=1)

  • Sort Key: all_reports.rule_id, all_reports.system_uuid
  • Sort Method: external merge Disk: 192168kB
4. 2,379.345 2,379.345 ↑ 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.085..2,379.345 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.179 ms
Execution time : 12,235.267 ms