explain.depesz.com

PostgreSQL's explain analyze made readable

Result: flh7

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 3.715 ↑ 1.0 1 1

HashAggregate (cost=623.09..623.10 rows=1 width=8) (actual time=3.715..3.715 rows=1 loops=1)

  • Group Key: count(DISTINCT product0_.id)
2. 0.334 3.711 ↑ 1.0 1 1

Aggregate (cost=623.08..623.09 rows=1 width=8) (actual time=3.711..3.711 rows=1 loops=1)

3. 0.409 3.377 ↓ 11.7 1,148 1

Nested Loop (cost=39.54..622.83 rows=98 width=8) (actual time=0.211..3.377 rows=1,148 loops=1)

4. 0.490 1.246 ↓ 6.2 574 1

Hash Join (cost=39.25..375.92 rows=92 width=8) (actual time=0.204..1.246 rows=574 loops=1)

  • Hash Cond: (product0_.manufacturer_id = manufactur2_.id)
5. 0.580 0.734 ↓ 1.6 1,312 1

Bitmap Heap Scan on product product0_ (cost=37.54..370.30 rows=796 width=16) (actual time=0.176..0.734 rows=1,312 loops=1)

  • Recheck Cond: (distributor_id = 1)
  • Filter: (enabled AND (NOT is_deleted))
  • Rows Removed by Filter: 429
  • Heap Blocks: exact=153
6. 0.154 0.154 ↑ 1.0 1,741 1

Bitmap Index Scan on product_distributor_idx (cost=0.00..37.34 rows=1,741 width=0) (actual time=0.154..0.154 rows=1,741 loops=1)

  • Index Cond: (distributor_id = 1)
7. 0.004 0.022 ↑ 1.0 6 1

Hash (cost=1.64..1.64 rows=6 width=8) (actual time=0.022..0.022 rows=6 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
8. 0.018 0.018 ↑ 1.0 6 1

Seq Scan on manufacturer manufactur2_ (cost=0.00..1.64 rows=6 width=8) (actual time=0.008..0.018 rows=6 loops=1)

  • Filter: ((code)::text = 'PG'::text)
  • Rows Removed by Filter: 45
9. 1.722 1.722 ↓ 2.0 2 574

Index Scan using product_details_product_idx on product_detail productdet1_ (cost=0.29..2.67 rows=1 width=8) (actual time=0.002..0.003 rows=2 loops=574)

  • Index Cond: (product_id = product0_.id)
  • Filter: (enabled AND (NOT is_deleted))
Planning time : 0.623 ms
Execution time : 3.792 ms