explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8TTD

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

Unique (cost=30.73..30.74 rows=1 width=20) (actual time=0.048..0.049 rows=1 loops=1)

2. 0.006 0.048 ↑ 1.0 1 1

Sort (cost=30.73..30.74 rows=1 width=20) (actual time=0.048..0.048 rows=1 loops=1)

  • Sort Key: api_timeslice.start_datetime, api_testruntimeslice.id, api_testruntimeslice.time_slice_id
  • Sort Method: quicksort Memory: 25kB
3. 0.002 0.042 ↑ 1.0 1 1

Nested Loop (cost=15.06..30.72 rows=1 width=20) (actual time=0.041..0.042 rows=1 loops=1)

4. 0.014 0.034 ↑ 1.0 1 1

Hash Join (cost=14.91..26.95 rows=1 width=12) (actual time=0.033..0.034 rows=1 loops=1)

  • Hash Cond: (api_timeslicescenario.test_run_time_slice_id = api_testruntimeslice.id)
5. 0.008 0.008 ↑ 90.0 1 1

Seq Scan on api_timeslicescenario (cost=0.00..10.90 rows=90 width=4) (actual time=0.008..0.008 rows=1 loops=1)

  • Filter: (id IS NOT NULL)
6. 0.004 0.012 ↑ 10.0 1 1

Hash (cost=14.79..14.79 rows=10 width=12) (actual time=0.012..0.012 rows=1 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
7. 0.003 0.008 ↑ 10.0 1 1

Bitmap Heap Scan on api_testruntimeslice (cost=4.23..14.79 rows=10 width=12) (actual time=0.007..0.008 rows=1 loops=1)

  • Recheck Cond: (test_run_id = 1)
  • Heap Blocks: exact=1
8. 0.005 0.005 ↑ 10.0 1 1

Bitmap Index Scan on api_testruntimeslice_test_run_id_19cdd265 (cost=0.00..4.23 rows=10 width=0) (actual time=0.005..0.005 rows=1 loops=1)

  • Index Cond: (test_run_id = 1)
9. 0.006 0.006 ↑ 1.0 1 1

Index Scan using api_timeslice_pkey on api_timeslice (cost=0.15..3.77 rows=1 width=12) (actual time=0.006..0.006 rows=1 loops=1)

  • Index Cond: (id = api_testruntimeslice.time_slice_id)