explain.depesz.com

PostgreSQL's explain analyze made readable

Result: fHaY

Settings
# exclusive inclusive rows x rows loops node
1. 1,612.120 2,633.792 ↑ 357.3 13 1

GroupAggregate (cost=0.43..114,722.37 rows=4,645 width=20) (actual time=0.166..2,633.792 rows=13 loops=1)

  • Group Key: display_purse
  • Filter: (count(DISTINCT user_id) > 1)
  • Rows Removed by Filter: 6
2. 1,021.672 1,021.672 ↓ 1.0 2,998,456 1

Index Scan using gamepay_purses_display_purse_idx_1909 on gamepay_purses (cost=0.43..92,764.04 rows=2,904,551 width=16) (actual time=0.085..1,021.672 rows=2,998,456 loops=1)

  • Index Cond: ((display_purse)::text = ANY ('{"Bank Negara Indonesia","Bank Transfer","Bank Central Asia",BCA,MDR,"Bank Rakyat Indonesia",0101001226426,BRI,548793...4591,546263...1335,viralvakani82@gmail.com,8408205071567,414962...4570,Wallet,"+91 8619707591",0719716240,"+91 8849548389",0729874126,ahmadrisaladiputrabocahmess@gmail.com}'::text[]))
Planning time : 1.217 ms
Execution time : 2,634.004 ms