explain.depesz.com

PostgreSQL's explain analyze made readable

Result: c5vu

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 2.824 ↓ 0.0 0 1

Limit (cost=0.29..402.15 rows=1 width=16) (actual time=2.824..2.824 rows=0 loops=1)

2. 0.001 2.823 ↓ 0.0 0 1

Nested Loop (cost=0.29..402.15 rows=1 width=16) (actual time=2.823..2.823 rows=0 loops=1)

3. 2.822 2.822 ↓ 0.0 0 1

Seq Scan on net_ent_game_round_detail netentgame0_ (cost=0.00..394.45 rows=3 width=32) (actual time=2.822..2.822 rows=0 loops=1)

  • Filter: ((net_ent_session_id)::text = 'cd302d3a-8369-4714-a757-0a9ca1a03efd'::text)
  • Rows Removed by Filter: 10596
4. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_game_round on game_round gameround1_ (cost=0.29..2.51 rows=1 width=16) (never executed)

  • Index Cond: (id = netentgame0_.game_round_id)
  • Filter: (game_id = '03b20329-fb0c-d871-8779-0a9854c12bf0'::uuid)
Planning time : 0.333 ms
Execution time : 2.863 ms