explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sdAp

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 1.086 ↓ 0.0 0 1

Nested Loop (cost=3.10..8.67 rows=1 width=15) (actual time=1.086..1.086 rows=0 loops=1)

2. 0.025 1.053 ↓ 7.0 7 1

Hash Join (cost=2.95..7.69 rows=1 width=8) (actual time=1.007..1.053 rows=7 loops=1)

  • Hash Cond: (virtualpro1_.id = virtualpro0_.fk_product)
3. 0.034 0.034 ↑ 1.4 52 1

Seq Scan on product virtualpro1_ (cost=0.00..4.35 rows=75 width=16) (actual time=0.003..0.034 rows=52 loops=1)

  • Filter: (NOT archived)
  • Rows Removed by Filter: 56
4. 0.006 0.994 ↓ 3.5 7 1

Hash (cost=2.93..2.93 rows=2 width=8) (actual time=0.994..0.994 rows=7 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
5. 0.988 0.988 ↓ 3.5 7 1

Seq Scan on product_variant virtualpro0_ (cost=0.00..2.93 rows=2 width=8) (actual time=0.893..0.988 rows=7 loops=1)

  • Filter: ((NOT archived) AND (NOT archived) AND (type = 'VIRTUAL'::text) AND (virtual_product_variant_type = 'NOX'::text))
  • Rows Removed by Filter: 73
6. 0.028 0.028 ↓ 0.0 0 7

Index Scan using benefit_pkey on benefit benefit2_ (cost=0.14..0.64 rows=1 width=23) (actual time=0.004..0.004 rows=0 loops=7)

  • Index Cond: (id = virtualpro1_.fk_benefit)
  • Filter: ((NOT archived) AND visible_in_public_api AND ((type)::text = 'CHECK_IN_BASED'::text))
  • Rows Removed by Filter: 1
Planning time : 10.736 ms
Execution time : 1.129 ms