explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2XAK

Settings
# exclusive inclusive rows x rows loops node
1. 1.534 2,373.275 ↑ 1.0 1 1

Aggregate (cost=272,477.52..272,477.53 rows=1 width=8) (actual time=2,373.275..2,373.275 rows=1 loops=1)

2. 10.032 2,371.741 ↓ 3.1 17,962 1

Sort (cost=272,390.01..272,404.59 rows=5,834 width=16) (actual time=2,369.497..2,371.741 rows=17,962 loops=1)

  • Sort Key: api_upload.system_uuid
  • Sort Method: quicksort Memory: 1610kB
3. 2.772 2,361.709 ↓ 3.1 17,962 1

Nested Loop (cost=11,181.56..272,025.08 rows=5,834 width=16) (actual time=89.731..2,361.709 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. 5.334 2,358.930 ↓ 3.1 17,962 1

Gather (cost=11,181.28..271,958.45 rows=5,834 width=20) (actual time=89.724..2,358.930 rows=17,962 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
6. 417.839 2,353.596 ↓ 2.5 5,987 3

Merge Join (cost=10,181.28..270,375.05 rows=2,431 width=20) (actual time=62.170..2,353.596 rows=5,987 loops=3)

  • Merge Cond: (api_report.upload_id = api_upload.id)
7. 1,896.143 1,896.314 ↓ 1.7 2,810,111 3

Parallel Index Only Scan using api_report_rule_id_1892e1_idx on api_report (cost=22.00..255,605.22 rows=1,693,065 width=8) (actual time=0.286..1,896.314 rows=2,810,111 loops=3)

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

SubPlan (for Parallel Index Only Scan)

9. 0.171 0.171 ↑ 1.0 351 3

Seq Scan on api_ack u2 (cost=0.00..20.55 rows=351 width=4) (actual time=0.008..0.171 rows=351 loops=3)

  • Filter: ((account)::text = '729650'::text)
  • Rows Removed by Filter: 573
10. 23.113 39.443 ↑ 3.3 22,994 3

Sort (cost=10,159.27..10,346.80 rows=75,013 width=20) (actual time=34.139..39.443 rows=22,994 loops=3)

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

Index Only Scan using api_upload_account_system_uuid_source_id_id_index on api_upload (cost=0.42..4,085.15 rows=75,013 width=20) (actual time=0.026..16.330 rows=23,119 loops=3)

  • Index Cond: (account = '729650'::text)
  • Heap Fetches: 1434
Planning time : 0.504 ms
Execution time : 2,373.729 ms