explain.depesz.com

PostgreSQL's explain analyze made readable

Result: KmcV

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

Aggregate (cost=0..0 rows=0 width=0) (actual rows=901,654 loops=1)

2. 0.000 0.000 ↓ 0.0 1,860,455 1

Hash Join (cost=0..0 rows=0 width=0) (actual rows=1,860,455 loops=1)

3. 0.000 0.000 ↓ 0.0 1,860,455 1

Hash Join (cost=0..0 rows=0 width=0) (actual rows=1,860,455 loops=1)

4. 0.000 0.000 ↓ 0.0 1,860,455 1

Hash Join (cost=0..0 rows=0 width=0) (actual rows=1,860,455 loops=1)

5. 0.000 0.000 ↓ 0.0 1,860,455 1

Hash Join (cost=0..0 rows=0 width=0) (actual rows=1,860,455 loops=1)

6. 0.000 0.000 ↓ 0.0 1,860,455 1

Hash Join (cost=0..0 rows=0 width=0) (actual rows=1,860,455 loops=1)

7. 0.000 0.000 ↓ 0.0 2,292,797 1

Seq Scan on reservationscart rc (cost=0..0 rows=0 width=0) (actual rows=2,292,797 loops=1)

  • Filter: ((roomrate IS NOT NULL) AND (day IS NOT NULL))
8. 0.000 0.000 ↓ 0.0 503,729 1

Hash (cost=0..0 rows=0 width=0) (actual rows=503,729 loops=1)

9. 0.000 0.000 ↓ 0.0 503,729 1

Seq Scan on reservations r (cost=0..0 rows=0 width=0) (actual rows=503,729 loops=1)

  • Filter: (canceldate IS NULL)
10. 0.000 0.000 ↓ 0.0 1,963,942 1

Hash (cost=0..0 rows=0 width=0) (actual rows=1,963,942 loops=1)

11. 0.000 0.000 ↓ 0.0 1,963,942 1

Seq Scan on roomrates rr (cost=0..0 rows=0 width=0) (actual rows=1,963,942 loops=1)

12. 0.000 0.000 ↓ 0.0 15,629 1

Hash (cost=0..0 rows=0 width=0) (actual rows=15,629 loops=1)

13. 0.000 0.000 ↓ 0.0 15,629 1

Index Only Scan using rates_pkey on rates rt (cost=0..0 rows=0 width=0) (actual rows=15,629 loops=1)

  • Heap Fetches: 1,052
14. 0.000 0.000 ↓ 0.0 255,527 1

Hash (cost=0..0 rows=0 width=0) (actual rows=255,527 loops=1)

15. 0.000 0.000 ↓ 0.0 255,527 1

Seq Scan on roomguests rg (cost=0..0 rows=0 width=0) (actual rows=255,527 loops=1)

16. 0.000 0.000 ↓ 0.0 17,428 1

Hash (cost=0..0 rows=0 width=0) (actual rows=17,428 loops=1)

17. 0.000 0.000 ↓ 0.0 17,428 1

Seq Scan on rooms rm (cost=0..0 rows=0 width=0) (actual rows=17,428 loops=1)