explain.depesz.com

PostgreSQL's explain analyze made readable

Result: sUuZ

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 14,217.839 ↑ 1.0 1 1

Limit (cost=16,205.83..16,205.85 rows=1 width=32) (actual time=14,217.839..14,217.839 rows=1 loops=1)

2. 0.080 14,217.834 ↑ 1.0 1 1

Aggregate (cost=16,205.83..16,205.85 rows=1 width=32) (actual time=14,217.834..14,217.834 rows=1 loops=1)

3. 0.227 14,217.754 ↓ 27.0 27 1

Nested Loop (cost=7.03..16,205.83 rows=1 width=6) (actual time=5,773.455..14,217.754 rows=27 loops=1)

4. 0.372 8.012 ↓ 207.0 207 1

Nested Loop (cost=6.60..1,097.16 rows=1 width=16) (actual time=1.051..8.012 rows=207 loops=1)

5. 0.111 3.934 ↓ 9.9 218 1

Nested Loop (cost=6.18..1,079.99 rows=22 width=8) (actual time=0.999..3.934 rows=218 loops=1)

6. 1.759 1.759 ↓ 8.0 8 1

Seq Scan on pl_orgstruct seleareaid (cost=0.00..181.09 rows=1 width=8) (actual time=0.086..1.759 rows=8 loops=1)

  • Filter: (((codepath)::text ~~ '1.1136093585205235712.1136093585775661056.1136093587675680768.1173507685367287808.1173510519483666432.1173510527209574400.%'::text) AND (platstatus = 1))
  • Rows Removed by Filter: 3,198
7. 1.936 2.064 ↑ 8.3 27 8

Bitmap Heap Scan on kx_kq_store st (cost=6.18..896.67 rows=223 width=16) (actual time=0.023..0.258 rows=27 loops=8)

  • Recheck Cond: (seleareaid = seleareaid.orgstructid)
  • Filter: ((platstatus = 1) AND (channeltype = '895937790557163520'::bigint))
  • Rows Removed by Filter: 6
  • Heap Blocks: exact=267
8. 0.128 0.128 ↑ 7.2 34 8

Bitmap Index Scan on idx_kx_kq_store_seleareaid (cost=0.00..6.12 rows=244 width=0) (actual time=0.016..0.016 rows=34 loops=8)

  • Index Cond: (seleareaid = seleareaid.orgstructid)
9. 3.706 3.706 ↑ 1.0 1 218

Index Scan using ix_kx_kq_storerepresentative_storeid on kx_kq_storerepresentative presentative (cost=0.42..0.77 rows=1 width=8) (actual time=0.011..0.017 rows=1 loops=218)

  • Index Cond: (storeid = st.id)
  • Filter: ((platstatus = 1) AND (representativeid = '1245145777597190144'::bigint))
  • Rows Removed by Filter: 4
10. 14,209.515 14,209.515 ↓ 0.0 0 207

Index Scan using "IX_kx_order_05" on kx_order (cost=0.43..15,108.66 rows=1 width=14) (actual time=64.799..68.645 rows=0 loops=207)

  • Index Cond: (storeid = st.id)
  • Filter: ((tn_paytype <> '1105365303514238976'::bigint) AND (status <> 110) AND (ordersourceid = ANY ('{1,2}'::bigint[])) AND (platstatus = 1) AND (orgstructid = '1173510527209574400'::bigint) AND (ordertime >= ((now())::date)::timestamp without time zone))
  • Rows Removed by Filter: 25
Planning time : 7.383 ms
Execution time : 14,218.063 ms