explain.depesz.com

PostgreSQL's explain analyze made readable

Result: FjUy

Settings
# exclusive inclusive rows x rows loops node
1. 0.011 0.297 ↑ 1.0 1 1

Aggregate (cost=42.24..42.25 rows=1 width=40) (actual time=0.297..0.297 rows=1 loops=1)

2. 0.009 0.009 ↑ 1.0 3 1

Seq Scan on seller s (cost=0.00..1.03 rows=3 width=6) (actual time=0.006..0.009 rows=3 loops=1)

3.          

SubPlan (for Aggregate)

4. 0.009 0.267 ↑ 1.0 1 3

Aggregate (cost=12.61..12.62 rows=1 width=8) (actual time=0.089..0.089 rows=1 loops=3)

5. 0.258 0.258 ↑ 3.0 34 3

Seq Scan on orders o (cost=0.00..12.35 rows=102 width=0) (actual time=0.040..0.086 rows=34 loops=3)

  • Filter: ((id_seller = s.id) AND (create_date >= (date_trunc('day'::text, now()) - '30 days'::interval)))
  • Rows Removed by Filter: 115
6. 0.002 0.010 ↑ 1.0 1 2

Aggregate (cost=1.09..1.10 rows=1 width=8) (actual time=0.005..0.005 rows=1 loops=2)

7. 0.008 0.008 ↓ 0.0 0 2

Seq Scan on physical_sale ps (cost=0.00..1.09 rows=1 width=0) (actual time=0.004..0.004 rows=0 loops=2)

  • Filter: ((id_seller = s.id) AND (create_date >= (date_trunc('day'::text, now()) - '30 days'::interval)))
  • Rows Removed by Filter: 25
Planning time : 0.298 ms
Execution time : 0.353 ms