explain.depesz.com

PostgreSQL's explain analyze made readable

Result: Eqgk

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 225.116 ↓ 0.0 0 1

Limit (cost=1,000.58..102,871.47 rows=1 width=16) (actual time=225.116..225.116 rows=0 loops=1)

2. 0.001 225.115 ↓ 0.0 0 1

Nested Loop (cost=1,000.58..102,871.47 rows=1 width=16) (actual time=225.115..225.115 rows=0 loops=1)

3. 0.000 225.114 ↓ 0.0 0 1

Nested Loop (cost=1,000.29..102,857.81 rows=1 width=24) (actual time=225.114..225.114 rows=0 loops=1)

4. 13.456 235.814 ↓ 0.0 0 1

Gather (cost=1,000.00..102,849.49 rows=1 width=32) (actual time=225.112..235.814 rows=0 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
5. 222.358 222.358 ↓ 0.0 0 3

Parallel Seq Scan on kx_kq_channelinandout k (cost=0.00..101,849.39 rows=1 width=32) (actual time=222.357..222.358 rows=0 loops=3)

  • Filter: ((signintime >= '2019-05-10 00:00:00'::timestamp without time zone) AND (signintime <= '2019-05-10 23:59:59'::timestamp without time zone) AND (submitterid = '1121298468523085824'::bigint) AND (platstatus = 1) AND (channelid = '1121300631571796070'::bigint))
  • Rows Removed by Filter: 520000
6. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_pl_orgstruct_orgstructid on pl_orgstruct submitterid (cost=0.29..8.31 rows=1 width=8) (never executed)

  • Index Cond: (orgstructid = '1121298468523085824'::bigint)
  • Filter: (platstatus = 1)
7. 0.000 0.000 ↓ 0.0 0

Index Scan using ix_pl_orgstruct_orgstructid on pl_orgstruct saleareaid (cost=0.29..8.31 rows=1 width=8) (never executed)

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