explain.depesz.com

PostgreSQL's explain analyze made readable

Result: QpR7

Settings
# exclusive inclusive rows x rows loops node
1. 0.078 1.522 ↑ 1.4 232 1

Hash Join (cost=3.66..1,630.08 rows=333 width=59) (actual time=0.125..1.522 rows=232 loops=1)

  • Hash Cond: (productatt1_.attribute_id = attribute3_.id)
2. 0.000 1.413 ↑ 1.4 232 1

Nested Loop (cost=1.40..1,623.24 rows=333 width=52) (actual time=0.086..1.413 rows=232 loops=1)

3. 0.044 0.719 ↑ 1.4 232 1

Nested Loop (cost=1.12..1,520.84 rows=333 width=32) (actual time=0.080..0.719 rows=232 loops=1)

4. 0.066 0.066 ↑ 1.4 29 1

Index Scan using batch_id_product_id_index on batch_product batchprodu8_ (cost=0.56..87.29 rows=42 width=16) (actual time=0.035..0.066 rows=29 loops=1)

  • Index Cond: (batch_id = 'a56eae35-da3a-4052-9770-eaa47346de8f'::uuid)
5. 0.609 0.609 ↑ 16.0 8 29

Index Only Scan using batch_product_id_product_attribute_id_index on batch_product_attribute batchprodu0_ (cost=0.56..32.85 rows=128 width=32) (actual time=0.019..0.021 rows=8 loops=29)

  • Index Cond: (batch_product_id = batchprodu8_.id)
  • Heap Fetches: 232
6. 0.696 0.696 ↑ 1.0 1 232

Index Scan using product_attribute_pkey on product_attribute productatt1_ (cost=0.28..0.30 rows=1 width=36) (actual time=0.002..0.003 rows=1 loops=232)

  • Index Cond: (id = batchprodu0_.product_attribute_id)
7. 0.011 0.031 ↑ 1.0 56 1

Hash (cost=1.56..1.56 rows=56 width=23) (actual time=0.031..0.031 rows=56 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 12kB
8. 0.020 0.020 ↑ 1.0 56 1

Seq Scan on attribute attribute3_ (cost=0.00..1.56 rows=56 width=23) (actual time=0.005..0.020 rows=56 loops=1)

Planning time : 0.651 ms
Execution time : 1.581 ms