explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s9Zk

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 257.212 ↑ 1.0 1 1

Finalize Aggregate (cost=48,164.54..48,164.55 rows=1 width=32) (actual time=257.212..257.212 rows=1 loops=1)

2. 24.297 264.838 ↓ 1.5 3 1

Gather (cost=48,164.32..48,164.53 rows=2 width=32) (actual time=250.623..264.838 rows=3 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
3. 1.812 240.541 ↑ 1.0 1 3 / 3

Partial Aggregate (cost=47,164.32..47,164.33 rows=1 width=32) (actual time=240.541..240.541 rows=1 loops=3)

4. 60.158 238.729 ↓ 1.5 6,239 3 / 3

Hash Join (cost=37,933.47..47,153.59 rows=4,293 width=5) (actual time=105.715..238.729 rows=6,239 loops=3)

  • Hash Cond: (ct.couponnewid = c.newid)
5. 80.985 80.985 ↑ 1.3 151,001 3 / 3

Parallel Seq Scan on coupontransaction ct (cost=0.00..8,709.85 rows=194,385 width=13) (actual time=0.015..80.985 rows=151,001 loops=3)

6. 16.809 97.586 ↑ 1.1 19,551 3 / 3

Hash (cost=37,664.20..37,664.20 rows=21,542 width=8) (actual time=97.586..97.586 rows=19,551 loops=3)

  • Buckets: 32768 Batches: 1 Memory Usage: 1020kB
7. 73.371 80.777 ↑ 1.1 19,551 3 / 3

Bitmap Heap Scan on coupon c (cost=1,154.49..37,664.20 rows=21,542 width=8) (actual time=11.926..80.777 rows=19,551 loops=3)

  • Recheck Cond: (playerid = '65e98a4a-a2f3-4d6d-9b80-7b923b743ed6'::uuid)
  • Filter: ((status)::text = 'active'::text)
  • Rows Removed by Filter: 8
  • Heap Blocks: exact=3029
8. 7.406 7.406 ↓ 1.0 21,991 3 / 3

Bitmap Index Scan on coupon_playerid_idx (cost=0.00..1,149.10 rows=21,557 width=0) (actual time=7.406..7.406 rows=21,991 loops=3)

  • Index Cond: (playerid = '65e98a4a-a2f3-4d6d-9b80-7b923b743ed6'::uuid)
Planning time : 0.605 ms
Execution time : 264.956 ms