explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 133c : 7.6kk meetup

Settings
# exclusive inclusive rows x rows loops node
1. 11.168 264,112.456 ↑ 38.0 1 1

Gather (cost=1,000.00..614,388.74 rows=38 width=131) (actual time=264,108.240..264,112.456 rows=1 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
2. 0.004 264,101.288 ↓ 0.0 0 3

Subquery Scan on products (cost=0.00..613,384.94 rows=38 width=131) (actual time=176,356.041..264,101.288 rows=0 loops=3)

  • Filter: ((products.fields ->> 'code_prod'::text) = 'ot0ZvoM5dktbAYknbLWGXjazhpmdajfoC6eYkRTn1cps1AG2cs_2'::text)
  • Rows Removed by Filter: 1
3. 0.031 264,101.284 ↑ 319,800.0 1 3

ProjectSet (cost=0.00..613,269.83 rows=319,800 width=131) (actual time=176,356.037..264,101.284 rows=1 loops=3)

4. 264,101.253 264,101.253 ↓ 0.0 0 3

Parallel Seq Scan on ph_certificate (cost=0.00..611,646.85 rows=3,198 width=446) (actual time=176,356.008..264,101.253 rows=0 loops=3)

  • Filter: (fields @> '[{"code_prod": "ot0ZvoM5dktbAYknbLWGXjazhpmdajfoC6eYkRTn1cps1AG2cs_2"}]'::jsonb)
  • Rows Removed by Filter: 2544979
Planning time : 0.107 ms
Execution time : 264,112.499 ms