explain.depesz.com

PostgreSQL's explain analyze made readable

Result: eCBZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 226.851 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.66..15,217.09 rows=152 width=4,970) (actual time=226.851..226.851 rows=0 loops=1)

  • Planning time: 0.541 ms
  • Execution time: 226.933 ms
2. 0.000 226.850 ↓ 0.0 0 1

Nested Loop Left Join (cost=1.24..15,206.75 rows=152 width=3,976) (actual time=226.850..226.850 rows=0 loops=1)

  • Join Filter: (events.id = (a.data ->> 'variantId'::text))
3. 0.001 226.850 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.83..13,192.83 rows=152 width=2,990) (actual time=226.850..226.850 rows=0 loops=1)

  • Join Filter: (events.id = (g.data ->> 'variantId'::text))
4. 0.001 226.849 ↓ 0.0 0 1

Nested Loop Left Join (cost=0.41..11,178.90 rows=152 width=1,996) (actual time=226.849..226.849 rows=0 loops=1)

  • Join Filter: (events.id = (p.data ->> 'variantId'::text))
5. 226.848 226.848 ↓ 0.0 0 1

Seq Scan on events (cost=0.00..9,164.98 rows=152 width=1,002) (actual time=226.848..226.848 rows=0 loops=1)

  • Filter: ((type = 'variant'::text) AND (tenant_id = 'FACL'::text) AND ((data ->> 'parentProductId'::text) = '123455'::text))
  • Rows Removed by Filter: 55247
6. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.41..2,008.61 rows=2 width=994) (never executed)

7. 0.000 0.000 ↓ 0.0 0

Index Scan using events_pkey on events p (cost=0.41..2,008.60 rows=2 width=994) (never executed)

  • Index Cond: ((tenant_id = 'FACL'::text) AND (type = 'price'::text))
8. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.41..2,008.61 rows=2 width=994) (never executed)

9. 0.000 0.000 ↓ 0.0 0

Index Scan using events_pkey on events g (cost=0.41..2,008.60 rows=2 width=994) (never executed)

  • Index Cond: ((tenant_id = 'FACL'::text) AND (type = 'generic'::text))
10. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.41..2,008.61 rows=2 width=994) (never executed)

11. 0.000 0.000 ↓ 0.0 0

Index Scan using events_pkey on events a (cost=0.41..2,008.60 rows=2 width=994) (never executed)

  • Index Cond: ((tenant_id = 'FACL'::text) AND (type = 'availability'::text))
12. 0.000 0.000 ↓ 0.0 0

Materialize (cost=0.41..8.44 rows=1 width=994) (never executed)

13. 0.000 0.000 ↓ 0.0 0

Index Scan using events_pkey on events pr (cost=0.41..8.44 rows=1 width=994) (never executed)

  • Index Cond: ((tenant_id = 'FACL'::text) AND (id = '123455'::text) AND (type = 'product'::text))