explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Mlz

Settings
# exclusive inclusive rows x rows loops node
1. 0.917 10,583.189 ↑ 5.7 136 1

Nested Loop (cost=1,423,278.48..1,423,286.51 rows=775 width=8) (actual time=10,582.263..10,583.189 rows=136 loops=1)

  • -> Index Scan using alf_node_pkey on alf_node node (cost=0.56..8.57 rows=1 width=8) (actual time=0.006..0.006 rows=1 loo
  • Planning time: 0.573 ms
  • Execution time: 10583.232 ms
2. 10,582.272 10,582.272 ↓ 136.0 136 1

HashAggregate (cost=1,423,277.92..1,423,277.93 rows=1 width=8) (actual time=10,582.237..10,582.272 rows=136 loops=1)

  • Group Key: prop.node_id
  • -> Index Only Scan using idx_alf_nprop_s on alf_node_properties prop (cost=0.70..1423275.92 rows=799 width=8) (act
  • Index Cond: (qname_id = 381)
  • Filter: ((string_value)::text ~~ '128289%'::text)
  • Rows Removed by Filter: 31825972
  • Heap Fetches: 476436
  • Index Cond: (id = prop.node_id)
  • Filter: ((type_qname_id <> 150) AND (store_id = 6))