explain.depesz.com

PostgreSQL's explain analyze made readable

Result: qIRG

Settings
# exclusive inclusive rows x rows loops node
1. 0.000 123,197.850 ↑ 1.0 100 1

Limit (cost=1,446,619.50..1,446,631.17 rows=100 width=45) (actual time=122,603.626..123,197.850 rows=100 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Sort Key: child_classification.id
2. 122,960.853 122,960.853 ↑ 3.8 1,000,100 1

Gather Merge (cost=1,329,944.69..1,776,211.85 rows=3,824,880 width=45) (actual time=120,168.594..122,960.853 rows=1,000,100 loops=1)

3. 362,320.242 362,320.242 ↑ 5.7 333,914 3

Sort (cost=1,328,944.67..1,333,725.77 rows=1,912,440 width=45) (actual time=120,116.679..120,773.414 rows=333,914 loops=3)

4. 334,643.031 334,643.031 ↑ 1.2 1,537,286 3

Parallel Seq Scan on child_classification (cost=0.00..1,011,747.40 rows=1,912,440 width=45) (actual time=0.012..111,547.677 rows=1,537,286 loops=3)

Planning time : 14.361 ms
Execution time : 123,209.441 ms