explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XDAK

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Sort (cost=1,541.66..1,542.23 rows=226 width=65) (actual rows= loops=)

  • Output: it.item_id, m.text_value, h.handle_id
  • Sort Key: m.text_value
2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6.50..1,532.83 rows=226 width=65) (actual rows= loops=)

  • Output: it.item_id, m.text_value, h.handle_id
3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=6.07..1,261.90 rows=99 width=16) (actual rows= loops=)

  • Output: c2i.item_id, it.item_id, h.handle_id, h.resource_id
4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=5.64..1,209.81 rows=103 width=12) (actual rows= loops=)

  • Output: c2i.item_id, h.handle_id, h.resource_id
5. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on public.collection2item c2i (cost=5.22..359.21 rows=103 width=4) (actual rows= loops=)

  • Output: c2i.id, c2i.collection_id, c2i.item_id
  • Recheck Cond: (c2i.collection_id = 65)
6. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on collection2item_collection_idx (cost=0.00..5.20 rows=103 width=0) (actual rows= loops=)

  • Index Cond: (c2i.collection_id = 65)
7. 0.000 0.000 ↓ 0.0

Index Scan using handle_resource_id_and_type_idx on public.handle h (cost=0.42..8.25 rows=1 width=8) (actual rows= loops=)

  • Output: h.handle_id, h.handle, h.resource_type_id, h.resource_id
  • Index Cond: ((h.resource_id = c2i.item_id) AND (h.resource_type_id = 2))
8. 0.000 0.000 ↓ 0.0

Index Scan using item_pkey on public.item it (cost=0.42..0.50 rows=1 width=4) (actual rows= loops=)

  • Output: it.item_id, it.submitter_id, it.in_archive, it.withdrawn, it.last_modified, it.owning_collection, it.discoverable
  • Index Cond: (it.item_id = h.resource_id)
  • Filter: it.in_archive
9. 0.000 0.000 ↓ 0.0

Index Scan using metadatavalue_item_idx2 on public.metadatavalue m (cost=0.43..2.72 rows=2 width=61) (actual rows= loops=)

  • Output: m.metadata_value_id, m.resource_id, m.metadata_field_id, m.text_value, m.text_lang, m.place, m.authority, m.confidence, m.resource_type_id
  • Index Cond: ((m.resource_id = it.item_id) AND (m.metadata_field_id = 64))
  • Filter: ((m.resource_type_id = 2) AND (m.place = 1))