explain.depesz.com

PostgreSQL's explain analyze made readable

Result: LTVG

Settings
# exclusive inclusive rows x rows loops node
1. 5.266 5.422 ↑ 1.0 16,144 1

Seq Scan on opta_performances (cost=179.40..2,486.84 rows=16,144 width=12) (actual time=0.172..5.422 rows=16,144 loops=1)

2.          

Initplan (for Seq Scan)

3. 0.002 0.108 ↑ 1.0 1 1

Limit (cost=89.72..89.72 rows=1 width=4) (actual time=0.106..0.108 rows=1 loops=1)

4. 0.014 0.106 ↑ 23.0 1 1

Sort (cost=89.72..89.78 rows=23 width=4) (actual time=0.106..0.106 rows=1 loops=1)

  • Sort Key: opta_performances_1.total DESC
  • Sort Method: top-N heapsort Memory: 25kB
5. 0.072 0.092 ↓ 1.5 34 1

Bitmap Heap Scan on opta_performances opta_performances_1 (cost=4.46..89.61 rows=23 width=4) (actual time=0.029..0.092 rows=34 loops=1)

  • Recheck Cond: (player_id = 1,537)
  • Heap Blocks: exact=34
6. 0.020 0.020 ↓ 1.5 34 1

Bitmap Index Scan on player_id_idx (cost=0.00..4.46 rows=23 width=0) (actual time=0.020..0.020 rows=34 loops=1)

  • Index Cond: (player_id = 1,537)
7. 0.001 0.048 ↑ 1.0 1 1

Limit (cost=89.67..89.67 rows=1 width=4) (actual time=0.047..0.048 rows=1 loops=1)

8. 0.007 0.047 ↑ 1.0 1 1

Sort (cost=89.67..89.67 rows=1 width=4) (actual time=0.047..0.047 rows=1 loops=1)

  • Sort Key: opta_performances_2.total
  • Sort Method: top-N heapsort Memory: 25kB
9. 0.033 0.040 ↓ 32.0 32 1

Bitmap Heap Scan on opta_performances opta_performances_2 (cost=4.46..89.66 rows=1 width=4) (actual time=0.014..0.040 rows=32 loops=1)

  • Recheck Cond: (player_id = 1,537)
  • Filter: (minutes_played > 15)
  • Rows Removed by Filter: 2
  • Heap Blocks: exact=34
10. 0.007 0.007 ↓ 1.5 34 1

Bitmap Index Scan on player_id_idx (cost=0.00..4.46 rows=23 width=0) (actual time=0.007..0.007 rows=34 loops=1)

  • Index Cond: (player_id = 1,537)
Planning time : 0.329 ms
Execution time : 6.247 ms