explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 47Ty

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 25.907 ↓ 3.0 3 1

Unique (cost=17,030.21..17,030.22 rows=1 width=4) (actual time=25.901..25.907 rows=3 loops=1)

2. 0.000 25.900 ↓ 4.0 4 1

Sort (cost=17,030.21..17,030.22 rows=1 width=4) (actual time=25.899..25.900 rows=4 loops=1)

  • Sort Key: m.id
  • Sort Method: quicksort Memory: 25kB
3. 15.666 27.823 ↓ 4.0 4 1

Gather (cost=5,051.05..17,030.20 rows=1 width=4) (actual time=4.528..27.823 rows=4 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
4. 0.028 12.157 ↑ 1.0 1 3 / 3

Nested Loop (cost=4,051.05..16,030.10 rows=1 width=4) (actual time=5.088..12.157 rows=1 loops=3)

5. 12.051 12.051 ↓ 3.0 3 3 / 3

Parallel Seq Scan on movements m (cost=0.00..11,975.01 rows=1 width=30) (actual time=5.019..12.051 rows=3 loops=3)

6. 0.036 0.078 ↓ 0.0 0 9 / 3

Bitmap Heap Scan on movements m1 (cost=4,051.05..4,055.08 rows=1 width=30) (actual time=0.026..0.026 rows=0 loops=9)

  • Recheck Cond: (m.creationdate < creationdate)
  • Filter: ((id IS NOT NULL) AND (m.id <> id) AND ((m.tourid)::text = (tourid)::text) AND (m.sequence = sequence) AND (m.validitystart = validitystart) AND (m.validityend = validityend))
  • Rows Removed by Filter: 3
  • Heap Blocks: exact=13
7. 0.042 0.042 ↓ 3.0 3 9 / 3

Bitmap Index Scan on movement_creationdate_idx (cost=0.00..4,051.05 rows=1 width=0) (actual time=0.014..0.014 rows=3 loops=9)

  • Index Cond: (creationdate > m.creationdate)
Planning time : 0.458 ms
Execution time : 27.916 ms