explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UJOM

Settings
# exclusive inclusive rows x rows loops node
1. 672.483 672.483 ↑ 3.0 2,559 1

CTE Scan on q (cost=14,694.91..14,964.58 rows=7,705 width=104) (actual time=176.754..672.483 rows=2,559 loops=1)

2.          

CTE q

3. 1.461 669.730 ↑ 3.0 2,559 1

Nested Loop (cost=4.12..14,694.91 rows=7,705 width=51) (actual time=176.725..669.730 rows=2,559 loops=1)

4.          

CTE ean

5. 0.197 0.197 ↓ 12.8 1,283 1

ProjectSet (cost=0.00..0.52 rows=100 width=8) (actual time=0.001..0.197 rows=1,283 loops=1)

6. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=0) (actual time=0.000..0.000 rows=1 loops=1)

7.          

CTE dt

8. 0.000 0.000 ↑ 1.0 1 1

Result (cost=0.00..0.01 rows=1 width=4) (actual time=0.000..0.000 rows=1 loops=1)

9.          

CTE b

10. 0.193 0.738 ↓ 12.8 1,283 1

Nested Loop (cost=0.00..3.02 rows=100 width=12) (actual time=0.004..0.738 rows=1,283 loops=1)

11. 0.002 0.002 ↑ 1.0 1 1

CTE Scan on dt (cost=0.00..0.02 rows=1 width=4) (actual time=0.001..0.002 rows=1 loops=1)

12. 0.543 0.543 ↓ 12.8 1,283 1

CTE Scan on ean (cost=0.00..2.00 rows=100 width=8) (actual time=0.002..0.543 rows=1,283 loops=1)

13. 1.109 1.109 ↓ 12.8 1,283 1

CTE Scan on b (cost=0.00..2.00 rows=100 width=12) (actual time=0.004..1.109 rows=1,283 loops=1)

14. 667.160 667.160 ↑ 38.5 2 1,283

Index Scan using paragon_date_trunc_ean_idx on paragon s (cost=0.57..146.12 rows=77 width=47) (actual time=0.519..0.520 rows=2 loops=1,283)

  • Index Cond: ((date_trunc('day'::text, dt) = b.dt) AND (ean = b.ean))
Planning time : 1.457 ms
Execution time : 672.783 ms