explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SjFx

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 0.616 ↓ 0.0 0 1

"Nested Loop (cost=67.18..69.23 rows=1 width=16) (actual time=0.616..0.616 rows=0 loops=1)

2. 0.008 0.538 ↑ 1.0 1 1

HashAggregate (cost=66.90..66.91 rows=1 width=16) (actual time=0.538..0.538 rows=1 loops=1)

  • Group Key: violations.violation_id
3. 0.292 0.530 ↑ 1.0 1 1

Hash Semi Join (cost=37.14..66.90 rows=1 width=16) (actual time=0.428..0.530 rows=1 loops=1)

  • Hash Cond: ((violations.properties ->> 'bulletin_id'::text) = (violation_asset_remediation.remediation_details ->> 'name'::text))
4. 0.132 0.132 ↑ 1.0 136 1

Seq Scan on violations (cost=0.00..29.36 rows=136 width=198) (actual time=0.022..0.132 rows=136 loops=1)

5. 0.015 0.106 ↑ 1.0 1 1

Hash (cost=37.12..37.12 rows=1 width=187) (actual time=0.105..0.106 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
6. 0.091 0.091 ↑ 1.0 1 1

Seq Scan on violation_asset_remediation (cost=0.00..37.12 rows=1 width=187) (actual time=0.090..0.091 rows=1 loops=1)

  • Filter: ((id = '6fc7a253-c504-44ea-a196-19b4ec2345d1'::uuid) AND ((remediation_details ->> 'content_type'::text) = 'Patch'::text))
  • Rows Removed by Filter: 8
7. 0.072 0.072 ↓ 0.0 0 1

Index Scan using violation_assets_uindx on violation_assets va (cost=0.28..2.31 rows=1 width=16) (actual time=0.072..0.072 rows=0 loops=1)

  • Index Cond: (violation_id = violations.violation_id)
  • Filter: (((asset_id)::text = (mapping_id)::text) AND (state <> ALL ('{20,21,22,23,24,25,26,27}'::integer[])))
  • Rows Removed by Filter: 5
Planning time : 2.398 ms