explain.depesz.com

PostgreSQL's explain analyze made readable

Result: SQQK

Settings
# exclusive inclusive rows x rows loops node
1. 0.028 0.067 ↓ 0.0 0 1

Sort (cost=41.74..41.74 rows=1 width=1,029) (actual time=0.067..0.067 rows=0 loops=1)

  • Sort Key: tb_order.dh_creation_time DESC
  • Sort Method: quicksort Memory: 25kB
  • (dh_creation_time <= '2020-07-06 23:59:59.9999'::timestamp without time zone))
2. 0.002 0.039 ↓ 0.0 0 1

Nested Loop (cost=17.98..41.73 rows=1 width=1,029) (actual time=0.039..0.039 rows=0 loops=1)

  • Join Filter: (tb_order.id_exchange = tb_exchange.id_exchange)
3. 0.000 0.037 ↓ 0.0 0 1

Nested Loop (cost=17.98..40.69 rows=1 width=732) (actual time=0.037..0.037 rows=0 loops=1)

4. 0.000 0.037 ↓ 0.0 0 1

Nested Loop (cost=17.85..40.53 rows=1 width=516) (actual time=0.037..0.037 rows=0 loops=1)

  • -> Index Scan using tb_investor_broker_account_idx0 on tb_investor_broker_account (cost=0.42..8.44 rows=1 width=14) (neverexecuted)
5. 0.000 0.037 ↓ 0.0 0 1

Nested Loop (cost=17.43..32.08 rows=1 width=514) (actual time=0.037..0.037 rows=0 loops=1)

  • Join Filter: (tb_order.cd_order_status = tb_order_status.cd_order_status)
  • Index Cond: ((id_broker = tb_order.id_broker) AND (account_number = tb_order.account))
6. 0.001 0.037 ↓ 0.0 0 1

Nested Loop (cost=17.43..30.65 rows=1 width=381) (actual time=0.037..0.037 rows=0 loops=1)

  • Join Filter: (tb_order.cd_order_type = tb_order_type.cd_order_type)
7. 0.001 0.036 ↓ 0.0 0 1

Nested Loop (cost=17.43..29.47 rows=1 width=165) (actual time=0.036..0.036 rows=0 loops=1)

8. 0.010 0.035 ↓ 0.0 0 1

Bitmap Heap Scan on tb_order (cost=17.01..21.03 rows=1 width=155) (actual time=0.035..0.035 rows=0 loops=1)

  • Recheck Cond: ((id_investor = 51,360) AND (dh_creation_time >= '2020-06-29 00:00:00'::timestamp without time zone) AND (dh_creation_time <= '2020-07-06 23:59:59.9999'::timestamp without time zone))
9. 0.002 0.025 ↓ 0.0 0 1

BitmapAnd (cost=17.01..17.01 rows=1 width=0) (actual time=0.025..0.025 rows=0 loops=1)

10. 0.023 0.023 ↓ 0.0 0 1

Bitmap Index Scan on tb_order_idx_query_slobodan_2 (cost=0.00..4.67 rows=33 width=0) (actual time=0.023..0.023 rows=0 loops=1)

  • Index Cond: (id_investor = 51,360)
11. 0.000 0.000 ↓ 0.0 0

Bitmap Index Scan on tb_order_dh_creation_time_idx (cost=0.00..12.09 rows=366 width=0) (never executed)

  • Index Cond: ((dh_creation_time >= '2020-06-29 00:00:00'::timestamp without time zone) AND
12. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_stock_pk on tb_stock (cost=0.42..8.44 rows=1 width=18) (never executed)

  • Index Cond: (id_stock = tb_order.id_stock)
13. 0.000 0.000 ↓ 0.0 0

Seq Scan on tb_order_type (cost=0.00..1.08 rows=8 width=226) (never executed)

14. 0.000 0.000 ↓ 0.0 0

Seq Scan on tb_order_status (cost=0.00..1.19 rows=19 width=138) (never executed)

15. 0.000 0.000 ↓ 0.0 0

Index Scan using tb_investor_broker_account_type_pk on tb_investor_broker_account_type (cost=0.13..0.15 rows=1 width=220) (never executed)

  • Index Cond: (tp_account = tb_investor_broker_account.tp_account)
16. 0.000 0.000 ↓ 0.0 0

Seq Scan on tb_exchange (cost=0.00..1.01 rows=1 width=222) (never executed)

Planning time : 5.365 ms
Execution time : 0.586 ms