explain.depesz.com

PostgreSQL's explain analyze made readable

Result: VLBL

Settings
# exclusive inclusive rows x rows loops node
1. 0.145 1.648 ↑ 1.0 150 1

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

  • Sort Key: wr.priority
  • Sort Method: quicksort Memory: 128kB
2. 0.778 1.503 ↑ 1.0 150 1

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

  • Group Key: wr.id
3. 0.169 0.725 ↑ 12.9 182 1

Hash Left Join (cost=25.79..392.11 rows=2,350 width=410) (actual time=0.145..0.725 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:05:56.582978'::timestamp without time zone))) ELSE true END
4. 0.162 0.445 ↑ 25.8 182 1

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

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

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

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

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

7. 0.032 0.111 ↓ 1.0 127 1

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

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

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

Planning time : 0.364 ms
Execution time : 1.739 ms