explain.depesz.com

PostgreSQL's explain analyze made readable

Result: 34HK

Settings
# exclusive inclusive rows x rows loops node
1. 2.724 488.384 ↑ 22.7 6 1

Nested Loop (cost=2.37..82,922.71 rows=136 width=729) (actual time=201.923..488.384 rows=6 loops=1)

2. 5.137 373.570 ↓ 2.7 11,209 1

Hash Join (cost=1.94..60,101.94 rows=4,197 width=45) (actual time=0.227..373.570 rows=11,209 loops=1)

  • Hash Cond: (promoaccou0_.game_id = gamescaleg3_.id)
3. 368.398 368.398 ↑ 1.0 11,326 1

Seq Scan on promo_acccount promoaccou0_ (cost=0.00..60,013.55 rows=11,862 width=45) (actual time=0.185..368.398 rows=11,326 loops=1)

  • Filter: (balance > 0)
  • Rows Removed by Filter: 2475598
4. 0.006 0.035 ↓ 1.0 24 1

Hash (cost=1.65..1.65 rows=23 width=8) (actual time=0.035..0.035 rows=24 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 9kB
5. 0.029 0.029 ↓ 1.0 24 1

Seq Scan on fugaso_game gamescaleg3_ (cost=0.00..1.65 rows=23 width=8) (actual time=0.018..0.029 rows=24 loops=1)

  • Filter: promo
  • Rows Removed by Filter: 42
6. 112.090 112.090 ↓ 0.0 0 11,209

Index Scan using user_user_pkey on user_user user1_ (cost=0.43..5.43 rows=1 width=684) (actual time=0.010..0.010 rows=0 loops=11,209)

  • Index Cond: (id = promoaccou0_.user_id)
  • Filter: (operator_id = ANY ('{31550,30050,30052,32350,31650,2001,30150,30450,31250,30053,30100,30054,32802,32700,1700,30350}'::bigint[]))
  • Rows Removed by Filter: 1
Planning time : 0.660 ms
Execution time : 488.432 ms