explain.depesz.com

PostgreSQL's explain analyze made readable

Result: YUKw

Settings
# exclusive inclusive rows x rows loops node
1. 948.246 21,026.375 ↑ 1.0 1 1

Aggregate (cost=997,080.94..997,080.95 rows=1 width=4) (actual time=21,026.374..21,026.375 rows=1 loops=1)

2. 574.564 20,078.129 ↓ 1.0 918,043 1

Hash Join (cost=209,530.10..994,807.85 rows=909,238 width=16) (actual time=5,477.625..20,078.129 rows=918,043 loops=1)

  • Hash Cond: (reviews.location_id = locations.location_id)
3. 752.783 18,183.500 ↓ 1.0 918,043 1

Hash Left Join (cost=48,531.37..815,348.35 rows=909,238 width=32) (actual time=4,150.977..18,183.500 rows=918,043 loops=1)

  • Hash Cond: (reviews.review_id = review_responses.review_id)
4. 13,373.602 17,133.248 ↓ 1.0 918,043 1

Bitmap Heap Scan on reviews (cost=32,092.38..795,277.77 rows=909,238 width=32) (actual time=3,851.850..17,133.248 rows=918,043 loops=1)

  • Recheck Cond: (account_id = '9bccfdd7-67c7-45d3-8a37-14f5c8dd4de6'::uuid)
  • Filter: ((NOT is_done) AND (source_provider = ANY ('{11,16,2,3,6}'::integer[])))
  • Rows Removed by Filter: 55647
  • Heap Blocks: exact=314739
5. 3,759.646 3,759.646 ↓ 1.0 973,801 1

Bitmap Index Scan on reviews_order_by_account_id_idx (cost=0.00..31,865.07 rows=930,801 width=0) (actual time=3,759.646..3,759.646 rows=973,801 loops=1)

  • Index Cond: (account_id = '9bccfdd7-67c7-45d3-8a37-14f5c8dd4de6'::uuid)
6. 73.653 297.469 ↑ 1.0 216,470 1

Hash (cost=13,732.33..13,732.33 rows=216,533 width=16) (actual time=297.469..297.469 rows=216,470 loops=1)

  • Buckets: 262144 Batches: 1 Memory Usage: 12196kB
7. 223.816 223.816 ↑ 1.0 216,470 1

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

8. 301.040 1,320.065 ↓ 1.0 746,464 1

Hash (cost=148,035.77..148,035.77 rows=745,677 width=16) (actual time=1,320.065..1,320.065 rows=746,464 loops=1)

  • Buckets: 1048576 Batches: 2 Memory Usage: 25697kB
9. 1,019.025 1,019.025 ↓ 1.0 746,464 1

Seq Scan on locations (cost=0.00..148,035.77 rows=745,677 width=16) (actual time=0.025..1,019.025 rows=746,464 loops=1)

Planning time : 21.122 ms
Execution time : 21,030.193 ms