explain.depesz.com

PostgreSQL's explain analyze made readable

Result: AgRS

Settings
# exclusive inclusive rows x rows loops node
1. 1,278.522 145,109.174 ↑ 1.0 501 1

Limit (cost=857,439.89..857,499.88 rows=501 width=765) (actual time=145,108.661..145,109.174 rows=501 loops=1)

  • Functions: 151
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 53.154 ms, Inlining 214.846 ms, Optimization 4648.061 ms, Emission 2558.230 ms, Total 7474.291 ms
2. 160.549 143,830.652 ↑ 772.5 501 1

Gather Merge (cost=857,439.89..903,781.51 rows=387,036 width=765) (actual time=143,735.107..143,830.652 rows=501 loops=1)

  • Workers Planned: 4
  • Workers Launched: 4
3. 154.311 143,670.103 ↑ 556.1 174 5 / 5

Sort (cost=856,439.84..856,681.73 rows=96,759 width=765) (actual time=143,670.072..143,670.103 rows=174 loops=5)

  • Sort Key: t_10.date_stop
  • Sort Method: top-N heapsort Memory: 532kB
  • Worker 0: Sort Method: top-N heapsort Memory: 541kB
  • Worker 1: Sort Method: top-N heapsort Memory: 533kB
  • Worker 2: Sort Method: top-N heapsort Memory: 530kB
  • Worker 3: Sort Method: top-N heapsort Memory: 531kB
4. 16.089 143,515.792 ↑ 1.3 77,065 5 / 5

Parallel Append (cost=0.00..851,617.04 rows=96,759 width=765) (actual time=1,218.278..143,515.792 rows=77,065 loops=5)

5. 44,161.934 44,161.934 ↑ 1.3 14,934 5 / 5

Parallel Seq Scan on vacancies1726 t_10 (cost=0.00..163,190.09 rows=18,709 width=803) (actual time=351.098..44,161.934 rows=14,934 loops=5)

6. 17,798.523 17,798.523 ↓ 4.0 44,768 1 / 5

Parallel Seq Scan on vacancies1727 t_11 (cost=0.00..85,248.99 rows=11,098 width=793) (actual time=1,508.130..88,992.617 rows=44,768 loops=1)

7. 6,754.952 6,754.952 ↓ 4.0 39,053 1 / 5

Parallel Seq Scan on vacancies1703 t_1 (cost=0.00..71,240.44 rows=9,844 width=739) (actual time=1,472.284..33,774.759 rows=39,053 loops=1)

8. 17,813.809 17,813.809 ↓ 3.9 26,435 1 / 5

Parallel Seq Scan on vacancies1730 t_12 (cost=0.00..69,644.01 rows=6,701 width=771) (actual time=1,567.826..89,069.047 rows=26,435 loops=1)

9. 15,434.862 15,434.862 ↓ 4.0 26,909 1 / 5

Parallel Seq Scan on vacancies1712 t_5 (cost=0.00..61,391.90 rows=6,790 width=831) (actual time=0.051..77,174.311 rows=26,909 loops=1)

10. 15,382.103 15,382.103 ↓ 1.3 3,171 3 / 5

Parallel Seq Scan on vacancies1735 t_14 (cost=0.00..60,656.13 rows=2,413 width=739) (actual time=54.552..25,636.839 rows=3,171 loops=3)

11. 24,880.752 24,880.752 ↓ 2.0 14,754 2 / 5

Parallel Seq Scan on vacancies1706 t_2 (cost=0.00..60,329.84 rows=7,484 width=725) (actual time=45.390..62,201.879 rows=14,754 loops=2)

12. 1,181.111 1,181.111 ↓ 4.0 27,698 1 / 5

Parallel Seq Scan on vacancies1718 t_7 (cost=0.00..55,377.98 rows=6,898 width=739) (actual time=0.015..5,905.553 rows=27,698 loops=1)

13. 19.902 19.902 ↓ 3.9 21,642 1 / 5

Parallel Seq Scan on vacancies1710 t_4 (cost=0.00..54,404.07 rows=5,507 width=740) (actual time=0.017..99.510 rows=21,642 loops=1)

14. 30.829 30.829 ↓ 4.0 21,379 1 / 5

Parallel Seq Scan on vacancies1714 t_6 (cost=0.00..43,324.12 rows=5,312 width=750) (actual time=0.013..154.143 rows=21,379 loops=1)

15. 13.975 13.975 ↓ 4.1 18,393 1 / 5

Parallel Seq Scan on vacancies1733 t_13 (cost=0.00..40,371.40 rows=4,540 width=737) (actual time=0.012..69.875 rows=18,393 loops=1)

16. 11.121 11.121 ↓ 4.0 19,032 1 / 5

Parallel Seq Scan on vacancies1722 t_8 (cost=0.00..36,968.96 rows=4,796 width=743) (actual time=0.016..55.604 rows=19,032 loops=1)

17. 8.766 8.766 ↓ 3.1 14,260 1 / 5

Parallel Seq Scan on vacancies1724 t_9 (cost=0.00..25,824.56 rows=4,656 width=739) (actual time=0.021..43.828 rows=14,260 loops=1)

18. 7.064 7.064 ↓ 3.1 12,067 1 / 5

Parallel Seq Scan on vacancies1708 t_3 (cost=0.00..23,150.11 rows=3,911 width=760) (actual time=0.018..35.320 rows=12,067 loops=1)

19. 0.000 0.000 ↓ 0.0 0 1 / 5

Parallel Seq Scan on vacancies17 t (cost=0.00..10.65 rows=65 width=713) (actual time=0.002..0.002 rows=0 loops=1)

Execution time : 145,252.609 ms