explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rOYh : 1.5kk meetup

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

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

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

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

3. 0.038 5.652 ↑ 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=5.651..5.652 rows=1 loops=1)

  • Recheck Cond: (fields @> '[{"code_prod": "1fVZwNOEJM8n1F6ZtSHUV1KZ92Hnap52vQRRtwm38kh0QdP9Vn_3"}]'::jsonb)
  • Heap Blocks: exact=1
4. 5.614 5.614 ↑ 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=5.613..5.614 rows=1 loops=1)

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