explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UHsU

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

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

2. 15.491 235.228 ↓ 1.5 3 1

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

  • Workers Planned: 2
  • Workers Launched: 2
3. 4.446 219.737 ↑ 1.0 1 3 / 3

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

4. 63.436 215.291 ↓ 1.5 6,239 3 / 3

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

  • Hash Cond: (ct.couponnewid = c.newid)
5. 79.531 79.531 ↑ 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.019..79.531 rows=151,001 loops=3)

6. 14.415 72.324 ↑ 1.1 19,551 3 / 3

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

  • Buckets: 32768 Batches: 1 Memory Usage: 1020kB
7. 47.897 57.909 ↑ 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=10.494..57.909 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. 10.012 10.012 ↓ 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=10.012..10.012 rows=21,991 loops=3)

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