explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Oqem : asd

Settings
# exclusive inclusive rows x rows loops node
1. 0.655 4,137.831 ↓ 0.0 0 1

Nested Loop (cost=0.72..461,914.20 rows=1 width=5) (actual time=4,137.831..4,137.831 rows=0 loops=1)

  • Join Filter: (((a1.agent_id = 7,203) AND a2.is_reported) OR ((a2.agent_id = 7,203) AND a1.is_reported))
  • Rows Removed by Join Filter: 135
2. 12.409 4,135.688 ↓ 2.9 186 1

Nested Loop (cost=0.44..461,856.83 rows=65 width=14) (actual time=102.675..4,135.688 rows=186 loops=1)

3. 11.154 11.154 ↓ 1.0 8,375 1

Seq Scan on agents a2 (cost=0.00..773.92 rows=8,261 width=9) (actual time=0.018..11.154 rows=8,375 loops=1)

  • Filter: (is_reported OR (agent_id = 7,203))
  • Rows Removed by Filter: 940
4. 4,112.125 4,112.125 ↓ 0.0 0 8,375

Index Scan using ix_agent_transactions_wallet_id on agent_transactions atx (cost=0.44..55.80 rows=1 width=13) (actual time=0.481..0.491 rows=0 loops=8,375)

  • Index Cond: (wallet_id = a2.float_wallet_id)
  • Filter: ((when_disposed >= '2020-08-01 00:00:00'::timestamp without time zone) AND (when_disposed < '2020-08-02 00:00:00'::timestamp without time zone) AND ((state)::text = 'SUCCESS'::text) AND (type = 'REBALANCE'::text))
  • Rows Removed by Filter: 36
5. 1.488 1.488 ↑ 1.0 1 186

Index Scan using agents_pkey on agents a1 (cost=0.29..0.87 rows=1 width=5) (actual time=0.008..0.008 rows=1 loops=186)

  • Index Cond: (agent_id = atx.agent_id)
  • Filter: ((agent_id = 7,203) OR is_reported)
  • Rows Removed by Filter: 0
Planning time : 3.746 ms
Execution time : 4,138.137 ms