explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BgPa

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 180.537 ↑ 6.5 10 1

Nested Loop (cost=1.12..162,785.45 rows=65 width=27) (actual time=73.396..180.537 rows=10 loops=1)

2. 180.503 180.503 ↑ 6.5 10 1

Index Scan using api_currentreport_account_rule_id_system_uuid_f48d4524_uniq on api_currentreport (cost=0.56..162,227.42 rows=65 width=23) (actual time=73.377..180.503 rows=10 loops=1)

  • Index Cond: (system_uuid = 'c6251d4b-2fcd-4537-8b1e-4bef70908cf0'::uuid)
3. 0.030 0.030 ↑ 1.0 1 10

Index Scan using api_upload_pkey on api_upload (cost=0.56..8.58 rows=1 width=8) (actual time=0.003..0.003 rows=1 loops=10)

  • Index Cond: (id = api_currentreport.upload_id)
  • Filter: (source_id = 1)
Planning time : 0.240 ms
Execution time : 180.562 ms