explain.depesz.com

PostgreSQL's explain analyze made readable

Result: lTqi

Settings

Optimization(s) for this plan:

# exclusive inclusive rows x rows loops node
1. 0.001 0.057 ↑ 1.0 1 1

Limit (cost=4.74..4.74 rows=1 width=573) (actual time=0.057..0.057 rows=1 loops=1)

2. 0.005 0.056 ↑ 2.0 1 1

Sort (cost=4.74..4.74 rows=2 width=573) (actual time=0.056..0.056 rows=1 loops=1)

  • Sort Key: keytime.samplecount
  • Sort Method: quicksort Memory: 25kB
3. 0.004 0.051 ↑ 1.0 2 1

Unique (cost=4.69..4.73 rows=2 width=573) (actual time=0.047..0.051 rows=2 loops=1)

4. 0.010 0.047 ↑ 1.0 2 1

Sort (cost=4.69..4.70 rows=2 width=573) (actual time=0.046..0.047 rows=2 loops=1)

  • Sort Key: keytime.id, keytime.datetimecode, keytime.fixed, keytime.hint, keytime.samplecount, keytime.samplecount
  • Sort Method: quicksort Memory: 25kB
5. 0.001 0.037 ↑ 1.0 2 1

Append (cost=0.29..4.68 rows=2 width=573) (actual time=0.026..0.037 rows=2 loops=1)

6. 0.001 0.025 ↑ 1.0 1 1

Limit (cost=0.29..3.96 rows=1 width=183) (actual time=0.025..0.025 rows=1 loops=1)

7. 0.024 0.024 ↑ 22.0 1 1

Index Scan using keytime_fixed_samplecount_index on keytime (cost=0.29..81.20 rows=22 width=183) (actual time=0.024..0.024 rows=1 loops=1)

  • Index Cond: ((fixed = true) AND (samplecount > '1434592503900000'::bigint))
  • Filter: fixed
8. 0.001 0.011 ↑ 1.0 1 1

Limit (cost=0.29..0.69 rows=1 width=183) (actual time=0.010..0.011 rows=1 loops=1)

9. 0.010 0.010 ↑ 2,517.0 1 1

Index Scan using keytime_fixed_samplecount_index on keytime keytime_1 (cost=0.29..1,016.28 rows=2,517 width=183) (actual time=0.010..0.010 rows=1 loops=1)

  • Index Cond: ((fixed = false) AND (samplecount > 0))
  • Filter: (NOT fixed)
Planning time : 0.784 ms
Execution time : 0.335 ms