explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 4p1T

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=2.78..35.97 rows=1 width=3,631) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop (cost=2.36..19.86 rows=1 width=3,551) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.94..19.24 rows=1 width=3,306) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.52..18.63 rows=1 width=2,566) (actual rows= loops=)

5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.39..17.65 rows=1 width=2,273) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Nested Loop (cost=1.25..17.49 rows=1 width=1,321) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.83..16.87 rows=1 width=579) (actual rows= loops=)

8. 0.000 0.000 ↓ 0.0

Index Scan using unique_favorite on favorite (cost=0.42..8.44 rows=1 width=32) (actual rows= loops=)

  • Index Cond: ("userId" = 629)
9. 0.000 0.000 ↓ 0.0

Index Scan using offer_pkey on offer offer_1 (cost=0.42..8.44 rows=1 width=547) (actual rows= loops=)

  • Index Cond: (id = favorite."offerId")
10. 0.000 0.000 ↓ 0.0

Index Scan using product_pkey on product product_1 (cost=0.42..0.62 rows=1 width=742) (actual rows= loops=)

  • Index Cond: (id = offer_1."productId")
11. 0.000 0.000 ↓ 0.0

Index Scan using venue_pkey on venue venue_1 (cost=0.14..0.16 rows=1 width=952) (actual rows= loops=)

  • Index Cond: (id = offer_1."venueId")
12. 0.000 0.000 ↓ 0.0

Index Scan using offerer_pkey on offerer offerer_1 (cost=0.14..0.88 rows=1 width=293) (actual rows= loops=)

  • Index Cond: (id = venue_1."managingOffererId")
13. 0.000 0.000 ↓ 0.0

Index Scan using "ix_mediation_offerId" on mediation mediation_1 (cost=0.42..0.60 rows=1 width=740) (actual rows= loops=)

  • Index Cond: ("offerId" = offer_1.id)
14. 0.000 0.000 ↓ 0.0

Index Scan using "ix_stock_offerId" on stock stock_1 (cost=0.42..0.62 rows=1 width=245) (actual rows= loops=)

  • Index Cond: ("offerId" = offer_1.id)
15. 0.000 0.000 ↓ 0.0

Index Scan using "ix_booking_stockId" on booking booking_1 (cost=0.42..0.60 rows=1 width=72) (actual rows= loops=)

  • Index Cond: (stock_1.id = "stockId")
16.          

SubPlan (for Nested Loop Left Join)

17. 0.000 0.000 ↓ 0.0

Aggregate (cost=15.48..15.49 rows=1 width=8) (actual rows= loops=)

18. 0.000 0.000 ↓ 0.0

Hash Join (cost=5.28..15.46 rows=8 width=4) (actual rows= loops=)

  • Hash Cond: (offer_criterion."criterionId" = criterion.id)
19. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on offer_criterion (cost=4.21..14.37 rows=8 width=8) (actual rows= loops=)

  • Recheck Cond: ("offerId" = offer_1.id)
20. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on "idx_offer_criterion_offerId" (cost=0.00..4.21 rows=8 width=0) (actual rows= loops=)

  • Index Cond: ("offerId" = offer_1.id)
21. 0.000 0.000 ↓ 0.0

Hash (cost=1.03..1.03 rows=3 width=12) (actual rows= loops=)

22. 0.000 0.000 ↓ 0.0

Seq Scan on criterion (cost=0.00..1.03 rows=3 width=12) (actual rows= loops=)