explain.depesz.com

PostgreSQL's explain analyze made readable

Result: l8eW

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

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

2. 23.495 253.960 ↓ 1.5 3 1

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

  • Workers Planned: 2
  • Workers Launched: 2
3. 4.333 230.465 ↑ 1.0 1 3 / 3

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

4. 60.177 226.132 ↓ 1.5 6,239 3 / 3

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

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

6. 11.617 74.464 ↑ 1.1 19,551 3 / 3

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

  • Buckets: 32768 Batches: 1 Memory Usage: 1020kB
7. 55.637 62.847 ↑ 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=7.687..62.847 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.210 7.210 ↓ 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.210..7.210 rows=21,991 loops=3)

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