explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Q9uC

Settings
# exclusive inclusive rows x rows loops node
1. 0.008 2.623 ↑ 750.0 1 1

Subquery Scan on products (cost=35.62..8,773.59 rows=750 width=91) (actual time=2.618..2.623 rows=1 loops=1)

  • Filter: ((products.fields ->> 'code_prod'::text) = '1fVZwNOEJM8n1F6ZtSHUV1KZ92Hnap52vQRRtwm38kh0QdP9Vn_3'::text)
  • Rows Removed by Filter: 2
2. 0.030 2.615 ↑ 50,000.0 3 1

ProjectSet (cost=35.62..6,523.59 rows=150,000 width=91) (actual time=2.609..2.615 rows=3 loops=1)

3. 0.717 2.585 ↑ 1,500.0 1 1

Bitmap Heap Scan on ph_certificate (cost=35.62..5,762.34 rows=1,500 width=1,737) (actual time=2.583..2.585 rows=1 loops=1)

  • Recheck Cond: (fields @> '[{"code_prod": "1fVZwNOEJM8n1F6ZtSHUV1KZ92Hnap52vQRRtwm38kh0QdP9Vn_3"}]'::jsonb)
  • Heap Blocks: exact=1
4. 1.868 1.868 ↑ 1,500.0 1 1

Bitmap Index Scan on ph_certificate_fields_gin_idx (cost=0.00..35.25 rows=1,500 width=0) (actual time=1.867..1.868 rows=1 loops=1)

  • Index Cond: (fields @> '[{"code_prod": "1fVZwNOEJM8n1F6ZtSHUV1KZ92Hnap52vQRRtwm38kh0QdP9Vn_3"}]'::jsonb)
Planning time : 13.229 ms
Execution time : 3.173 ms