explain.depesz.com

PostgreSQL's explain analyze made readable

Result: x8JQ

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

Nested Loop (cost=10,418.30..25,677.90 rows=1 width=8) (actual rows= loops=)

2. 0.000 0.000 ↓ 0.0

Hash Join (cost=10,417.73..25,659.81 rows=5 width=8) (actual rows= loops=)

  • Hash Cond: (class_instance_class_instance.class_instance_a = class_instance.id)
3. 0.000 0.000 ↓ 0.0

Parallel Index Scan using class_instance_class_instance_relation_id on class_instance_class_instance (cost=0.56..15,068.19 rows=66,457 width=8) (actual rows= loops=)

  • Index Cond: (relation_id = 11)
  • Filter: (project_id = 1)
4. 0.000 0.000 ↓ 0.0

Hash (cost=10,323.43..10,323.43 rows=7,499 width=4) (actual rows= loops=)

  • Buckets: 16384 (originally 8192) Batches: 1 (originally 1) Memory Usage: 599kB
5. 0.000 0.000 ↓ 0.0

Index Scan using class_instance_class_id on class_instance (cost=0.57..10,323.43 rows=7,499 width=4) (actual rows= loops=)

  • Index Cond: (class_id = 6)
6. 0.000 0.000 ↓ 0.0

Index Scan using class_instance_pkey on class_instance t4 (cost=0.57..3.62 rows=1 width=4) (actual rows= loops=)

  • Index Cond: (id = class_instance_class_instance.class_instance_b)
  • Filter: (class_id = 6)