explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 8DLV

Settings
# exclusive inclusive rows x rows loops node
1. 0.004 0.285 ↑ 3.0 3 1

Unique (cost=101.15..101.20 rows=9 width=4) (actual time=0.281..0.285 rows=3 loops=1)

2. 0.018 0.281 ↑ 2.8 4 1

Sort (cost=101.15..101.18 rows=11 width=4) (actual time=0.280..0.281 rows=4 loops=1)

  • Sort Key: m.id
  • Sort Method: quicksort Memory: 25kB
3. 0.022 0.263 ↑ 2.8 4 1

Nested Loop (cost=10.55..100.96 rows=11 width=4) (actual time=0.135..0.263 rows=4 loops=1)

4. 0.028 0.061 ↑ 1.0 9 1

Bitmap Heap Scan on movements m1 (cost=8.20..43.55 rows=9 width=30) (actual time=0.053..0.061 rows=9 loops=1)

  • Recheck Cond: (id IS NOT NULL)
  • Heap Blocks: exact=3
5. 0.033 0.033 ↑ 1.0 9 1

Bitmap Index Scan on movements_id_idx (cost=0.00..8.20 rows=9 width=0) (actual time=0.033..0.033 rows=9 loops=1)

  • Index Cond: (id IS NOT NULL)
6. 0.090 0.180 ↓ 0.0 0 9

Bitmap Heap Scan on movements m (cost=2.34..6.37 rows=1 width=30) (actual time=0.019..0.020 rows=0 loops=9)

  • Recheck Cond: ((validityend = m1.validityend) AND (validitystart = m1.validitystart))
  • Filter: ((id <> m1.id) AND (creationdate < m1.creationdate) AND ((m1.tourid)::text = (tourid)::text) AND (m1.sequence = sequence))
  • Rows Removed by Filter: 3
  • Heap Blocks: exact=15
7. 0.018 0.090 ↓ 0.0 0 9

BitmapAnd (cost=2.34..2.34 rows=1 width=0) (actual time=0.010..0.010 rows=0 loops=9)

8. 0.045 0.045 ↓ 3.0 9 9

Bitmap Index Scan on movements_validityend_idx (cost=0.00..1.05 rows=3 width=0) (actual time=0.005..0.005 rows=9 loops=9)

  • Index Cond: (validityend = m1.validityend)
9. 0.027 0.027 ↑ 1.0 3 9

Bitmap Index Scan on movements_validitystart_idx (cost=0.00..1.05 rows=3 width=0) (actual time=0.003..0.003 rows=3 loops=9)

  • Index Cond: (validitystart = m1.validitystart)