explain.depesz.com

PostgreSQL's explain analyze made readable

Result: XMVC

Settings
# exclusive inclusive rows x rows loops node
1. 0.015 0.081 ↓ 1.4 13 1

Hash Join (cost=2.94..8.43 rows=9 width=175) (actual time=0.051..0.081 rows=13 loops=1)

  • Hash Cond: (integrations."projectId" = "Projects".id)
2. 0.040 0.040 ↓ 1.4 13 1

Seq Scan on "Integrations" integrations (cost=0.00..5.36 rows=9 width=175) (actual time=0.014..0.040 rows=13 loops=1)

  • Filter: ("isEnabled" AND (("integrationName")::text = 'Google Analytics'::text))
  • Rows Removed by Filter: 96
3. 0.008 0.026 ↑ 1.0 42 1

Hash (cost=2.42..2.42 rows=42 width=16) (actual time=0.026..0.026 rows=42 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 10kB
4. 0.018 0.018 ↑ 1.0 42 1

Seq Scan on "Projects" (cost=0.00..2.42 rows=42 width=16) (actual time=0.007..0.018 rows=42 loops=1)