explain.depesz.com

PostgreSQL's explain analyze made readable

Result: ATnH

Settings
# exclusive inclusive rows x rows loops node
1. 1.690 11.978 ↓ 1.1 3,607 1

Hash Left Join (cost=522.71..1,963.08 rows=3,337 width=1,018) (actual time=3.633..11.978 rows=3,607 loops=1)

  • Hash Cond: (projectver0_.state = state2_.id)
2. 2.086 10.263 ↓ 1.1 3,607 1

Hash Join (cost=521.03..1,951.42 rows=3,337 width=867) (actual time=3.598..10.263 rows=3,607 loops=1)

  • Hash Cond: (projectver0_.project = project1_.version_meta_id)
3. 4.998 4.998 ↑ 1.0 3,791 1

Index Scan using public_projectversion_version_period_idx on projectversion projectver0_ (cost=0.78..1,378.78 rows=3,804 width=700) (actual time=0.182..4.998 rows=3,791 loops=1)

  • Index Cond: ((get_versioning_scope_date() >= version_actual_period_start) AND (get_versioning_scope_date() <= version_actual_period_end))
  • Filter: (NOT version_is_deleted)
4. 0.543 3.179 ↓ 1.1 3,607 1

Hash (cost=477.49..477.49 rows=3,421 width=167) (actual time=3.179..3.179 rows=3,607 loops=1)

  • Buckets: 4096 Batches: 1 Memory Usage: 599kB
5. 2.636 2.636 ↓ 1.1 3,607 1

Index Scan using public_project_version_period_idx on project project1_ (cost=0.78..477.49 rows=3,421 width=167) (actual time=0.248..2.636 rows=3,607 loops=1)

  • Index Cond: ((get_versioning_scope_date() >= version_actual_period_start) AND (get_versioning_scope_date() <= version_actual_period_end))
  • Filter: ((NOT version_is_deleted) AND showhideproject AND (kind = 30))
  • Rows Removed by Filter: 293
6. 0.014 0.025 ↑ 1.0 30 1

Hash (cost=1.30..1.30 rows=30 width=151) (actual time=0.025..0.025 rows=30 loops=1)

  • Buckets: 1024 Batches: 1 Memory Usage: 14kB
7. 0.011 0.011 ↑ 1.0 30 1

Seq Scan on b4_state state2_ (cost=0.00..1.30 rows=30 width=151) (actual time=0.008..0.011 rows=30 loops=1)

Planning time : 1.551 ms
Execution time : 12.199 ms