explain.depesz.com

PostgreSQL's explain analyze made readable

Result: OLpw

Settings
# exclusive inclusive rows x rows loops node
1. 1.304 324.382 ↑ 1.0 1 1

Aggregate (cost=72,571.59..72,571.60 rows=1 width=8) (actual time=324.382..324.382 rows=1 loops=1)

2. 9.242 323.078 ↓ 7.3 19,762 1

Sort (cost=72,530.83..72,537.63 rows=2,717 width=16) (actual time=321.237..323.078 rows=19,762 loops=1)

  • Sort Key: api_upload.system_uuid
  • Sort Method: quicksort Memory: 1695kB
3. 2.061 313.836 ↓ 7.3 19,762 1

Nested Loop (cost=5,169.57..72,375.86 rows=2,717 width=16) (actual time=17.135..313.836 rows=19,762 loops=1)

4. 0.010 0.010 ↑ 1.0 1 1

Index Scan using api_rule_pkey on api_rule (cost=0.28..8.29 rows=1 width=4) (actual time=0.007..0.010 rows=1 loops=1)

  • Index Cond: (id = 1101)
  • Filter: active
5. 2.727 311.765 ↓ 7.3 19,762 1

Gather (cost=5,169.29..72,340.39 rows=2,717 width=20) (actual time=17.126..311.765 rows=19,762 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 113.953 309.038 ↓ 5.8 6,587 3

Parallel Hash Join (cost=4,169.29..71,068.69 rows=1,132 width=20) (actual time=19.715..309.038 rows=6,587 loops=3)

  • Hash Cond: (api_report.upload_id = api_upload.id)
7. 181.798 181.993 ↓ 1.5 759,509 3

Parallel Index Only Scan using api_report_rule_id_1892e1_idx on api_report (cost=20.51..65,623.13 rows=494,010 width=8) (actual time=0.382..181.993 rows=759,509 loops=3)

  • Index Cond: (rule_id = 1101)
  • Filter: (NOT (hashed SubPlan 1))
  • Heap Fetches: 9
8.          

SubPlan (for Parallel Index Only Scan)

9. 0.195 0.195 ↑ 1.0 355 3

Seq Scan on api_ack u2 (cost=0.00..19.05 rows=355 width=4) (actual time=0.015..0.195 rows=355 loops=3)

  • Filter: ((account)::text = '729650'::text)
  • Rows Removed by Filter: 529
10. 5.344 13.092 ↑ 2.7 15,663 3

Parallel Hash (cost=3,623.98..3,623.98 rows=41,984 width=20) (actual time=13.092..13.092 rows=15,663 loops=3)

  • Buckets: 131072 Batches: 1 Memory Usage: 3616kB
11. 7.748 7.748 ↑ 2.7 15,663 3

Parallel Index Only Scan using api_upload_account_system_uuid_source_id_id_index on api_upload (cost=0.43..3,623.98 rows=41,984 width=20) (actual time=0.033..7.748 rows=15,663 loops=3)

  • Index Cond: (account = '729650'::text)
  • Heap Fetches: 0
Planning time : 0.528 ms
Execution time : 325.380 ms