By using db<>fiddle, you agree to license everything you submit by Creative Commons CC0.
5 rows affected
8 rows affected
| QUERY PLAN |
|---|
| [ { "Plan": { "Node Type": "Nested Loop", "Parallel Aware": false, "Async Capable": false, "Join Type": "Inner", "Startup Cost": 0.00, "Total Cost": 46290.60, "Plan Rows": 90427, "Plan Width": 64, "Inner Unique": false, "Join Filter": "((p.poa_code)::text = ANY ((g.postcodefootprint)::text[]))", "Plans": [ { "Node Type": "Seq Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Relation Name": "groups", "Alias": "g", "Startup Cost": 0.00, "Total Cost": 23.60, "Plan Rows": 1360, "Plan Width": 32 }, { "Node Type": "Materialize", "Parent Relationship": "Inner", "Parallel Aware": false, "Async Capable": false, "Startup Cost": 0.00, "Total Cost": 30.40, "Plan Rows": 1360, "Plan Width": 32, "Plans": [ { "Node Type": "Seq Scan", "Parent Relationship": "Outer", "Parallel Aware": false, "Async Capable": false, "Relation Name": "au_postcode", "Alias": "p", "Startup Cost": 0.00, "Total Cost": 23.60, "Plan Rows": 1360, "Plan Width": 32 } ] } ] } } ] |