explain.depesz.com

PostgreSQL's explain analyze made readable

Result: aOUg

Settings
# exclusive inclusive rows x rows loops node
1. 0.006 173.479 ↓ 18.0 18 1

Limit (cost=1,000.58..89,938.48 rows=1 width=72) (actual time=2.962..173.479 rows=18 loops=1)

2. 0.013 173.473 ↓ 18.0 18 1

Nested Loop (cost=1,000.58..89,938.48 rows=1 width=72) (actual time=2.961..173.473 rows=18 loops=1)

3. 0.000 173.424 ↓ 18.0 18 1

Nested Loop (cost=1,000.29..89,924.82 rows=1 width=72) (actual time=2.944..173.424 rows=18 loops=1)

4. 12.340 182.799 ↓ 18.0 18 1

Gather (cost=1,000.00..89,916.51 rows=1 width=72) (actual time=2.922..182.799 rows=18 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 170.459 170.459 ↓ 6.0 6 3

Parallel Seq Scan on kx_kq_channelinventorydetail (cost=0.00..88,916.41 rows=1 width=72) (actual time=113.673..170.459 rows=6 loops=3)

  • Filter: ((submitter = '1125224227880964096'::bigint) AND (platstatus = 1) AND (channelid = '151438688590159390'::bigint) AND (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: 560003
6. 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)
7. 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))