explain.depesz.com

PostgreSQL's explain analyze made readable

Result: BT1X

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

Unique (cost=1,874.21..1,874.22 rows=1 width=4) (actual time=101.385..101.385 rows=0 loops=1)

2. 0.062 101.385 ↓ 0.0 0 1

Sort (cost=1,874.21..1,874.21 rows=1 width=4) (actual time=101.384..101.385 rows=0 loops=1)

  • Sort Key: slr_in_out_charges.id
  • Sort Method: quicksort Memory: 25kB
3. 21.840 101.323 ↓ 0.0 0 1

Nested Loop Semi Join (cost=2.13..1,874.20 rows=1 width=4) (actual time=101.323..101.323 rows=0 loops=1)

  • Join Filter: (slr_united_dict.id = u0.id)
4. 29.324 79.483 ↓ 32,519.0 97,557 1

Nested Loop (cost=1.70..1,863.52 rows=3 width=8) (actual time=0.252..79.483 rows=97,557 loops=1)

  • Join Filter: (slr_in_out_charges.dict_root_id = slr_united_dict.dict_root_id)
5. 0.089 0.794 ↓ 45.0 45 1

Nested Loop (cost=1.28..1,861.29 rows=1 width=12) (actual time=0.176..0.794 rows=45 loops=1)

6. 0.014 0.255 ↓ 45.0 45 1

Nested Loop (cost=0.86..1,857.66 rows=1 width=8) (actual time=0.113..0.255 rows=45 loops=1)

7. 0.060 0.060 ↑ 1.0 1 1

Index Scan using slr_employee_worker_id on slr_employee (cost=0.42..8.44 rows=1 width=4) (actual time=0.059..0.060 rows=1 loops=1)

  • Index Cond: (worker_id = 173092)
8. 0.181 0.181 ↓ 45.0 45 1

Index Scan using slr_in_out_charges_employee_id on slr_in_out_charges (cost=0.44..1,849.21 rows=1 width=12) (actual time=0.050..0.181 rows=45 loops=1)

  • Index Cond: (employee_id = slr_employee.id)
  • Filter: ((NOT no_show_charge) AND (NOT is_death_charge) AND (period_date >= '2018-02-01'::date) AND (period_date <= '2019-01-31'::date) AND (ent_id = 5740))
  • Rows Removed by Filter: 22
9. 0.450 0.450 ↑ 1.0 1 45

Index Only Scan using slr_dict_root_pkey on slr_dict_root (cost=0.42..3.62 rows=1 width=4) (actual time=0.009..0.010 rows=1 loops=45)

  • Index Cond: (id = slr_in_out_charges.dict_root_id)
  • Heap Fetches: 45
10. 49.365 49.365 ↓ 42.5 2,168 45

Index Scan using slr_united_dict_dict_root_id on slr_united_dict (cost=0.42..1.59 rows=51 width=8) (actual time=0.013..1.097 rows=2,168 loops=45)

  • Index Cond: (dict_root_id = slr_dict_root.id)
11. 0.000 0.000 ↓ 0.0 0 97,557

Materialize (cost=0.42..10.64 rows=1 width=8) (actual time=0.000..0.000 rows=0 loops=97,557)

12. 0.002 0.037 ↓ 0.0 0 1

Nested Loop (cost=0.42..10.63 rows=1 width=8) (actual time=0.037..0.037 rows=0 loops=1)

13. 0.035 0.035 ↓ 0.0 0 1

Seq Scan on slr_enterprise_proportion_pay_types u1 (cost=0.00..2.17 rows=1 width=4) (actual time=0.035..0.035 rows=0 loops=1)

  • Filter: (exrtafieldsforenterprise_id = 5165)
  • Rows Removed by Filter: 94
14. 0.000 0.000 ↓ 0.0 0

Index Scan using slr_united_dict_pkey on slr_united_dict u0 (cost=0.42..8.45 rows=1 width=4) (never executed)

  • Index Cond: (id = u1.uniteddict_id)
  • Filter: (ent_id = 5740) |