explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 9OR3

Settings
# exclusive inclusive rows x rows loops node
1. 0.285 2.133 ↑ 1.0 150 1

Sort (cost=440.53..440.90 rows=150 width=394) (actual time=2.126..2.133 rows=150 loops=1)

  • Sort Key: wr.priority, wr."createdAt
  • Sort Method: quicksort Memory: 128kB
2. 0.895 1.848 ↑ 1.0 150 1

HashAggregate (cost=433.23..435.11 rows=150 width=394) (actual time=1.760..1.848 rows=150 loops=1)

  • Group Key: wr.id
3. 0.200 0.953 ↑ 12.9 182 1

Hash Left Join (cost=25.79..392.11 rows=2,350 width=410) (actual time=0.258..0.953 rows=182 loops=1)

  • Hash Cond: (((obj.value ->> 0))::uuid = c.id)
  • Filter: CASE WHEN (c."campaignId" IS NOT NULL) THEN ((c.status = 1) OR ((c.status <> 1) AND (c."updatedAt" > '2019-12-30 09:02:12.188055'::timestamp without time zone))) ELSE true END
4. 0.071 0.570 ↑ 25.8 182 1

Nested Loop Left Join (cost=0.01..351.38 rows=4,700 width=394) (actual time=0.053..0.570 rows=182 loops=1)

  • Join Filter: (wr.source = 2)
5. 0.199 0.199 ↑ 1.0 150 1

Seq Scan on "webhookRoutes" wr (cost=0.00..13.88 rows=150 width=362) (actual time=0.013..0.199 rows=150 loops=1)

  • Filter: (status = 1)
6. 0.300 0.300 ↓ 0.0 0 150

Function Scan on jsonb_array_elements obj (cost=0.01..1.00 rows=100 width=32) (actual time=0.002..0.002 rows=0 loops=150)

7. 0.045 0.183 ↓ 1.0 127 1

Hash (cost=24.24..24.24 rows=124 width=51) (actual time=0.182..0.183 rows=127 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 19kB
8. 0.138 0.138 ↓ 1.0 127 1

Seq Scan on campaigns c (cost=0.00..24.24 rows=124 width=51) (actual time=0.010..0.138 rows=127 loops=1)

Planning time : 1.414 ms
Execution time : 2.428 ms