explain.depesz.com

PostgreSQL's explain analyze made readable

Result: UVHF

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 671.640 ↑ 1.7 3,796 1

Gather (cost=19,167.55..29,973.65 rows=6,550 width=153) (actual time=448.544..671.640 rows=3,796 loops=1)

2. 654.742 654.742 ↑ 2.2 1,265 3

Nested Loop (cost=18,167.55..28,318.65 rows=2,729 width=153) (actual time=511.174..654.742 rows=1,265 loops=3)

3. 631.400 631.400 ↑ 2.2 1,265 3

Hash Join (cost=18,167.12..25,824.10 rows=2,733 width=74) (actual time=511.128..631.400 rows=1,265 loops=3)

4. 118.715 118.715 ↑ 1.3 22,356 3

Parallel Seq Scan on m_cmd_class cla (cost=0.00..7,522.98 rows=28,444 width=33) (actual time=0.051..118.715 rows=22,356 loops=3)

5. 495.854 495.854 ↓ 1.0 28,163 3

Hash (cost=17,823.24..17,823.24 rows=27,511 width=41) (actual time=495.854..495.854 rows=28,163 loops=3)

6. 448.614 448.614 ↓ 1.0 28,163 3

Seq Scan on m_cmd_exp exp (cost=0.00..17,823.24 rows=27,511 width=41) (actual time=0.018..448.614 rows=28,163 loops=3)

7. 0.011 0.011 ↑ 1.0 1 3,796

Index Scan using pk_m_cmd on m_cmd cmd (cost=0.42..0.90 rows=1 width=105) (actual time=0.011..0.011 rows=1 loops=3,796)

Planning time : 0.990 ms
Execution time : 681.453 ms