explain.depesz.com

PostgreSQL's explain analyze made readable

Result: v0Vy

Settings
# exclusive inclusive rows x rows loops node
1. 3.410 14,890.182 ↓ 150.0 150 1

Nested Loop (cost=178.85..603.60 rows=1 width=8) (actual time=10,460.928..14,890.182 rows=150 loops=1)

  • Buffers: shared hit=368,068 read=34,422 written=9,860
2. 3.237 14,867.272 ↓ 150.0 150 1

Nested Loop Semi Join (cost=178.42..599.29 rows=1 width=24) (actual time=10,458.310..14,867.272 rows=150 loops=1)

  • Buffers: shared hit=367,510 read=34,380 written=9,860
3. 1,094.738 14,808.685 ↓ 18.8 150 1

Nested Loop (cost=177.85..541.64 rows=8 width=16) (actual time=10,455.783..14,808.685 rows=150 loops=1)

  • Buffers: shared hit=366,867 read=34,272 written=9,860
4. 1,146.243 10,833.947 ↓ 1,860.5 80,000 1

HashAggregate (cost=177.43..177.86 rows=43 width=8) (actual time=10,283.674..10,833.947 rows=80,000 loops=1)

  • Group Key: prop_1.node_id
  • Buffers: shared hit=53,500 read=27,191 written=9,860
5. 9,687.704 9,687.704 ↓ 1,860.5 80,000 1

Index Only Scan using idx_alf_nprop_s on alf_node_properties prop_1 (cost=0.56..177.32 rows=43 width=8) (actual time=2.260..9,687.704 rows=80,000 loops=1)

  • Index Cond: ((qname_id = 238) AND (string_value = 'Type-80000-B'::text))
  • Heap Fetches: 80,000
  • Buffers: shared hit=53,500 read=27,191 written=9,860
6. 2,880.000 2,880.000 ↓ 0.0 0 80,000

Index Scan using alf_node_pkey on alf_node node (cost=0.43..8.46 rows=1 width=8) (actual time=0.036..0.036 rows=0 loops=80,000)

  • Index Cond: (id = prop_1.node_id)
  • Filter: ((type_qname_id <> 148) AND ((audit_created)::text >= '2020-08-01T08:22:14.000Z'::text) AND (store_id = 6) AND (type_qname_id = ANY ('{212,205,51,198,199,103}'::bigint[])))
  • Rows Removed by Filter: 1
  • Buffers: shared hit=313,367 read=7,081
7. 55.350 55.350 ↑ 1.0 1 150

Index Only Scan using idx_alf_nprop_s on alf_node_properties prop (cost=0.56..6.47 rows=1 width=8) (actual time=0.369..0.369 rows=1 loops=150)

  • Index Cond: ((qname_id = 239) AND (string_value = 'Publisher-80000-B'::text) AND (node_id = node.id))
  • Heap Fetches: 150
  • Buffers: shared hit=643 read=108
8. 19.500 19.500 ↑ 1.0 1 150

Index Only Scan using alf_node_aspects_pkey on alf_node_aspects aspect (cost=0.43..4.31 rows=1 width=8) (actual time=0.130..0.130 rows=1 loops=150)

  • Index Cond: ((node_id = node.id) AND (qname_id = 242))
  • Heap Fetches: 150
  • Buffers: shared hit=558 read=42
Planning time : 43.573 ms
Execution time : 14,891.384 ms