explain.depesz.com

PostgreSQL's explain analyze made readable

Result: iWga

Settings
# exclusive inclusive rows x rows loops node
1. 14.255 4,106.975 ↑ 3.0 1 1

Gather (cost=1,000.00..158,295.22 rows=3 width=91) (actual time=173.677..4,106.975 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.004 4,092.720 ↓ 0.0 0 3

Subquery Scan on products (cost=0.00..157,294.92 rows=3 width=91) (actual time=2,781.764..4,092.720 rows=0 loops=3)

  • Filter: ((products.fields ->> 'code_prod'::text) = 'wKH24xNwX9wJdjottAx04T0xjR7T6Gtsh0lboZxbYUL230mnqJ_1'::text)
  • Rows Removed by Filter: 1
3. 0.010 4,092.716 ↑ 25,700.0 1 3

ProjectSet (cost=0.00..157,285.68 rows=25,700 width=91) (actual time=2,781.762..4,092.716 rows=1 loops=3)

4. 4,092.706 4,092.706 ↓ 0.0 0 3

Parallel Seq Scan on ph_certificate (cost=0.00..157,155.25 rows=257 width=1,737) (actual time=2,781.752..4,092.706 rows=0 loops=3)

  • Filter: (fields @> '[{"code_prod": "wKH24xNwX9wJdjottAx04T0xjR7T6Gtsh0lboZxbYUL230mnqJ_1"}]'::jsonb)
  • Rows Removed by Filter: 200000
Planning time : 0.083 ms
Execution time : 4,107.009 ms