explain.depesz.com

PostgreSQL's explain analyze made readable

Result: evTE

Settings
# exclusive inclusive rows x rows loops node
1. 346.828 99,023.422 ↑ 1.1 240,518 1

Gather (cost=1,674,067.80..5,490,890.50 rows=265,000 width=4) (actual time=22,527.623..99,023.422 rows=240,518 loops=1)

  • Workers Planned: 2
  • Workers Launched: 2
  • Functions: 69
  • Options: Inlining true, Optimization true, Expressions true, Deforming true
  • Timing: Generation 6.681 ms, Inlining 124.640 ms, Optimization 305.670 ms, Emission 213.602 ms, Total 650.592 ms
2. 269.642 98,676.594 ↑ 1.4 80,173 3 / 3

Parallel Hash Join (cost=1,673,067.80..5,463,390.50 rows=110,417 width=4) (actual time=22,477.609..98,676.594 rows=80,173 loops=3)

  • Hash Cond: (doc.case_id = c.id)
3. 5,408.313 93,209.410 ↓ 1.0 337,655 3 / 3

Parallel Hash Join (cost=1,403,871.11..5,193,344.91 rows=323,391 width=8) (actual time=17,275.379..93,209.410 rows=337,655 loops=3)

  • Hash Cond: (doc.docket_entry_id = de.id)
4. 70,535.231 70,535.231 ↑ 1.2 10,168,224 3 / 3

Parallel Seq Scan on lex_document doc (cost=0.00..3,740,581.71 rows=12,682,771 width=16) (actual time=4.316..70,535.231 rows=10,168,224 loops=3)

5. 250.729 17,265.866 ↑ 1.2 401,081 3 / 3

Parallel Hash (cost=1,397,981.70..1,397,981.70 rows=471,153 width=16) (actual time=17,265.862..17,265.866 rows=401,081 loops=3)

  • Buckets: 2,097,152 Batches: 1 Memory Usage: 72,864kB
6. 282.569 17,015.137 ↑ 1.2 401,081 3 / 3

Nested Loop (cost=0.56..1,397,981.70 rows=471,153 width=16) (actual time=2.721..17,015.137 rows=401,081 loops=3)

7. 689.341 689.341 ↑ 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.751..689.341 rows=401,081 loops=3)

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

Index Only Scan using lex_docket_entry_pkey on lex_docket_entry de (cost=0.56..2.83 rows=1 width=8) (actual time=0.040..0.040 rows=1 loops=1,203,242)

  • Index Cond: (id = positive_lex_docket_entry_tags.lex_docket_entry_id)
  • Heap Fetches: 0
9. 134.909 5,197.542 ↑ 1.3 249,622 3 / 3

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

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

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

  • Filter: (court_id = 118)
  • Rows Removed by Filter: 483,102
Planning time : 12.941 ms
Execution time : 99,050.330 ms