explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Lre5

Settings
# exclusive inclusive rows x rows loops node
1. 0.044 1.609 ↑ 1.0 1 1

Aggregate (cost=1,079.28..1,079.29 rows=1 width=16) (actual time=1.609..1.609 rows=1 loops=1)

2. 0.058 1.565 ↓ 2.7 335 1

Unique (cost=1,074.59..1,076.46 rows=125 width=92) (actual time=1.490..1.565 rows=335 loops=1)

3. 0.168 1.507 ↓ 3.1 392 1

Sort (cost=1,074.59..1,074.90 rows=125 width=92) (actual time=1.490..1.507 rows=392 loops=1)

  • Sort Key: api_host.system_uuid, api_host.display_name, api_host.rhel_version, api_host.stale_at, api_host.stale_warn_at
  • Sort Method: quicksort Memory: 80kB
4. 0.000 1.339 ↓ 3.1 392 1

Nested Loop (cost=0.85..1,070.24 rows=125 width=92) (actual time=0.018..1.339 rows=392 loops=1)

5. 0.164 0.164 ↓ 3.1 392 1

Index Only Scan using api_upload_account_host_id on api_upload (cost=0.42..14.61 rows=125 width=16) (actual time=0.012..0.164 rows=392 loops=1)

  • Index Cond: (account = '540155'::text)
  • Heap Fetches: 17
6. 1.176 1.176 ↑ 1.0 1 392

Index Scan using api_host_pkey on api_host (cost=0.43..8.45 rows=1 width=60) (actual time=0.003..0.003 rows=1 loops=392)

  • Index Cond: (system_uuid = api_upload.host_id)
Planning time : 0.377 ms
Execution time : 1.647 ms