explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Kaok

Settings
# exclusive inclusive rows x rows loops node
1. 1.002 3,169.458 ↑ 1.0 1 1

Aggregate (cost=423,493.56..423,493.57 rows=1 width=8) (actual time=3,169.458..3,169.458 rows=1 loops=1)

2. 17.712 3,168.456 ↓ 2.8 17,962 1

Sort (cost=423,398.25..423,414.14 rows=6,354 width=16) (actual time=3,166.381..3,168.456 rows=17,962 loops=1)

  • Sort Key: api_upload.system_uuid
  • Sort Method: quicksort Memory: 1610kB
3. 6.810 3,150.744 ↓ 2.8 17,962 1

Nested Loop (cost=10,991.63..422,996.89 rows=6,354 width=16) (actual time=77.223..3,150.744 rows=17,962 loops=1)

4. 0.007 0.007 ↑ 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.006..0.007 rows=1 loops=1)

  • Index Cond: (id = 1101)
  • Filter: active
5. 0.000 3,143.927 ↓ 2.8 17,962 1

Gather (cost=10,991.36..422,925.06 rows=6,354 width=20) (actual time=77.216..3,143.927 rows=17,962 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 366.312 3,144.611 ↓ 2.3 5,987 3

Merge Join (cost=9,991.36..421,289.66 rows=2,648 width=20) (actual time=49.033..3,144.611 rows=5,987 loops=3)

  • Merge Cond: (api_report.upload_id = api_upload.id)
7. 2,737.569 2,737.738 ↓ 1.4 2,809,025 3

Parallel Index Only Scan using api_report_rule_id_1892e1_idx on api_report (cost=23.23..406,427.37 rows=1,956,481 width=8) (actual time=0.297..2,737.738 rows=2,809,025 loops=3)

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

SubPlan (for Parallel Index Only Scan)

9. 0.169 0.169 ↑ 1.1 351 3

Seq Scan on api_ack u2 (cost=0.00..21.68 rows=394 width=4) (actual time=0.010..0.169 rows=351 loops=3)

  • Filter: ((account)::text = '729650'::text)
  • Rows Removed by Filter: 573
10. 14.549 40.561 ↑ 3.1 23,113 3

Sort (cost=9,968.04..10,144.68 rows=70,659 width=20) (actual time=35.987..40.561 rows=23,113 loops=3)

  • Sort Key: api_upload.id
  • Sort Method: quicksort Memory: 2575kB
11. 26.012 26.012 ↑ 3.1 23,119 3

Index Only Scan using api_upload_account_system_uuid_source_id_id_index on api_upload (cost=0.42..4,276.95 rows=70,659 width=20) (actual time=0.025..26.012 rows=23,119 loops=3)

  • Index Cond: (account = '729650'::text)
  • Heap Fetches: 10558
Planning time : 0.489 ms
Execution time : 3,169.798 ms