explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YJv3

Settings
# exclusive inclusive rows x rows loops node
1. 1.863 5,986.769 ↓ 1.4 3,382 1

Sort (cost=136,236.36..136,242.44 rows=2,431 width=16) (actual time=5,986.409..5,986.769 rows=3,382 loops=1)

  • Sort Key: api_upload.system_uuid
  • Sort Method: quicksort Memory: 255kB
2. 0.000 5,984.906 ↓ 1.4 3,382 1

Nested Loop (cost=10,351.78..136,099.65 rows=2,431 width=16) (actual time=210.114..5,984.906 rows=3,382 loops=1)

3. 0.014 0.014 ↑ 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.012..0.014 rows=1 loops=1)

  • Index Cond: (id = 219)
  • Filter: active
4. 5.021 5,985.329 ↓ 1.4 3,382 1

Gather (cost=10,351.50..136,067.05 rows=2,431 width=20) (actual time=210.100..5,985.329 rows=3,382 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 99.270 5,980.308 ↓ 1.1 1,127 3

Merge Join (cost=9,351.50..134,823.95 rows=1,013 width=20) (actual time=229.561..5,980.308 rows=1,127 loops=3)

  • Merge Cond: (api_report.upload_id = api_upload.id)
6. 5,846.995 5,847.170 ↓ 1.5 1,057,978 3

Parallel Index Only Scan using api_report_rule_id_1892e1_idx on api_report (cost=20.71..123,342.42 rows=706,682 width=8) (actual time=0.320..5,847.170 rows=1,057,978 loops=3)

  • Index Cond: (rule_id = 219)
  • Filter: (NOT (hashed SubPlan 1))
  • Heap Fetches: 167021
7.          

SubPlan (for Parallel Index Only Scan)

8. 0.175 0.175 ↓ 1.0 351 3

Seq Scan on api_ack u2 (cost=0.00..19.26 rows=350 width=4) (actual time=0.011..0.175 rows=351 loops=3)

  • Filter: ((account)::text = '729650'::text)
  • Rows Removed by Filter: 571
9. 18.402 33.868 ↑ 3.3 22,808 3

Sort (cost=9,330.77..9,517.91 rows=74,857 width=20) (actual time=29.036..33.868 rows=22,808 loops=3)

  • Sort Key: api_upload.id
  • Sort Method: quicksort Memory: 2572kB
10. 15.466 15.466 ↑ 3.2 23,088 3

Index Only Scan using api_upload_account_system_uuid_source_id_id_index on api_upload (cost=0.42..3,270.40 rows=74,857 width=20) (actual time=0.041..15.466 rows=23,088 loops=3)

  • Index Cond: (account = '729650'::text)
  • Heap Fetches: 3442
Planning time : 2.043 ms
Execution time : 5,988.064 ms