explain.depesz.com

PostgreSQL's explain analyze made readable

Result: CCOg

Settings
# exclusive inclusive rows x rows loops node
1. 372.344 314,890.125 ↑ 1.1 240,518 1

Gather (cost=3,378,948.14..7,194,044.93 rows=265,000 width=4) (actual time=244,237.598..314,890.125 rows=240,518 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Functions: 75
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 8.436 ms, Inlining 161.089 ms, Optimization 347.277 ms, Emission 208.803 ms, Total 725.605 ms
2. 5,029.573 314,517.781 ↑ 1.4 80,173 3 / 3

Parallel Hash Join (cost=3,377,948.14..7,166,544.93 rows=110,417 width=4) (actual time=244,197.114..314,517.781 rows=80,173 loops=3)

  • Hash Cond: (lex_document.docket_entry_id = lex_docket_entry.id)
3. 65,295.176 65,295.176 ↑ 1.2 10,168,224 3 / 3

Parallel Seq Scan on lex_document (cost=0.00..3,740,581.71 rows=12,682,771 width=12) (actual time=0.297..65,295.176 rows=10,168,224 loops=3)

4. 181.636 244,193.032 ↑ 1.2 132,423 3 / 3

Parallel Hash (cost=3,375,937.29..3,375,937.29 rows=160,868 width=16) (actual time=244,193.024..244,193.032 rows=132,423 loops=3)

  • Buckets: 524,288 Batches: 1 Memory Usage: 22,784kB
5. 523.391 244,011.396 ↑ 1.2 132,423 3 / 3

Parallel Hash Join (cost=269,197.25..3,375,937.29 rows=160,868 width=16) (actual time=3,176.103..244,011.396 rows=132,423 loops=3)

  • Hash Cond: (lex_docket_entry.case_id = lex_case.id)
6. 516.673 240,320.087 ↑ 1.2 401,081 3 / 3

Nested Loop (cost=0.56..3,105,503.82 rows=471,153 width=20) (actual time=4.752..240,320.087 rows=401,081 loops=3)

7. 759.337 759.337 ↑ 1.2 401,081 3 / 3

Parallel Seq Scan on positive_lex_docket_entry_tags (cost=0.00..65,115.82 rows=471,153 width=8) (actual time=1.040..759.337 rows=401,081 loops=3)

  • Filter: (tag_id = 15)
  • Rows Removed by Filter: 1,559,717
8. 239,044.077 239,044.077 ↑ 1.0 1 1,203,242 / 3

Index Scan using lex_docket_entry_pkey on lex_docket_entry (cost=0.56..6.45 rows=1 width=12) (actual time=0.596..0.596 rows=1 loops=1,203,242)

  • Index Cond: (id = positive_lex_docket_entry_tags.lex_docket_entry_id)
9. 131.068 3,167.918 ↑ 1.3 249,622 3 / 3

Parallel Hash (cost=265,287.71..265,287.71 rows=312,718 width=4) (actual time=3,167.917..3,167.918 rows=249,622 loops=3)

  • Buckets: 1,048,576 Batches: 1 Memory Usage: 37,536kB
10. 3,036.850 3,036.850 ↑ 1.3 249,622 3 / 3

Parallel Seq Scan on lex_case (cost=0.00..265,287.71 rows=312,718 width=4) (actual time=239.448..3,036.850 rows=249,622 loops=3)

  • Filter: (court_id = 118)
  • Rows Removed by Filter: 483,102
Planning time : 11.904 ms
Execution time : 314,920.415 ms