explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 6p33

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 2,906.079 ↑ 1.0 1 1

Finalize Aggregate (cost=975,821.93..975,821.94 rows=1 width=4) (actual time=2,906.079..2,906.079 rows=1 loops=1)

2. 87.684 2,968.943 ↓ 1.5 3 1

Gather (cost=975,821.71..975,821.92 rows=2 width=8) (actual time=2,906.058..2,968.943 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 33.819 2,881.259 ↑ 1.0 1 3

Partial Aggregate (cost=974,821.71..974,821.72 rows=1 width=8) (actual time=2,881.259..2,881.259 rows=1 loops=3)

4. 229.641 2,847.440 ↑ 1.2 306,026 3

Hash Join (cost=209,540.18..973,874.59 rows=378,849 width=16) (actual time=1,701.515..2,847.440 rows=306,026 loops=3)

  • Hash Cond: (reviews.location_id = locations.location_id)
5. 182.476 1,392.240 ↑ 1.2 306,026 3

Hash Left Join (cost=48,531.37..803,049.29 rows=378,849 width=32) (actual time=469.525..1,392.240 rows=306,026 loops=3)

  • Hash Cond: (reviews.review_id = review_responses.review_id)
6. 836.949 1,038.612 ↑ 1.2 306,026 3

Parallel Bitmap Heap Scan on reviews (cost=32,092.38..785,097.13 rows=378,849 width=32) (actual time=296.446..1,038.612 rows=306,026 loops=3)

  • 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: 18549
  • Heap Blocks: exact=234863
7. 201.663 201.663 ↓ 1.0 973,870 1

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

  • Index Cond: (account_id = '9bccfdd7-67c7-45d3-8a37-14f5c8dd4de6'::uuid)
8. 62.605 171.152 ↑ 1.0 216,470 3

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

  • Buckets: 262144 Batches: 1 Memory Usage: 12196kB
9. 108.547 108.547 ↑ 1.0 216,470 3

Seq Scan on review_responses (cost=0.00..13,732.33 rows=216,533 width=16) (actual time=0.043..108.547 rows=216,470 loops=3)

10. 323.061 1,225.559 ↓ 1.0 746,464 3

Hash (cost=148,045.25..148,045.25 rows=745,725 width=16) (actual time=1,225.559..1,225.559 rows=746,464 loops=3)

  • Buckets: 1048576 Batches: 2 Memory Usage: 25697kB
11. 902.498 902.498 ↓ 1.0 746,464 3

Seq Scan on locations (cost=0.00..148,045.25 rows=745,725 width=16) (actual time=0.045..902.498 rows=746,464 loops=3)

Planning time : 0.759 ms
Execution time : 2,971.334 ms