explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bCgn

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

Result (cost=9,772.77..9,772.78 rows=1 width=32) (actual time=11.933..11.933 rows=1 loops=1)

2.          

Initplan (for Result)

3. 6.067 13.413 ↑ 9.5 335 1

Gather (cost=1,000.42..9,772.77 rows=3,170 width=16) (actual time=0.222..13.413 rows=335 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 1.756 7.346 ↑ 11.8 112 3 / 3

Nested Loop (cost=0.42..8,455.77 rows=1,321 width=16) (actual time=0.438..7.346 rows=112 loops=3)

5. 5.590 5.590 ↑ 1.3 2,674 3 / 3

Parallel Seq Scan on merchants merch (cost=0.00..3,281.43 rows=3,343 width=32) (actual time=0.153..5.590 rows=2,674 loops=3)

6. 0.000 0.000 ↓ 0.0 0 8,023 / 3

Index Scan using offers_pkey on offers (cost=0.42..1.55 rows=1 width=16) (actual time=0.000..0.000 rows=0 loops=8,023)

  • Index Cond: (offer_id = merch.active_offer)
  • Filter: (status = 'ON'::offer_status)
Planning time : 0.264 ms
Execution time : 13.587 ms