explain.depesz.com

PostgreSQL's explain analyze made readable

Result: TCOV

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 0.035 ↓ 0.0 0 1

Nested Loop (cost=1.27..81.83 rows=1 width=133) (actual time=0.035..0.035 rows=0 loops=1)

2. 0.000 0.035 ↓ 0.0 0 1

Nested Loop (cost=0.98..73.53 rows=1 width=62) (actual time=0.035..0.035 rows=0 loops=1)

3. 0.001 0.035 ↓ 0.0 0 1

Nested Loop (cost=0.70..72.93 rows=1 width=4) (actual time=0.035..0.035 rows=0 loops=1)

4. 0.019 0.019 ↑ 1.2 5 1

Index Scan using slr_employee_candidate_id on slr_employee (cost=0.42..27.08 rows=6 width=4) (actual time=0.014..0.019 rows=5 loops=1)

  • Index Cond: (candidate_id = 146,561)
5. 0.015 0.015 ↓ 0.0 0 5

Index Scan using card_accounts_bankcard_employees_employee_id on card_accounts_bankcard_employees (cost=0.28..7.63 rows=1 width=8) (actual time=0.003..0.003 rows=0 loops=5)

  • Index Cond: (employee_id = slr_employee.id)
6. 0.000 0.000 ↓ 0.0 0

Index Scan using card_accounts_bankcard_pkey on card_accounts_bankcard (cost=0.28..0.44 rows=1 width=62) (never executed)

  • Index Cond: (id = card_accounts_bankcard_employees.bankcard_id)
  • Filter: (((date_end IS NULL) OR (date_end >= '2020-04-01'::date)) AND (date_begin <= '2020-04-01'::date) AND (ent_id = 1,478))
7. 0.000 0.000 ↓ 0.0 0

Index Scan using slr_card_accounts_pkey on slr_card_accounts (cost=0.29..8.31 rows=1 width=71) (never executed)

  • Index Cond: (id = card_accounts_bankcard.card_account_id)