explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CUfL

Settings
# exclusive inclusive rows x rows loops node
1. 0.001 2.807 ↑ 1.0 1 1

Limit (cost=8.46..216.67 rows=1 width=37) (actual time=0.036..2.807 rows=1 loops=1)

2. 0.149 2.806 ↑ 1.0 1 1

Nested Loop (cost=8.46..216.67 rows=1 width=37) (actual time=0.035..2.806 rows=1 loops=1)

3. 0.369 0.683 ↓ 141.0 987 1

Hash Join (cost=8.18..206.44 rows=7 width=4) (actual time=0.027..0.683 rows=987 loops=1)

  • Hash Cond: (idc_mm_common_team.company_id = idc_mm_common_company.id)
4. 0.302 0.302 ↓ 1.0 2,947 1

Seq Scan on idc_mm_common_team (cost=0.00..190.45 rows=2,945 width=8) (actual time=0.005..0.302 rows=2,947 loops=1)

5. 0.003 0.012 ↑ 1.0 1 1

Hash (cost=8.17..8.17 rows=1 width=4) (actual time=0.012..0.012 rows=1 loops=1)

  • Buckets: 1,024 Batches: 1 Memory Usage: 9kB
6. 0.009 0.009 ↑ 1.0 1 1

Index Scan using idc_mm_common_company_idc_company_id_881ce057_like on idc_mm_common_company (cost=0.15..8.17 rows=1 width=4) (actual time=0.008..0.009 rows=1 loops=1)

  • Index Cond: ((idc_company_id)::text = 'idc_one_company'::text)
7. 1.974 1.974 ↓ 0.0 0 987

Index Scan using idc_mm_common_employee_team_id_0dc08e52 on idc_mm_common_employee (cost=0.29..1.45 rows=1 width=37) (actual time=0.002..0.002 rows=0 loops=987)

  • Index Cond: (team_id = idc_mm_common_team.id)
  • Filter: ((idc_employee_id)::text = 'hardly_mildly_epic_imp'::text)
  • Rows Removed by Filter: 3
Planning time : 0.487 ms
Execution time : 2.835 ms