explain.depesz.com

PostgreSQL's explain analyze made readable

Result: JYtI

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 0.986 ↓ 2.0 2 1

Limit (cost=17.14..42.56 rows=1 width=8) (actual time=0.803..0.986 rows=2 loops=1)

2. 0.005 0.985 ↓ 2.0 2 1

Nested Loop (cost=17.14..42.56 rows=1 width=8) (actual time=0.802..0.985 rows=2 loops=1)

3. 0.003 0.952 ↓ 2.0 2 1

Nested Loop (cost=16.85..28.90 rows=1 width=16) (actual time=0.773..0.952 rows=2 loops=1)

4. 0.761 0.917 ↓ 2.0 2 1

Bitmap Heap Scan on kx_kq_channelinandout k (cost=16.56..20.59 rows=1 width=24) (actual time=0.743..0.917 rows=2 loops=1)

  • Recheck Cond: ((channelid = '151438688590159390'::bigint) AND (submitterid = '1125224227880964096'::bigint))
  • Filter: ((signintime >= '2019-05-11 00:00:00'::timestamp without time zone) AND (signintime <= '2019-05-11 23:59:59'::timestamp without time zone) AND (platstatus = 1))
  • Rows Removed by Filter: 78
  • Heap Blocks: exact=82
5. 0.005 0.156 ↓ 0.0 0 1

BitmapAnd (cost=16.56..16.56 rows=1 width=0) (actual time=0.156..0.156 rows=0 loops=1)

6. 0.048 0.048 ↓ 1.1 82 1

Bitmap Index Scan on kx_kq_channelinandout_channelid (cost=0.00..5.00 rows=77 width=0) (actual time=0.048..0.048 rows=82 loops=1)

  • Index Cond: (channelid = '151438688590159390'::bigint)
7. 0.103 0.103 ↓ 1.0 395 1

Bitmap Index Scan on kx_kq_channelinandout_submitterid (cost=0.00..11.31 rows=384 width=0) (actual time=0.103..0.103 rows=395 loops=1)

  • Index Cond: (submitterid = '1125224227880964096'::bigint)
8. 0.032 0.032 ↑ 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.015..0.016 rows=1 loops=2)

  • Index Cond: (orgstructid = '1125224227880964096'::bigint)
  • Filter: (platstatus = 1)
9. 0.028 0.028 ↑ 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.014..0.014 rows=1 loops=2)

  • Index Cond: (orgstructid = k.saleareaid)
  • Filter: (((codepath)::text ~~ '1.1124971613406760960.1124971849512521728.1124972310210678784.1124973499241336832.1124975572078956544.%'::text) AND (platstatus = 1))
Planning time : 1.427 ms
Execution time : 1.092 ms