explain.depesz.com

PostgreSQL's explain analyze made readable

Result: GseZ

Settings
# exclusive inclusive rows x rows loops node
1. 49.722 87,621.474 ↑ 1.0 1 1

Aggregate (cost=10,254,984.83..10,254,984.84 rows=1 width=8) (actual time=87,621.474..87,621.474 rows=1 loops=1)

2. 3,991.876 87,571.752 ↑ 72.9 358,421 1

Unique (cost=9,622,941.78..9,928,168.23 rows=26,145,328 width=24) (actual time=79,740.149..87,571.752 rows=358,421 loops=1)

3. 54,945.729 83,579.876 ↑ 1.3 30,316,270 1

Sort (cost=9,622,941.78..9,724,683.93 rows=40,696,860 width=24) (actual time=79,740.148..83,579.876 rows=30,316,270 loops=1)

  • Sort Key: all_reports.system_uuid, all_reports.rule_id
  • Sort Method: external sort Disk: 889,912kB
4. 11,404.711 28,634.147 ↑ 1.3 30,316,270 1

Hash Join (cost=192.89..1,975,361.87 rows=40,696,860 width=24) (actual time=1.563..28,634.147 rows=30,316,270 loops=1)

  • Hash Cond: (all_reports.rule_id = api_rule.id)
5. 17,227.951 17,227.951 ↑ 1.0 43,812,342 1

Index Only Scan using all_reports_asr_index on all_reports (cost=0.70..1,857,955.52 rows=44,478,790 width=20) (actual time=0.070..17,227.951 rows=43,812,342 loops=1)

  • Index Cond: (account = '729650'::text)
  • Heap Fetches: 0
6. 0.306 1.485 ↑ 1.0 985 1

Hash (cost=179.82..179.82 rows=990 width=4) (actual time=1.485..1.485 rows=985 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 43kB
7. 1.179 1.179 ↑ 1.0 985 1

Seq Scan on api_rule (cost=0.00..179.82 rows=990 width=4) (actual time=0.013..1.179 rows=985 loops=1)

  • Filter: active
  • Rows Removed by Filter: 91
Planning time : 0.605 ms
Execution time : 87,760.297 ms