explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RSx6

Settings
# exclusive inclusive rows x rows loops node
1. 0.024 11.550 ↑ 76.9 13 1

Nested Loop (cost=175.18..175,250.00 rows=1,000 width=40) (actual time=3.071..11.550 rows=13 loops=1)

2. 0.030 4.259 ↑ 76.9 13 1

Nested Loop (cost=76.11..76,150.00 rows=1,000 width=24) (actual time=1.072..4.259 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.015..0.017 rows=13 loops=1)

4. 1.352 4.212 ↑ 1.0 1 13

Aggregate (cost=76.11..76.12 rows=1 width=16) (actual time=0.324..0.324 rows=1 loops=13)

5. 2.860 2.860 ↑ 1.0 608 13

Seq Scan on booked_room br (cost=0.00..63.95 rows=608 width=24) (actual time=0.003..0.220 rows=608 loops=13)

  • Filter: (state = 3)
  • Rows Removed by Filter: 28
6. 3.068 7.267 ↑ 1.0 1 13

Aggregate (cost=99.07..99.08 rows=1 width=16) (actual time=0.559..0.559 rows=1 loops=13)

7. 4.199 4.199 ↑ 1.0 1,786 13

Seq Scan on booked_room_guest brg (cost=0.00..63.35 rows=1,786 width=24) (actual time=0.002..0.323 rows=1,786 loops=13)

  • Filter: (state = 1)
  • Rows Removed by Filter: 2
Planning time : 0.644 ms
Execution time : 11.661 ms