explain.depesz.com

PostgreSQL's explain analyze made readable

Result: wtA8

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 8,498.752 ↓ 0.0 0 1

Limit (cost=0.28..1.37 rows=1 width=439) (actual time=8,498.752..8,498.752 rows=0 loops=1)

2. 2,727.793 8,498.752 ↓ 0.0 0 1

Nested Loop (cost=0.28..787,808.94 rows=722,418 width=439) (actual time=8,498.752..8,498.752 rows=0 loops=1)

3. 1,108.557 1,108.557 ↓ 1.0 2,331,201 1

Seq Scan on google_events g0 (cost=0.00..87,166.39 rows=2,315,539 width=182) (actual time=0.004..1,108.557 rows=2,331,201 loops=1)

4. 4,662.402 4,662.402 ↓ 0.0 0 2,331,201

Index Scan using employees_pkey on employees e1 (cost=0.28..0.29 rows=1 width=257) (actual time=0.002..0.002 rows=0 loops=2,331,201)

  • Index Cond: (id = g0.employee_id)
  • Filter: (NOT enabled)
  • Rows Removed by Filter: 1