explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x2t

Settings
# exclusive inclusive rows x rows loops node
1. 0.002 0.295 ↓ 2.0 2 1

Limit (cost=1.00..30.43 rows=1 width=548) (actual time=0.225..0.295 rows=2 loops=1)

2. 0.003 0.293 ↓ 2.0 2 1

Nested Loop (cost=1.00..30.43 rows=1 width=548) (actual time=0.224..0.293 rows=2 loops=1)

3. 0.003 0.280 ↓ 2.0 2 1

Nested Loop (cost=0.71..16.77 rows=1 width=556) (actual time=0.215..0.280 rows=2 loops=1)

4. 0.263 0.263 ↓ 2.0 2 1

Index Scan using kx_kq_channelinandout_index1 on kx_kq_channelinandout k (cost=0.43..8.45 rows=1 width=564) (actual time=0.202..0.263 rows=2 loops=1)

  • Index Cond: ((channelid = '151438688590159390'::bigint) AND (submitterid = '1125224227880964096'::bigint))
  • Filter: ((signouttime >= '2019-05-11 00:00:00'::timestamp without time zone) AND (signouttime <= '2019-05-11 23:59:59'::timestamp without time zone))
  • Rows Removed by Filter: 78
5. 0.014 0.014 ↑ 1.0 1 2

Index Scan using pl_orgstruct_orgstructid on pl_orgstruct submitterid (cost=0.29..8.31 rows=1 width=8) (actual time=0.007..0.007 rows=1 loops=2)

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

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

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