explain.depesz.com

PostgreSQL's explain analyze made readable

Result: s9V8 : Nested_Loop

Settings
# exclusive inclusive rows x rows loops node
1. 0.007 0.109 ↓ 0.0 0 1

Nested Loop Anti Join (cost=10.59..40.81 rows=1 width=42) (actual time=0.108..0.109 rows=0 loops=1)

2. 0.004 0.102 ↓ 0.0 0 1

Nested Loop (cost=10.02..37.46 rows=1 width=50) (actual time=0.100..0.102 rows=0 loops=1)

3. 0.003 0.098 ↓ 0.0 0 1

Nested Loop (cost=9.45..28.87 rows=1 width=42) (actual time=0.097..0.098 rows=0 loops=1)

4. 0.003 0.095 ↓ 0.0 0 1

Nested Loop (cost=9.03..20.93 rows=1 width=48) (actual time=0.093..0.095 rows=0 loops=1)

5. 0.027 0.092 ↓ 0.0 0 1

Hash Join (cost=8.61..12.49 rows=1 width=38) (actual time=0.090..0.092 rows=0 loops=1)

  • Hash Cond: (r.routeid = o.routeid)
6. 0.016 0.016 ↑ 63.0 1 1

Seq Scan on routes r (cost=0.00..3.63 rows=63 width=23) (actual time=0.014..0.016 rows=1 loops=1)

7. 0.006 0.049 ↓ 0.0 0 1

Hash (cost=8.60..8.60 rows=1 width=29) (actual time=0.047..0.049 rows=0 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 8kB
8. 0.043 0.043 ↓ 0.0 0 1

Index Scan using i_orders_createdat on orders o (cost=0.57..8.60 rows=1 width=29) (actual time=0.042..0.043 rows=0 loops=1)

  • Index Cond: ((createdat >= (CURRENT_TIMESTAMP - '00:05:00'::interval)) AND (createdat <= CURRENT_TIMESTAMP))
  • Filter: ((routeid = ANY ('{2438378,2438377}'::numeric[])) AND (orderstatus <> '40'::numeric))
9. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_account on account a (cost=0.42..8.44 rows=1 width=22) (never executed)

  • Index Cond: (accountid = o.accountid)
10. 0.000 0.000 ↓ 0.0 0

Index Scan using pk_person on person p (cost=0.42..7.94 rows=1 width=6) (never executed)

  • Index Cond: (userid = a.userid)
  • Filter: (groupid = ANY ('{2429510,2430624}'::numeric[]))
11. 0.000 0.000 ↓ 0.0 0

Index Scan using extorders_orderid_idx on extorders exto (cost=0.57..8.59 rows=1 width=8) (never executed)

  • Index Cond: (orderid = o.orderid)
  • Filter: ((extparams IS NULL) AND (NOT isremoved) AND (orderstatus <> '3'::numeric))
12. 0.000 0.000 ↓ 0.0 0

Index Only Scan using tdades2order_fk on trades t (cost=0.57..99.34 rows=106 width=8) (never executed)

  • Index Cond: (orderid = o.orderid)
  • Heap Fetches: 0
Planning time : 14.847 ms
Execution time : 0.266 ms