explain.depesz.com

PostgreSQL's explain analyze made readable

Result: RIXP

Settings
# exclusive inclusive rows x rows loops node
1. 153.952 658.757 ↑ 1.0 1 1

Aggregate (cost=89,390.03..89,390.04 rows=1 width=4) (actual time=656.296..658.757 rows=1 loops=1)

2. 13.936 504.805 ↓ 1.1 86,754 1

Gather (cost=40,505.18..89,193.78 rows=78,500 width=10) (actual time=111.733..504.805 rows=86,754 loops=1)

  • Workers Planned: 1
  • Workers Launched: 1
3. 13.517 490.869 ↑ 1.1 43,377 2 / 2

Hash Join (cost=39,505.18..80,343.78 rows=46,176 width=10) (actual time=108.588..490.869 rows=43,377 loops=2)

  • Hash Cond: ((ex.ex_exame)::bpchar = e.e_cod_nume)
4. 16.713 476.575 ↑ 1.1 43,377 2 / 2

Parallel Hash Join (cost=39,441.46..80,158.58 rows=46,176 width=15) (actual time=107.755..476.575 rows=43,377 loops=2)

  • Hash Cond: (ex.ex_os = p.p_os)
5. 353.650 353.650 ↑ 1.1 43,378 2 / 2

Parallel Index Scan using fu_expac_idx1 on fu_expac ex (cost=0.43..40,596.34 rows=46,176 width=15) (actual time=0.033..353.650 rows=43,378 loops=2)

  • Index Cond: ((ex_data_col >= '2020-08-01 00:00:00'::timestamp without time zone) AND (ex_data_col <= '2020-09-01 00:00:00'::timestamp without time zone))
  • Filter: ((ex_exame)::text = ANY ('{3541,5697,0707,0194,0464,8726,0801,0618,0676,8745,0607,0136,0631,6943,2141,0765,8654,0083,0659,0706,0403,4142,0086,1474,0782,0548,0547,2448,0322,0462,2144,8544,0333,0334,0585,0580,0357,9860,0574,0423,0236,0050,0281,0418,1684,0666,8141,0477,1436,0719,0344,0191,0845,2287,5450,0461,2678,0419,0912,1524,0566,0858,2437,0249,0840,0780,0142,0613,2965,8514,1655,0053,0214,0354,0460,0230,1880,0033,0830,0472,0523,0923,0866,4006,1788,0826,0424,0831,1679,2888,0766,0327,0011,0446,0144,1653,0456,0451,0443,2300,0355,0819,0066,0483,1501,5841,0314,7902,9154,0905,0827,0811,0757,0744,0720,0366,0760,1351,0442,0624,0872,2545,1450,0614,0463,0291,0024,0121,0884,0849,0324,1498,0852,0851,0832,1809,0521,9547,0171,0916,4111,0582,0132,0668,0605,0431,0603,0490,0390,0216,7651,0387,6626,5436,6644,0715,2677,0224,1456,0307,0269,0904,1798,1797,0084,0466,4057,0430,6620,0556,1745,0106,8532,0584,0031,1584,0383,7411,0699,8885,0940,9220,9980,7524,5661,8741,0527,0162,9981,8569,5984,2130,0198,0052,0530,0529,0122,2337,0980,2517,0117,5852,9997,6217,2021,6619,1020,1454,0981,0065,0979,6648,0010,6640,0789,0948,0125,6566,3726,2584,5519,7656,9219,7562,6668,1832,0526,1830,0099,0524,1834,2154,6666,1836,9970,9971,0100,1365,1072,6211,0825,9990,7443,0591,1814,0649,0412,6215,0531,5357,0002,0263,7659,0454,7769,0902,0393,6621,0032,6641,0245,4656,6536,0265,1234,0094,0413,8554,3232,2356,6667,0123,9557,7963,8563,0382,9626,1597,8557,6635,0810,9991,0812,6649,1023,0759,6631,6214,6637,5842,3131,1874,9992,0602,1750,0379,0453,1749,0097,0168,0295,0219,0217,3614,0816,6636,0581,0561,9995,2536,2468,6638,0096,0079,0560,1446,2467,1614,2596,0470,0304,0657,0900,0363,0807,0258,7526,3212,1777,0458,0913,0296,0555,0554,5640,0042,0385,0107,0057,0367,0108,0170,0793,1274,2566,0062,9857,9858,0465,0222,1729,3365,0221,0138,5211,0110,2125,8555,3255,0139,8864,0368,0140,0148,0897,0918,0133,0901,0596,0848,0415,0511,0440}'::text[]))
6. 41.086 106.212 ↑ 1.2 148,013 2 / 2

Parallel Hash (cost=37,258.79..37,258.79 rows=174,579 width=14) (actual time=106.211..106.212 rows=148,013 loops=2)

  • Buckets: 524,288 Batches: 1 Memory Usage: 18,016kB
7. 65.126 65.126 ↑ 1.2 148,013 2 / 2

Parallel Seq Scan on fu_pacie p (cost=0.00..37,258.79 rows=174,579 width=14) (actual time=0.011..65.126 rows=148,013 loops=2)

8. 0.399 0.777 ↑ 1.0 1,939 2 / 2

Hash (cost=39.38..39.38 rows=1,947 width=5) (actual time=0.777..0.777 rows=1,939 loops=2)

  • Buckets: 2,048 Batches: 1 Memory Usage: 87kB
9. 0.378 0.378 ↑ 1.0 1,939 2 / 2

Index Only Scan using pk_bd_exame on bd_exame e (cost=0.28..39.38 rows=1,947 width=5) (actual time=0.026..0.378 rows=1,939 loops=2)

  • Heap Fetches: 126
Planning time : 2.198 ms
Execution time : 658.809 ms