explain.depesz.com

PostgreSQL's explain analyze made readable

Result: bYBT

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 56.981 ↑ 1.0 1 1

Aggregate (cost=12,898.39..12,898.40 rows=1 width=8) (actual time=56.980..56.981 rows=1 loops=1)

2. 56.880 56.880 ↓ 0.0 0 1

Nested Loop (cost=8.00..12,898.38 rows=1 width=8) (actual time=56.879..56.880 rows=0 loops=1)

3. 47.499 47.499 ↓ 8.7 340 1

Nested Loop (cost=7.56..12,594.39 rows=39 width=16) (actual time=0.671..47.499 rows=340 loops=1)

4. 24.867 24.867 ↑ 4.3 886 1

Nested Loop (cost=7.12..1,967.20 rows=3,844 width=16) (actual time=0.412..24.867 rows=886 loops=1)

5. 8.636 8.636 ↓ 2.1 886 1

Bitmap Heap Scan on evs (cost=6.70..606.58 rows=423 width=15) (actual time=0.358..8.636 rows=886 loops=1)

6. 0.260 0.260 ↓ 2.2 911 1

Bitmap Index Scan on evs_company_id_idx (cost=0.00..6.59 rows=423 width=0) (actual time=0.260..0.260 rows=911 loops=1)

7. 15.948 15.948 ↑ 1.0 1 886

Index Scan using comm_comm_ev_id_uidx on comm c_0 (cost=0.42..3.22 rows=1 width=16) (actual time=0.018..0.018 rows=1 loops=886)

8. 22.150 22.150 ↓ 0.0 0 886

Index Scan using idx_comm_flds1 on comm_flds cf_0 (cost=0.44..2.75 rows=1 width=16) (actual time=0.024..0.025 rows=0 loops=886)

9. 9.180 9.180 ↓ 0.0 0 340

Index Scan using idx_comm_values1 on comm_values cv_0 (cost=0.44..7.78 rows=1 width=8) (actual time=0.027..0.027 rows=0 loops=340)