explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LJLx

Settings
# exclusive inclusive rows x rows loops node
1. 108.674 188.488 ↓ 1.0 23,463 1

Hash Right Join (cost=8,371.44..23,310.67 rows=22,657 width=34) (actual time=21.582..188.488 rows=23,463 loops=1)

  • Hash Cond: (details.customer_id = customers.id)
2. 58.628 58.628 ↑ 1.0 523,175 1

Seq Scan on details (cost=0.00..12,750.75 rows=523,175 width=19) (actual time=0.026..58.628 rows=523,175 loops=1)

3. 4.964 21.186 ↓ 1.0 23,463 1

Hash (cost=8,088.23..8,088.23 rows=22,657 width=19) (actual time=21.186..21.186 rows=23,463 loops=1)

  • Buckets: 32768 Batches: 1 Memory Usage: 1583kB
4. 11.411 16.222 ↓ 1.0 23,463 1

Bitmap Heap Scan on customers (cost=428.01..8,088.23 rows=22,657 width=19) (actual time=5.809..16.222 rows=23,463 loops=1)

  • Recheck Cond: (pro_user_id = 585)
  • Heap Blocks: exact=5639
5. 4.811 4.811 ↓ 1.0 23,463 1

Bitmap Index Scan on index_customers_on_pro_user_id (cost=0.00..422.35 rows=22,657 width=0) (actual time=4.811..4.811 rows=23,463 loops=1)

  • Index Cond: (pro_user_id = 585)