explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VrvH

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

Aggregate (cost=47.34..47.35 rows=1 width=32) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Nested Loop Left Join (cost=24.22..46.96 rows=75 width=8) (actual rows= loops=)

3. 0.000 0.000 ↓ 0.0

Nested Loop (cost=19.98..31.93 rows=1 width=8) (actual rows= loops=)

  • Join Filter: (g.""idHolding"" = h.id)
4. 0.000 0.000 ↓ 0.0

Hash Join (cost=19.84..31.36 rows=1 width=16) (actual rows= loops=)

  • Hash Cond: (p.""idZone"" = z.id)
5. 0.000 0.000 ↓ 0.0

Seq Scan on ""Pos"" p (cost=0.00..11.10 rows=110 width=8) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Hash (cost=19.83..19.83 rows=1 width=16) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

Hash Join (cost=8.17..19.83 rows=1 width=16) (actual rows= loops=)

  • Hash Cond: (z.""idHolding"" = g.""idHolding"")
8. 0.000 0.000 ↓ 0.0

Seq Scan on ""Zone"" z (cost=0.00..11.20 rows=120 width=8) (actual rows= loops=)

9. 0.000 0.000 ↓ 0.0

Hash (cost=8.15..8.15 rows=1 width=8) (actual rows= loops=)

10. 0.000 0.000 ↓ 0.0

Index Scan using ""IDX_822bd33f51db5e817489f38d76"" on ""Guest"" g (cost=0.14..8.15 rows=1 width=8) (actual rows= loops=)

  • Index Cond: (""idUser"" = 351)
11. 0.000 0.000 ↓ 0.0

Index Only Scan using ""PK_bd2ba41adebd2fcb6ea7ede8857"" on ""Holding"" h (cost=0.14..0.56 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = z.""idHolding"")
12. 0.000 0.000 ↓ 0.0

Bitmap Heap Scan on ""GuestPosEnabled"" gpe (cost=4.24..14.91 rows=11 width=8) (actual rows= loops=)

  • Recheck Cond: (""idGuest"" = g.id)
13. 0.000 0.000 ↓ 0.0

Bitmap Index Scan on ""IDX_d7ea1056353988d64def93865e"" (cost=0.00..4.24 rows=11 width=0) (actual rows= loops=)

  • Index Cond: (""idGuest"" = g.id)