explain.depesz.com

PostgreSQL's explain analyze made readable

Result: vYXG

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

Limit (cost=319.46..322.13 rows=1 width=16) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

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

  • Filter: (q.ranker = 1)
3. 0.000 0.000 ↓ 0.0

WindowAgg (cost=319.46..321.10 rows=82 width=40) (actual rows= loops=)

4. 0.000 0.000 ↓ 0.0

Sort (cost=319.46..319.67 rows=82 width=40) (actual rows= loops=)

  • Sort Key: r.cluster_id, r.date
5. 0.000 0.000 ↓ 0.0

Nested Loop (cost=0.00..316.86 rows=82 width=40) (actual rows= loops=)

6. 0.000 0.000 ↓ 0.0

Append (cost=0.00..120.79 rows=84 width=40) (actual rows= loops=)

7. 0.000 0.000 ↓ 0.0

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

  • Filter: ((deleted_on IS NULL) AND (date > '2020-05-19 00:00:00'::timestamp without time zone) AND (source_id = 5))
8. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (date > '2020-05-19 00:00:00'::timestamp without time zone)
  • Filter: ((deleted_on IS NULL) AND (source_id = 5))
9. 0.000 0.000 ↓ 0.0

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

  • Index Cond: (cluster_id = r.cluster_id)" Filter: (deleted_on IS NULL)