explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wZgF

Settings
# exclusive inclusive rows x rows loops node
1. 56.855 6,508.254 ↓ 1.1 11,603 1

HashAggregate (cost=743,165.86..743,268.22 rows=10,236 width=12) (actual time=6,504.825..6,508.254 rows=11,603 loops=1)

  • Group Key: store_settings.store_id
2. 121.522 6,451.399 ↓ 14.0 142,804 1

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

  • Hash Cond: (transaction.customer_pay_id = customer_pay.id)
3. 178.501 204.106 ↓ 1.3 204,982 1

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

  • Recheck Cond: ((store_id = 1860429) AND (result = 2))
  • Filter: (is_test IS FALSE)
  • Heap Blocks: exact=70333
4. 25.605 25.605 ↓ 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=25.605..25.605 rows=205,009 loops=1)

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

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

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

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

  • Hash Cond: (customer_pay.customer_id = store_settings.customer_id)
7. 1,954.713 1,954.713 ↓ 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..1,954.713 rows=8,027,525 loops=1)

8. 33.474 95.359 ↑ 1.0 103,909 1

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

  • Buckets: 16384 Batches: 1 Memory Usage: 4871kB
9. 61.885 61.885 ↓ 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..61.885 rows=103,939 loops=1)

Planning time : 0.487 ms
Execution time : 6,510.402 ms