explain.depesz.com

PostgreSQL's explain analyze made readable

Result: rd5x : Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: Optimization for: plan #8x6nX; plan #5Iv; plan #8BRp; plan #Chgc; plan #t2mf; plan #oirU; plan #J12Z; plan #HG1h; plan #ydO

Settings

Optimization path:

# exclusive inclusive rows x rows loops node
1. 0.001 0.133 ↓ 0.0 0 1

Result (cost=227.50..238.69 rows=1 width=487) (actual time=0.133..0.133 rows=0 loops=1)

2.          

Initplan (for Result)

3. 0.000 0.000 ↓ 0.0 0

Seq Scan on configuracoes (cost=0.00..1.02 rows=1 width=32) (never executed)

  • Filter: (id = '4acee0df-4acd-49f1-9859-f994714698d0'::uuid)
4. 0.000 0.000 ↓ 0.0 0

Seq Scan on configuracoes configuracoes_1 (cost=0.00..1.02 rows=1 width=32) (never executed)

  • Filter: (id = '838bf5b4-cc31-45ff-a437-69d016a13f1b'::uuid)
5. 0.007 0.132 ↓ 0.0 0 1

Sort (cost=225.45..225.46 rows=1 width=61) (actual time=0.132..0.132 rows=0 loops=1)

  • Sort Key: pontos.dt_ponto
  • Sort Method: quicksort Memory: 25kB
6. 0.000 0.125 ↓ 0.0 0 1

Nested Loop (cost=5.29..225.44 rows=1 width=61) (actual time=0.125..0.125 rows=0 loops=1)

7. 0.108 0.125 ↓ 0.0 0 1

Bitmap Heap Scan on pontos (cost=4.88..216.99 rows=1 width=41) (actual time=0.125..0.125 rows=0 loops=1)

  • Recheck Cond: (user_id = '01546725-1e25-4256-9ec1-21d5a89885ce'::uuid)
  • Filter: (situacao AND ((dt_ponto)::date = '2019-04-15'::date))
  • Rows Removed by Filter: 79
  • Heap Blocks: exact=72
8. 0.017 0.017 ↓ 1.3 79 1

Bitmap Index Scan on ind_pontos_user_user_id_dt_ponto (cost=0.00..4.88 rows=61 width=0) (actual time=0.017..0.017 rows=79 loops=1)

  • Index Cond: (user_id = '01546725-1e25-4256-9ec1-21d5a89885ce'::uuid)
9. 0.000 0.000 ↓ 0.0 0

Index Scan using ind_vw_quebradia_dt_ponto on vw_quebradia dia (cost=0.42..8.44 rows=1 width=24) (never executed)

  • Index Cond: (dt_ponto = pontos.dt_ponto)
  • Filter: (user_id = '01546725-1e25-4256-9ec1-21d5a89885ce'::uuid)
10.          

SubPlan (for Result)

11. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..1.17 rows=1 width=318) (never executed)

  • One-Time Filter: pontos.situacao
12. 0.000 0.000 ↓ 0.0 0

Seq Scan on feriados (cost=0.00..1.17 rows=1 width=318) (never executed)

  • Filter: (data = (pontos.dt_ponto)::date)
13. 0.000 0.000 ↓ 0.0 0

Result (cost=0.00..1.17 rows=1 width=1) (never executed)

  • One-Time Filter: pontos.situacao
14. 0.000 0.000 ↓ 0.0 0

Seq Scan on feriados feriados_1 (cost=0.00..1.17 rows=1 width=1) (never executed)

  • Filter: (data = (pontos.dt_ponto)::date)
Planning time : 0.590 ms