explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Ua3G

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

Nested Loop (cost=1.12..38.6 rows=1 width=58) (actual time=0.124..0.127 rows=1 loops=1)

  • Buffers: shared hit=11
2. 0.005 0.114 ↑ 1.0 1 1

Nested Loop (cost=0.99..38.42 rows=1 width=44) (actual time=0.112..0.114 rows=1 loops=1)

  • Buffers: shared hit=9
3. 0.066 0.066 ↑ 4.0 1 1

Index Only Scan using bcu_idx_alf_nprop_s on alf_node_properties node_props (cost=0.56..4.64 rows=4 width=8) (actual time=0.064..0.066 rows=1 loops=1)

  • Index Cond: ((node_props.qname_id = 22423237) AND (node_props.string_value = 'AJ-A-GH-97-69-00-ZZZ-066-Z-D'::text))
  • Buffers: shared hit=5
4. 0.043 0.043 ↑ 1.0 1 1

Index Scan using bcu_i_alf_node_tqn_id_id on alf_node node (cost=0.42..8.45 rows=1 width=52) (actual time=0.042..0.043 rows=1 loops=1)

  • Index Cond: ((node.id = node_props.node_id) AND (node.type_qname_id = 22423066))
  • Buffers: shared hit=4
5. 0.011 0.011 ↑ 1.0 1 1

Index Only Scan using bcu_i_alf_store_protocol_ident on alf_store store (cost=0.14..0.16 rows=1 width=30) (actual time=0.01..0.011 rows=1 loops=1)

  • Index Cond: ((store.id = node.store_id) AND (store.protocol = 'workspace'::text) AND (store.identifier = 'SpacesStore'::text))
  • Buffers: shared hit=2