explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 3OIX

Settings
# exclusive inclusive rows x rows loops node
1. 0.014 0.065 ↓ 0.0 0 1

Nested Loop Semi Join (cost=9.57..26.88 rows=1 width=8) (actual time=0.058..0.065 rows=0 loops=1)

  • Join Filter: (node.id = prop_1.node_id)
  • Buffers: shared hit=4
2. 0.014 0.051 ↓ 0.0 0 1

Nested Loop (cost=9.01..18.28 rows=1 width=16) (actual time=0.044..0.051 rows=0 loops=1)

  • Buffers: shared hit=4
3. 0.000 0.037 ↓ 0.0 0 1

HashAggregate (cost=8.58..8.59 rows=1 width=8) (actual time=0.030..0.037 rows=0 loops=1)

  • Group Key: prop.node_id
  • Buffers: shared hit=4
4. 0.098 0.098 ↓ 0.0 0 1

Index Only Scan using idx_alf_nprop_s on alf_node_properties prop (cost=0.56..8.58 rows=1 width=8) (actual time=0.016..0.098 rows=0 loops=1)

  • Index Cond: ((qname_id = 287) AND (string_value = 'Hachette Livre'::text))
  • Heap Fetches: 0
  • Buffers: shared hit=4
5. 0.000 0.000 ↓ 0.0 0

Index Scan using alf_node_pkey on alf_node node (cost=0.42..8.46 rows=1 width=8) (never executed)

  • Index Cond: (id = prop.node_id)
  • Filter: ((type_qname_id <> 148) AND (store_id = 12) AND (type_qname_id = ANY ('{51,103,198,199,205,212}'::bigint[])))
6. 0.000 0.000 ↓ 0.0 0

Index Only Scan using idx_alf_nprop_s on alf_node_properties prop_1 (cost=0.56..8.58 rows=1 width=8) (never executed)

  • Index Cond: ((qname_id = 286) AND (string_value = 'Action and Adventure'::text))
  • Heap Fetches: 0
Planning time : 1.092 ms
Execution time : 0.269 ms