explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vBhw

Settings
# exclusive inclusive rows x rows loops node
1. 33.359 53,240.610 ↑ 1.0 1 1

Aggregate (cost=1,969,270.81..1,969,270.82 rows=1 width=8) (actual time=53,240.610..53,240.610 rows=1 loops=1)

2. 2,412.813 53,207.251 ↑ 28.3 268,177 1

Unique (cost=1,831,634.65..1,874,366.13 rows=7,592,374 width=32) (actual time=45,268.660..53,207.251 rows=268,177 loops=1)

3. 47,689.551 50,794.438 ↑ 1.3 6,545,063 1

Sort (cost=1,831,634.65..1,853,000.39 rows=8,546,297 width=32) (actual time=45,268.659..50,794.438 rows=6,545,063 loops=1)

  • Sort Key: (ROW(all_reports.system_uuid, all_reports.rule_id))
  • Sort Method: external merge Disk: 326688kB
4. 3,104.887 3,104.887 ↑ 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=32) (actual time=0.049..3,104.887 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.373 ms
Execution time : 53,284.727 ms