explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eIni

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.097 ↓ 0.0 0 1

Delete on api_currentreport (cost=5.51..832.97 rows=1 width=12) (actual time=0.097..0.097 rows=0 loops=1)

2. 0.009 0.082 ↓ 10.0 10 1

Nested Loop (cost=5.51..832.97 rows=1 width=12) (actual time=0.031..0.082 rows=10 loops=1)

3. 0.014 0.023 ↑ 6.6 10 1

Bitmap Heap Scan on api_currentreport (cost=4.94..266.19 rows=66 width=17) (actual time=0.017..0.023 rows=10 loops=1)

  • Recheck Cond: (system_uuid = 'c6251d4b-2fcd-4537-8b1e-4bef70908cf0'::uuid)
  • Heap Blocks: exact=5
4. 0.009 0.009 ↑ 2.2 30 1

Bitmap Index Scan on api_currentreport_system_uuid_index (cost=0.00..4.92 rows=66 width=0) (actual time=0.009..0.009 rows=30 loops=1)

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

Index Scan using api_upload_account_id_checked_on_index on api_upload (cost=0.56..8.59 rows=1 width=17) (actual time=0.005..0.005 rows=1 loops=10)

  • Index Cond: (((account)::text = (api_currentreport.account)::text) AND (id = api_currentreport.upload_id))
  • Filter: (source_id = 1)
Planning time : 0.580 ms
Execution time : 0.126 ms