explain.depesz.com

PostgreSQL's explain analyze made readable

Result: hHPV

Settings
# exclusive inclusive rows x rows loops node
1. 0.010 0.338 ↑ 1.0 1 1

Nested Loop Anti Join (cost=0.28..14.14 rows=1 width=236) (actual time=0.337..0.338 rows=1 loops=1)

2. 0.018 0.018 ↑ 1.0 31 1

Seq Scan on members m (cost=0.00..1.31 rows=31 width=240) (actual time=0.012..0.018 rows=31 loops=1)

3. 0.310 0.310 ↑ 135.0 1 31

Index Only Scan using "bookings.memid_facid" on bookings b (cost=0.28..8.20 rows=135 width=4) (actual time=0.010..0.010 rows=1 loops=31)