explain.depesz.com

PostgreSQL's explain analyze made readable

Result: HOXk

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 4,089.784 ↓ 0.0 0 1

Unique (cost=1,244,304.54..1,244,323.74 rows=2,548 width=32) (actual time=4,089.784..4,089.784 rows=0 loops=1)

2. 0.011 4,089.783 ↓ 0.0 0 1

Sort (cost=1,244,304.54..1,244,310.94 rows=2,560 width=32) (actual time=4,089.783..4,089.783 rows=0 loops=1)

  • Sort Key: unidadenegocioid, indicadorid, data DESC
  • Sort Method: quicksort Memory: 25kB
3. 4,089.772 4,089.772 ↓ 0.0 0 1

Index Scan using cuidx_medicaoindicador_indicadorid_unidadenegocioid_data on medicaoindicador (cost=0.57..1,244,159.62 rows=2,560 width=32) (actual time=4,089.772..4,089.772 rows=0 loops=1)

  • Index Cond: (data >= (now() - '3 days'::interval))
Planning time : 0.379 ms
Execution time : 4,089.842 ms