explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lSP2

Settings
# exclusive inclusive rows x rows loops node
1. 0.013 0.306 ↑ 1.0 1 1

Aggregate (cost=43.48..43.49 rows=1 width=40) (actual time=0.306..0.306 rows=1 loops=1)

2. 0.010 0.010 ↑ 1.0 3 1

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

3.          

SubPlan (for Aggregate)

4. 0.012 0.273 ↑ 1.0 1 3

Aggregate (cost=13.02..13.03 rows=1 width=8) (actual time=0.091..0.091 rows=1 loops=3)

5. 0.261 0.261 ↑ 3.4 34 3

Seq Scan on orders o (cost=0.00..12.73 rows=114 width=0) (actual time=0.045..0.087 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.000 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.010 0.010 ↓ 0.0 0 2

Seq Scan on physical_sale ps (cost=0.00..1.09 rows=1 width=0) (actual time=0.005..0.005 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.201 ms
Execution time : 0.355 ms