explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Gv0D

Settings
# exclusive inclusive rows x rows loops node
1. 0.021 1.887 ↓ 152.0 152 1

Subquery Scan on q (cost=319.46..322.13 rows=1 width=16) (actual time=1.796..1.887 rows=152 loops=1)

  • Filter: (q.ranker = 1)
2. 0.075 1.866 ↓ 2.0 164 1

WindowAgg (cost=319.46..321.10 rows=82 width=40) (actual time=1.791..1.866 rows=164 loops=1)

3. 0.068 1.791 ↓ 2.0 164 1

Sort (cost=319.46..319.67 rows=82 width=40) (actual time=1.785..1.791 rows=164 loops=1)

  • Sort Key: r.cluster_id, r.date
  • Sort Method: quicksort Memory: 37kB
4. 0.089 1.723 ↓ 2.0 164 1

Nested Loop (cost=0.00..316.86 rows=82 width=40) (actual time=0.021..1.723 rows=164 loops=1)

5. 0.015 0.814 ↓ 2.0 164 1

Append (cost=0.00..120.79 rows=84 width=40) (actual time=0.012..0.814 rows=164 loops=1)

6. 0.000 0.000 ↓ 0.0 0 1

Seq Scan on review r (cost=0.00..0.00 rows=1 width=40) (actual time=0.000..0.000 rows=0 loops=1)

  • Filter: ((deleted_on IS NULL) AND (date > '2020-05-19 00:00:00'::timestamp without time zone) AND (source_id = 5))
7. 0.799 0.799 ↓ 2.0 164 1

Index Scan Backward using idx_review_date_2020_2 on review_2020_2 r (cost=0.00..120.79 rows=83 width=40) (actual time=0.012..0.799 rows=164 loops=1)

  • Index Cond: (date > '2020-05-19 00:00:00'::timestamp without time zone)
  • Filter: ((deleted_on IS NULL) AND (source_id = 5))
8. 0.820 0.820 ↑ 1.0 1 164

Index Scan using pk_hotel_ on hotel h (cost=0.00..2.32 rows=1 width=16) (actual time=0.005..0.005 rows=1 loops=164)

  • Index Cond: (cluster_id = r.cluster_id)
  • Filter: (deleted_on IS NULL)"Total runtime: 1.951 ms