explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qghw

Settings
# exclusive inclusive rows x rows loops node
1. 1.986 265.218 ↓ 16.7 3,926 1

Sort (cost=18,858.56..18,859.15 rows=235 width=16) (actual time=264.903..265.218 rows=3,926 loops=1)

  • Sort Key: api_upload.system_uuid
  • Sort Method: quicksort Memory: 281kB
2. 0.466 263.232 ↓ 16.7 3,926 1

Nested Loop (cost=5,666.11..18,849.31 rows=235 width=16) (actual time=28.730..263.232 rows=3,926 loops=1)

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

  • Index Cond: (id = 1124)
  • Filter: active
4. 5.222 262.757 ↓ 16.7 3,926 1

Gather (cost=5,665.83..18,838.66 rows=235 width=20) (actual time=28.723..262.757 rows=3,926 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 73.654 257.535 ↓ 13.4 1,309 3

Hash Join (cost=4,665.83..17,815.16 rows=98 width=20) (actual time=65.366..257.535 rows=1,309 loops=3)

  • Hash Cond: (api_report.upload_id = api_upload.id)
6. 155.124 155.306 ↓ 2.3 156,037 3

Parallel Index Only Scan using api_report_rule_id_1892e1_idx on api_report (cost=20.71..12,015.53 rows=68,387 width=8) (actual time=0.296..155.306 rows=156,037 loops=3)

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

SubPlan (for Parallel Index Only Scan)

8. 0.182 0.182 ↓ 1.0 351 3

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

  • Filter: ((account)::text = '729650'::text)
  • Rows Removed by Filter: 571
9. 9.468 28.575 ↑ 3.2 23,081 3

Hash (cost=3,270.40..3,270.40 rows=74,857 width=20) (actual time=28.575..28.575 rows=23,081 loops=3)

  • Buckets: 65536 Batches: 2 Memory Usage: 1098kB
10. 19.107 19.107 ↑ 3.2 23,081 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=1.382..19.107 rows=23,081 loops=3)

  • Index Cond: (account = '729650'::text)
  • Heap Fetches: 1688
Planning time : 0.456 ms
Execution time : 265.469 ms