explain.depesz.com

PostgreSQL's explain analyze made readable

Result: goZD

Settings
# exclusive inclusive rows x rows loops node
1. 0.005 0.233 ↓ 18.0 18 1

Limit (cost=1.00..30.43 rows=1 width=72) (actual time=0.078..0.233 rows=18 loops=1)

2. 0.010 0.228 ↓ 18.0 18 1

Nested Loop (cost=1.00..30.43 rows=1 width=72) (actual time=0.077..0.228 rows=18 loops=1)

3. 0.013 0.182 ↓ 18.0 18 1

Nested Loop (cost=0.71..16.77 rows=1 width=72) (actual time=0.067..0.182 rows=18 loops=1)

4. 0.133 0.133 ↓ 18.0 18 1

Index Scan using kx_kq_channelinventorydetail_index2 on kx_kq_channelinventorydetail (cost=0.43..8.46 rows=1 width=72) (actual time=0.053..0.133 rows=18 loops=1)

  • Index Cond: ((submitter = '1125224227880964096'::bigint) AND (channelid = '151438688590159390'::bigint))
  • Filter: (to_char(countdate, 'yyyy-MM-dd'::text) = to_char('2019-05-11 14:58:01'::timestamp without time zone, 'yyyy-MM-dd'::text))
  • Rows Removed by Filter: 24
5. 0.036 0.036 ↑ 1.0 1 18

Index Scan using pl_orgstruct_orgstructid on pl_orgstruct submitter (cost=0.29..8.31 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=18)

  • Index Cond: (orgstructid = '1125224227880964096'::bigint)
  • Filter: (platstatus = 1)
6. 0.036 0.036 ↑ 1.0 1 18

Index Scan using pl_orgstruct_orgstructid on pl_orgstruct saleareaid (cost=0.29..8.31 rows=1 width=8) (actual time=0.002..0.002 rows=1 loops=18)

  • Index Cond: (orgstructid = kx_kq_channelinventorydetail.saleareaid)
  • Filter: (((codepath)::text ~~ '1.1124971613406760960.1124971849512521728.1124972310210678784.1124973499241336832.1124975572078956544.%'::text) AND (platstatus = 1))