explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Dt7A

Settings
# exclusive inclusive rows x rows loops node
1. 2,601.657 3,745.153 ↓ 1.0 3,217,152 1

Index Scan using brand_user_all_time_pkey on brand_user_all_time (cost=0.43..5,946,514.16 rows=3,214,969 width=20) (actual time=0.042..3,745.153 rows=3,217,152 loops=1)

  • Index Cond: (id_brand = 'AC'::bpchar)
2.          

SubPlan (forIndex Scan)

3. 285.874 1,143.496 ↑ 1.0 1 285,874

Aggregate (cost=1.76..1.77 rows=1 width=8) (actual time=0.004..0.004 rows=1 loops=285,874)

4. 857.622 857.622 ↑ 100.0 1 285,874

Function Scan on json_each_text (cost=0.01..1.01 rows=100 width=32) (actual time=0.003..0.003 rows=1 loops=285,874)