explain.depesz.com

PostgreSQL's explain analyze made readable

Result: DvxV

Settings
# exclusive inclusive rows x rows loops node
1. 68.548 25,899.342 ↓ 1.1 11,603 1

HashAggregate (cost=743,165.86..743,268.22 rows=10,236 width=12) (actual time=25,896.042..25,899.342 rows=11,603 loops=1)

  • Group Key: store_settings.store_id
2. 148.210 25,830.794 ↓ 14.0 142,804 1

Hash Join (cost=327,198.87..743,114.68 rows=10,236 width=12) (actual time=6,743.431..25,830.794 rows=142,804 loops=1)

  • Hash Cond: (transaction.customer_pay_id = customer_pay.id)
3. 18,954.342 19,406.233 ↓ 1.3 204,982 1

Bitmap Heap Scan on transaction (cost=4,460.34..415,597.50 rows=160,346 width=12) (actual time=466.781..19,406.233 rows=204,982 loops=1)

  • Recheck Cond: ((store_id = 1860429) AND (result = 2))
  • Filter: (is_test IS FALSE)
  • Heap Blocks: exact=70333
4. 451.891 451.891 ↓ 1.3 205,009 1

Bitmap Index Scan on idx_transaction_store_id_result (cost=0.00..4,420.26 rows=160,769 width=0) (actual time=451.891..451.891 rows=205,009 loops=1)

  • Index Cond: ((store_id = 1860429) AND (result = 2))
5. 32.082 6,276.351 ↑ 11.5 44,550 1

Hash (cost=313,807.74..313,807.74 rows=513,743 width=16) (actual time=6,276.351..6,276.351 rows=44,550 loops=1)

  • Buckets: 65536 Batches: 2 Memory Usage: 1047kB
6. 4,113.708 6,244.269 ↑ 11.5 44,550 1

Hash Join (cost=12,322.47..313,807.74 rows=513,743 width=16) (actual time=96.671..6,244.269 rows=44,550 loops=1)

  • Hash Cond: (customer_pay.customer_id = store_settings.customer_id)
7. 2,034.044 2,034.044 ↓ 1.0 8,027,525 1

Seq Scan on customer_pay (cost=0.00..216,236.92 rows=8,011,092 width=16) (actual time=0.006..2,034.044 rows=8,027,525 loops=1)

8. 33.747 96.517 ↑ 1.0 103,909 1

Hash (cost=11,023.32..11,023.32 rows=103,932 width=16) (actual time=96.517..96.517 rows=103,909 loops=1)

  • Buckets: 16384 Batches: 1 Memory Usage: 4871kB
9. 62.770 62.770 ↓ 1.0 103,939 1

Seq Scan on store_settings (cost=0.00..11,023.32 rows=103,932 width=16) (actual time=0.004..62.770 rows=103,939 loops=1)

Planning time : 0.532 ms
Execution time : 25,901.494 ms