explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aYEh

Settings
# exclusive inclusive rows x rows loops node
1. 0.003 5,415.591 ↑ 1.0 1 1

Limit (cost=1,344,911.49..1,344,911.50 rows=1 width=4) (actual time=5,415.590..5,415.591 rows=1 loops=1)

2. 0.000 5,415.588 ↑ 1.0 1 1

Finalize Aggregate (cost=1,344,911.49..1,344,911.50 rows=1 width=4) (actual time=5,415.587..5,415.588 rows=1 loops=1)

3. 110.241 5,510.402 ↓ 1.5 3 1

Gather (cost=1,344,911.27..1,344,911.48 rows=2 width=8) (actual time=5,405.946..5,510.402 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 34.294 5,400.161 ↑ 1.0 1 3

Partial Aggregate (cost=1,343,911.27..1,343,911.28 rows=1 width=8) (actual time=5,400.161..5,400.161 rows=1 loops=3)

5. 130.929 5,365.867 ↑ 1.5 322,168 3

Hash Join (cost=242,234.10..1,342,705.84 rows=482,172 width=16) (actual time=3,326.960..5,365.867 rows=322,168 loops=3)

  • Hash Cond: (reviews.location_id = locations.location_id)
6. 83.240 2,461.409 ↑ 1.5 322,168 3

Hash Left Join (cost=52,467.10..1,151,673.12 rows=482,172 width=32) (actual time=545.785..2,461.409 rows=322,168 loops=3)

  • Hash Cond: (reviews.review_id = review_responses.review_id)
7. 1,985.323 2,378.112 ↑ 1.5 322,168 3

Parallel Bitmap Heap Scan on reviews (cost=52,465.76..1,149,863.63 rows=482,172 width=32) (actual time=545.458..2,378.112 rows=322,168 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: 18600
  • Heap Blocks: exact=131547
8. 392.789 392.789 ↑ 1.1 1,025,621 1

Bitmap Index Scan on reviews_order_by_account_id_idx (cost=0.00..52,176.46 rows=1,177,386 width=0) (actual time=392.789..392.789 rows=1,025,621 loops=1)

  • Index Cond: (account_id = '9bccfdd7-67c7-45d3-8a37-14f5c8dd4de6'::uuid)
9. 0.013 0.057 ↑ 1.0 15 3

Hash (cost=1.15..1.15 rows=15 width=16) (actual time=0.057..0.057 rows=15 loops=3)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
10. 0.044 0.044 ↑ 1.0 15 3

Seq Scan on review_responses (cost=0.00..1.15 rows=15 width=16) (actual time=0.040..0.044 rows=15 loops=3)

11. 446.159 2,773.529 ↑ 1.0 799,205 3

Hash (cost=179,758.98..179,758.98 rows=800,642 width=16) (actual time=2,773.528..2,773.529 rows=799,205 loops=3)

  • Buckets: 1048576 Batches: 1 Memory Usage: 45655kB
12. 2,327.370 2,327.370 ↑ 1.0 799,205 3

Index Only Scan using locations_pkey on locations (cost=0.42..179,758.98 rows=800,642 width=16) (actual time=0.166..2,327.370 rows=799,205 loops=3)

  • Heap Fetches: 307925
Planning time : 0.940 ms
Execution time : 5,517.033 ms