explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 2raX

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 1.471 ↑ 1.0 1 1

Nested Loop (cost=0.12..826.54 rows=1 width=762) (actual time=0.192..1.471 rows=1 loops=1)

2. 0.584 0.584 ↑ 1.0 1 1

Index Scan using digital_asset_storage_index_unique_resource_revision on digital_asset_storage das (cost=0.06..448.43 rows=1 width=762) (actual time=0.016..0.584 rows=1 loops=1)

  • Index Cond: (resource_id = '1WraBBCYjwUJXeJAGUqsDZ3qLyHIAAV5EJcKZTvNw5Eg'::text)
  • Filter: (calendar_id = 16)
3. 0.885 0.885 ↑ 1.0 1 1

Index Only Scan using digital_assets_index_calendar_id_digital_asset_storage_id on digital_assets da (cost=0.06..378.11 rows=1 width=4) (actual time=0.174..0.885 rows=1 loops=1)

  • Index Cond: (digital_asset_storage_id = das.id)
  • Heap Fetches: 1
Planning time : 0.279 ms
Execution time : 1.511 ms