explain.depesz.com

PostgreSQL's explain analyze made readable

Result: tsgK

Settings
# exclusive inclusive rows x rows loops node
1. 1.140 3,656.052 ↑ 1.0 1 1

Aggregate (cost=33,620.16..33,620.17 rows=1 width=4) (actual time=3,656.052..3,656.052 rows=1 loops=1)

2. 0.000 3,654.912 ↓ 2.8 12,087 1

Nested Loop (cost=6,912.26..33,609.23 rows=4,371 width=16) (actual time=3,524.609..3,654.912 rows=12,087 loops=1)

3. 67.755 3,618.695 ↓ 2.8 12,087 1

Hash Right Join (cost=6,911.83..21,212.56 rows=4,371 width=32) (actual time=3,524.501..3,618.695 rows=12,087 loops=1)

  • Hash Cond: (review_responses.review_id = reviews.review_id)
4. 67.913 67.913 ↑ 1.0 216,470 1

Seq Scan on review_responses (cost=0.00..13,732.33 rows=216,533 width=16) (actual time=0.020..67.913 rows=216,470 loops=1)

5. 18.725 3,483.027 ↓ 2.8 12,087 1

Hash (cost=6,857.20..6,857.20 rows=4,371 width=32) (actual time=3,483.027..3,483.027 rows=12,087 loops=1)

  • Buckets: 16384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 884kB
6. 3,464.302 3,464.302 ↓ 2.8 12,087 1

Index Scan using reviews_order_by_account_id_idx on reviews (cost=0.56..6,857.20 rows=4,371 width=32) (actual time=2.662..3,464.302 rows=12,087 loops=1)

  • Index Cond: ((account_id = '9bccfdd7-67c7-45d3-8a37-14f5c8dd4de6'::uuid) AND (posting_timestamp >= '2019-05-01 00:00:00'::timestamp without time zone) AND (posting_timestamp <= now()))
  • Filter: ((NOT is_done) AND (source_provider = ANY ('{11,16,2,3,6}'::integer[])))
  • Rows Removed by Filter: 46
7. 36.261 36.261 ↑ 1.0 1 12,087

Index Only Scan using locations_pkey on locations (cost=0.42..2.84 rows=1 width=16) (actual time=0.003..0.003 rows=1 loops=12,087)

  • Index Cond: (location_id = reviews.location_id)
  • Heap Fetches: 12087
Planning time : 5.758 ms
Execution time : 3,656.169 ms