explain.depesz.com

PostgreSQL's explain analyze made readable

Result: dRpY

Settings
# exclusive inclusive rows x rows loops node
1. 0.018 12.030 ↑ 76.9 13 1

Nested Loop (cost=181.84..181,910.00 rows=1,000 width=40) (actual time=3.155..12.030 rows=13 loops=1)

2. 0.022 4.472 ↑ 76.9 13 1

Nested Loop (cost=78.26..78,300.00 rows=1,000 width=24) (actual time=1.093..4.472 rows=13 loops=1)

3. 0.017 0.017 ↑ 76.9 13 1

Function Scan on generate_series dt (cost=0.00..10.00 rows=1,000 width=8) (actual time=0.016..0.017 rows=13 loops=1)

4. 3.263 4.433 ↑ 1.0 1 13

Aggregate (cost=78.26..78.27 rows=1 width=16) (actual time=0.341..0.341 rows=1 loops=13)

5. 1.170 1.170 ↑ 1.0 636 13

Seq Scan on booked_room br (cost=0.00..62.36 rows=636 width=28) (actual time=0.002..0.090 rows=636 loops=13)

6. 5.564 7.540 ↑ 1.0 1 13

Aggregate (cost=103.58..103.59 rows=1 width=16) (actual time=0.580..0.580 rows=1 loops=13)

7. 1.976 1.976 ↑ 1.0 1,788 13

Seq Scan on booked_room_guest brg (cost=0.00..58.88 rows=1,788 width=28) (actual time=0.002..0.152 rows=1,788 loops=13)

Planning time : 0.546 ms
Execution time : 12.143 ms