explain.depesz.com

PostgreSQL's explain analyze made readable

Result: t0L3

Settings
# exclusive inclusive rows x rows loops node
1. 4.480 16,542.325 ↓ 4.3 627 1

Sort (cost=3,398,229.73..3,398,230.09 rows=146 width=182) (actual time=16,542.290..16,542.325 rows=627 loops=1)

  • Sort Key: document_operations.name
  • Sort Method: quicksort Memory: 204kB
2. 177.051 16,537.845 ↓ 4.3 627 1

Nested Loop Left Join (cost=2.00..3,398,224.48 rows=146 width=182) (actual time=1,178.309..16,537.845 rows=627 loops=1)

  • Filter: ((upper((document_operations.name)::text) ~~ '%40110%'::text) OR (upper((document_operations.full_num)::text) ~~ '%40110%'::text) OR ((upper((document_acc_entry_template.name)::text) ~~ '%40110%'::text) AND (document_acc_entry_template.bloc (...)
  • Rows Removed by Filter: 44028
3. 52.888 16,137.519 ↓ 1.2 44,655 1

Nested Loop Left Join (cost=1.57..3,270,076.78 rows=37,759 width=205) (actual time=445.566..16,137.519 rows=44,655 loops=1)

4. 22.399 15,816.701 ↓ 1.2 44,655 1

Nested Loop Left Join (cost=1.14..3,143,439.45 rows=37,759 width=204) (actual time=445.539..15,816.701 rows=44,655 loops=1)

5. 2,510.464 2,510.464 ↓ 1.1 3,037 1

Index Scan using document_operations_ent_id_440d3649d649bd10 on document_operations (cost=0.56..10,082.29 rows=2,659 width=182) (actual time=236.880..2,510.464 rows=3,037 loops=1)

  • Index Cond: (ent_id = 9245)
6. 13,283.838 13,283.838 ↑ 66.5 15 3,037

Index Scan using document_acc_entry_template_operation_id on document_acc_entry_template (cost=0.57..1,168.42 rows=998 width=26) (actual time=3.524..4.374 rows=15 loops=3,037)

  • Index Cond: (document_operations.id = operation_id)
7. 267.930 267.930 ↓ 0.0 0 44,655

Index Scan using account_chart_pkey on account_chart (cost=0.43..3.35 rows=1 width=9) (actual time=0.006..0.006 rows=0 loops=44,655)

  • Index Cond: (document_acc_entry_template.account_debet_id = id)
8. 223.275 223.275 ↓ 0.0 0 44,655

Index Scan using account_chart_pkey on account_chart t4 (cost=0.43..3.35 rows=1 width=9) (actual time=0.005..0.005 rows=0 loops=44,655)

  • Index Cond: (document_acc_entry_template.account_credit_id = id)
Planning time : 1,082.057 ms
Execution time : 16,542.447 ms